String to Array in PowerShell (with no delimiters)

Question

I'm trying to use WMI to get the start times of a computer's login sessions using:

$starttimes = Get-WmiObject Win32_LogonSession -ComputerName HM-ITS-KLP |
              select starttime

This gives me the date formatted as:

20170120075444.819609+000 (yyyymmddhhmmss.??????+???)

Using the String.ToCharArray() method I managed to convert a string to an array so that I could restructure it better, although in this format it will not accept this as:

Method invocation failed because [Selected.System.Management.ManagementObject] doesn't contain a method named 'ToCharArray'.

Whole code as follows:

$starttimes = Get-WmiObject Win32_LogonSession -ComputerName HM-ITS-KLP |
              select StartTime
foreach ($line in $starttimes) {
  $dateArray = $line.ToCharArray()
  $time = $dateArray[8..9] + ":" + $dateArray[10..11] + ":" + $dateArray[12..13]
  $date = $dateArray[6..7] + "/" + $dateArray[4..5] + "/" + $dateArray[0..3]
  $LoginTimeAndDate1 = $time + "  " + $date
  $LoginTimeAndDate = $LoginTimeAndDate1 -join ""
}

I would strongly recommend converting the strings to actual DateTime values rather than messing around with character arrays. — Ansgar Wiechers
– Ansgar Wiechers, Commented Jan 23, 2017 at 15:09

Kirill Pashkov · Accepted Answer · 2017-01-23 14:15:43Z

5

You forgot to expand the "starttime" property. Try change to this:

foreach ( $line in $starttimes){
$dateArray = $line.starttime.toCharArray()

or this:

foreach ( $line in $starttimes.starttime){
$dateArray = $line.toCharArray()

or this:

$starttimes = Get-WMIObject Win32_LogonSession |  select -Expand starttime
foreach ( $line in $starttimes){

answered Jan 23, 2017 at 14:15

Kirill Pashkov

3,2461 gold badge19 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

M24Kermit Over a year ago

Thankyou very much, solved my problem straight away!

Esperento57 · Accepted Answer · 2017-01-23 18:10:19Z

1

try this:

Get-WmiObject Win32_LogonSession -ComputerName "HM-ITS-KLP" | select  @{N='starttime';E={$_.ConvertToDateTime($_.starttime)}}

answered Jan 23, 2017 at 18:10

Esperento57

17.6k6 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

String to Array in PowerShell (with no delimiters)

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related