Organize / Sort data of the array in Powershell

Question

I have an array which holds the logon info of the users as objects. Here are the printings of that array:

PS> $Write-Out $data1
System.Object System.Object System.Object System.Object System.Object System.Object System.Object

PS> $data1 
ComputerName       User               Time                      Action                            
------------       ----               -------------------       ------
DC1                usr1               05/06/2013 11:51:35       logoff                         
DC1                usr1               05/06/2013 11:46:24       logon                         
DC1                usr1               05/06/2013 11:42:05       logoff
DC2                usr2               05/06/2013 11:44:08       logon
DC2                Administrator      05/06/2013 11:43:50       logoff
DC2                Administrator      05/06/2013 11:42:53       logon
DC2                Administrator      05/06/2013 11:40:27       logoff

I want to convert this array so that I can see logon and logoff times on the same line like this:

PS> $data2
ComputerName      User               Time LOGON           Time LOGOFF      
------------      ----               -------------------  -------------------                  
DC1               usr1               05/06/2013 11:46:24  05/06/2013 11:51:35                         
DC1               usr1                                    05/06/2013 11:42:05       
DC2               usr2               05/06/2013 11:44:08                        
DC2               Administrator      05/06/2013 11:42:53  05/06/2013 11:43:50
DC2               Administrator                           05/06/2013 11:40:27

Can you help me with converting the $data1 array to $data2 array?

Can you give the Command line that generate $data1 ?

JPBlanc
– JPBlanc

2013-06-05 15:04:30 +00:00
Commented Jun 5, 2013 at 15:04 — JPBlanc
– JPBlanc, Commented Jun 5, 2013 at 15:04

Fred Ng · Accepted Answer · 2013-06-05 15:44:28Z

1

I think you should create your own object and assign the values from your $data1. You could do something like :

    $readableData1| Select ComputerName,User #Just an example to create a simple object
    $data1|%{ #Foreach line in $data1

    $readabledata.ComputerName = $_.ComputerName.ToString()
    $readabledata.User= $_.User.ToString()

    $array+= $readableData1
    }

echo $array

edited Jun 5, 2013 at 15:44

answered Jun 5, 2013 at 15:38

Fred Ng

1151 silver badge8 bronze badges

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

1 Comment

Korki Korkig Over a year ago

Custom objects from $data1 would be a way;) The code doesn't work but I got the idea. Thanks!

Davor Josipovic · Accepted Answer · 2013-06-05 21:23:52Z

0

Try this. It will give you the same $data2, based on your $data1, but might contain bugs.

$data2 = $data1 | Group-Object -Property ComputerName, User | foreach { # group
    foreach ($r in $_.Group) { # record
        if ($r.Action -eq "logon") {
            New-Object PSObject -Property @{"Time LOGOFF"=$off; "Time LOGON"=$r.Time; User=$r.User; ComputerName=$r.ComputerName};
            $off = $null;
            continue;
        } else {$off = $r.Time;}
    }
    if ($off) {New-Object PSObject -Property @{"Time LOGOFF"=$off; "Time LOGON"=""; User=$r.User; ComputerName=$r.ComputerName}; $off=$null;}
}

answered Jun 5, 2013 at 21:23

Davor Josipovic

5,5532 gold badges46 silver badges63 bronze badges

Collectives™ on Stack Overflow

Organize / Sort data of the array in Powershell

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related