Storing lastlogontimestamp in to excelsheet

Welcome Forums General PowerShell Q&A Storing lastlogontimestamp in to excelsheet

Viewing 0 reply threads
  • Author
    Posts
    • #6244
      Member
      Topics: 1562
      Replies: 0
      Points: 0
      Rank: Member

      by Nidhin CK at 2012-12-27 14:28:37

      Hi Experts – I'm trying to export lastlogontimestamp to excelsheet.. Could you please help me on this?

      I'm using bellow command to store the lastlogontimestamp in to excelsheet.
      $sheet1.cells.item($rowno,1) = [DateTime]]::Parse($lastLogonTimestamp))

      below command is working fine but it is not giving the details in user readable format. for eg lastlogontime is showing like 1.30004E+17
      $sheet1.cells.item($rowno,1) = $user.lastLogonTimestamp -Join "`n"

      by Nidhin CK at 2012-12-27 15:20:08

      sorry guys.. it is working fine with below command
      $sheet1.cells.item($rowno,1) = ([DateTime]]::Parse($User.lastLogonTimestamp)))

      by RichardSiddaway at 2013-01-03 10:33:00

      You may find it quicker to create a CSV and import it into Excel

Viewing 0 reply threads
  • The topic ‘Storing lastlogontimestamp in to excelsheet’ is closed to new replies.