Script to export to excel

-

i have below script:-- looking convert output excel format

$servers = get-content “c:\list.txt”
foreach ($server in $servers)
{
$server
$command = “quser /server:” + $server
invoke-expression $command 
}


when executed getting in below format output.

server1
 username              sessionname        id  state   idle time  logon time
 vdw231                ica-tcp#8           7  active          .  11/5/2012 10:40 am
 vdw232                ica-tcp#60         16  active      16:18  11/5/2012 2:22 pm
 vdw233                ica-tcp#71          3  active          .  11/6/2012 6:10 am
 vdw234                ica-tcp#72          1  active          3  11/6/2012 6:59 am
 vdw235                ica-tcp#73          5  active          .  11/6/2012 6:59 am
 vdw236                rdp-tcp#74          2  active          .  11/6/2012 7:07 am
server2
 username              sessionname        id  state   idle time  logon time
 vdw210                ica-tcp#44         14  active      13:50  11/5/2012 9:03 am
 vdw211                ica-tcp#67          6  active          .  11/6/2012 1:56 am
 vdw212                ica-tcp#70          1  active         45  11/6/2012 6:34 am
 vdw213                ica-tcp#72          9  active         25  11/6/2012 6:53 am
 vdw214  
server3
 username              sessionname        id  state   idle time  logon time
 vdw215                rdp-tcp#131         1  active         19  11/5/2012 1:42 am
 vdw216                rdp-tcp#132         4  active         17  11/5/2012 2:06 am
 vdw217                rdp-tcp#143         6  active          .  11/6/2012 3:31 am

my requirement wanted to convert this output excel format for submitting to management. below excel format thinking...to have above script...


$result = @() $servers = get-content "c:\list.txt"  foreach ($server in $servers) { 	$result += quser /server:$server | select -skip 1 | foreach { 		$obj = $_ -split "\s{2,}" 		if($obj.count -eq 5) { 			$sn = "" 		} 		else { 			$sn = $obj[1] 		} 		new-object psobject -property @{ 			"servername" =  $server 			"username" = $obj[0].trim()             			"sessionname" = $sn         			"id" = $obj[-4]  			"state"  = $obj[-3]   			"idle time" = $obj[-2]   			"logon time"= $obj[-1]  		} 	} }  $result | select "servername","username","sessionname","id","state","idle time","logon time" | export-csv result.csv -notype



Windows Server  >  Windows PowerShell



Comments

Post a Comment

Popular posts from this blog

Generating Event ID 91, 44 with CA (In Event Viewer with source as Certsvc)

-
hi we in process of migrating win 2003 ad win2008 r2. when noticed logs found many errors , warning alerts ca below --could not connect active directory. certificate services retry when processing requires active directory access. (event id 91)----certificate services sagia ca can not open certificate store @ cn=ntauthcertificates,cn=public key services,cn=services in active directory's configuration container. (event id 94, warning)--                                                                                            ...
Read more

Group policy default policy cannot be edited because network name not found

-
hey everyone, i have been having issues on , off domain. pdc crashed (the domain controller). started old server , made domain controller , forced roles over. repaired pdc , elevated back. although appeared work found cannot rid of other dc because pdc can no longer contact domain things group policy or else. start secondary , domain magically reachable. although while secondary down can ping domain , replies ip of pdc appears pdc has no control on anything. questions following. 1. gpos created before crash no longer work. rebuilt sysvol , default problem can't edit default domain policy. don't believe having replication problems new repairing domains setting them , maintaining them of education came from.  2. if pdc gpo management console can't access gpos can secondary not have installed? 3. why domain unreachable if no dcs online when shutdown secondary. thanks in advance , try edit dc diag log right there on fails want narrow of out guys concentrate on...
Read more

Problem when changing update source

-
hi all, we use win server 2008 r2 enterprise , wsus 3.2. until last friday, downoloading updates microsoft's website. had change the source wsus server in our headquarters (not being replica server). started problem: our product , classification changed, downloading lot of updates hadn't ever downloaded. now, when try modify update soure (to microsoft's web site again) set option console falls down - database error - , copying error clipboard, have message bellow: the wsus administration console unable connect wsus server database.     verify sql server running on wsus server. if problem persists, try restarting sql.     system.data.sqlclient.sqlexception -- maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). info:spsetconfiguration - synctomu or upstreamservername config value changed - no reset source .net sqlclient data provider stack trace:    @ microsoft.updateservices.ui.admi...
Read more