{"id":17421,"date":"2010-08-15T00:01:00","date_gmt":"2010-08-15T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2010\/08\/15\/using-powershell-to-format-a-report-from-xml-data\/"},"modified":"2010-08-15T00:01:00","modified_gmt":"2010-08-15T00:01:00","slug":"using-powershell-to-format-a-report-from-xml-data","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/using-powershell-to-format-a-report-from-xml-data\/","title":{"rendered":"Using PowerShell to Format a Report from XML Data"},"content":{"rendered":"

Summary<\/b>: Use Windows PowerShell to create a formatted report from data stored in XML files.<\/p>\n

 <\/p>\n

Microsoft Scripting Guy Ed Wilson here. It is still dark outside, and the lights of the neighborhood are slowly beginning to come on. It is really<\/i> humid this morning. I am sitting at the kitchen table with my laptop checking comments that were posted to the Hey, Scripting Guy! Blog<\/a>. When I was talking to my friends in Australia<\/a> the other day, they were complaining that it was only 5 degrees Celsius (41 degrees Fahrenheit). To me that sounds great (the weather guesser is predicting 37 degrees Celsius—100 degrees Fahrenheit today).<\/p>\n

Yesterday<\/a>, I talked with you about using Group Policy<\/a> to deploy the script I wrote to collect process information. <\/p>\n

The GPO has now had time to replicate among my various domain controllers and has updated the various workstations on my network (doesn’t everyone have multiple domain controllers at home?). The network share that is collecting the XML files that are produced via this logon process is shown in the following image.<\/p>\n

\"Image<\/a> <\/p>\n

Because the entire point of this exercise is to reduce the amount of manual work involved in examining startup processes, I realized I needed to write a script that would automatically process the XML files for me. The ParseProcesses.ps1 script is shown here. <\/p>\n

ParseProcesses.ps1<\/strong><\/p>\n

Get-ChildItem<\/span> <\/span>-path<\/span> <\/span>\\\\hyperv-box\\shared<\/span> <\/span>-Include<\/span> “Process*.xml” <\/span>-Recurse<\/span> <\/span>|<\/span>
<\/span>ForEach-Object<\/span> <\/span>{<\/span>
<\/span>New-Variable<\/span> <\/span>-Name<\/span> <\/span>$_<\/span>.baseName<\/span> <\/span>-Value<\/span> <\/span>(<\/span>Import-Clixml<\/span> <\/span>-path<\/span> <\/span>$_<\/span>.FullName)<\/span>
<\/span>}<\/span>
“Getting startup time:”
<\/span>Get-Variable<\/span> <\/span>-Name<\/span> <\/span>Process1*<\/span> <\/span>|<\/span>
<\/span>ForEach-Object<\/span> <\/span>{<\/span> 
<\/span>$v1<\/span> <\/span>=<\/span> <\/span>New-Variable<\/span> <\/span>-Name<\/span> “$($_.name.substring(9))Smss” <\/span>-Value<\/span> <\/span>(<\/span>$_<\/span>.value<\/span> <\/span>|<\/span> 
<\/span>where-object<\/span> <\/span>{<\/span>$_<\/span>.name<\/span> <\/span>-eq<\/span> “smss”<\/span>})<\/span> <\/span>-passthru<\/span>
<\/span>$v2<\/span> <\/span>=<\/span> <\/span>New-Variable<\/span> <\/span>-Name<\/span> “$($_.name.substring(9))Search” <\/span>-Value<\/span> <\/span>(<\/span>$_<\/span>.value<\/span> <\/span>|<\/span> 
<\/span>Where-Object<\/span> <\/span>{<\/span>$_<\/span>.name<\/span> <\/span>-eq<\/span> “SearchIndexer”<\/span>})<\/span> <\/span>-passthru<\/span>
“$($_.name.substring(9)) start time $( $($v2.value.startTime) – 
$($v1.value.startTime) )”
“Startup process order:”
<\/span>$_<\/span>.Value<\/span> <\/span>|<\/span> <\/span>Sort-Object<\/span> <\/span>-Property<\/span> <\/span>startTime<\/span> <\/span>|<\/span>
<\/span>Format-Table<\/span> <\/span>-Property<\/span> <\/span>name,<\/span> <\/span>starttime<\/span> <\/span>-AutoSize<\/span>
<\/span>}<\/span>
“Listing Process counts:”
<\/span>Get-Variable<\/span> <\/span>-Name<\/span> <\/span>process*<\/span> <\/span>|<\/span> <\/span>Sort-Object<\/span> <\/span>-Property<\/span> <\/span>name<\/span> <\/span>|<\/span>
<\/span>Format-Table<\/span> <\/span>-Property<\/span> <\/span>name,<\/span> 
<\/span>@{LABEL<\/span>=<\/span>“count”<\/span>;<\/span>EXPRESSION<\/span> <\/span>=<\/span> <\/span>{<\/span>$_<\/span>.value.count}<\/span> <\/span>}<\/span> <\/span>-autosize<\/span>
“Getting the late starting processes from point 4”
<\/span>Get-Variable<\/span> <\/span>-Name<\/span> <\/span>process4*<\/span> <\/span>|<\/span> 
<\/span>ForEach-Object<\/span> <\/span>{<\/span>
“$($_.name.substring(9))”
<\/span>$task<\/span> <\/span>=<\/span> <\/span>$_<\/span>.value<\/span> <\/span>|<\/span> <\/span>Where-Object<\/span> <\/span>{<\/span> <\/span>$_<\/span>.name<\/span> <\/span>-eq<\/span> ‘taskhost’<\/span>}<\/span>
<\/span>$_<\/span>.value<\/span> <\/span>|<\/span> <\/span>Where-Object<\/span> <\/span>{<\/span> <\/span>$_<\/span>.startTime<\/span> <\/span>-gt<\/span> <\/span>$task<\/span>.startTime<\/span> <\/span>}<\/span> <\/span>|<\/span>
<\/span>Sort-Object<\/span> <\/span>-Property<\/span> <\/span>company<\/span> <\/span>|<\/span> 
<\/span>Format-Table<\/span> <\/span>-Property<\/span> <\/span>name,company,<\/span> <\/span>product,<\/span> <\/span>starttime<\/span> <\/span>-AutoSize<\/span>
<\/span>$task<\/span> <\/span>=<\/span> <\/span>$null<\/span>
<\/span>}<\/span> <\/p>\n

The ParseProcesses.ps1 script begins by obtaining a listing of all the XML files in the \\\\hyperv-box\\shared folder that begin with the Word Process<\/b>. It then creates a new variable using the baseName<\/b> of the file that contains the reconstituted process object. This section of the script is shown here: <\/p>\n

Get-ChildItem<\/span> <\/span>-path<\/span> <\/span>\\\\hyperv-box\\shared<\/span> <\/span>-Include<\/span> “Process*.xml” <\/span>-Recurse<\/span> <\/span>|<\/span>
<\/span>ForEach-Object<\/span> <\/span>{<\/span>
<\/span>New-Variable<\/span> <\/span>-Name<\/span> <\/span>$_<\/span>.baseName<\/span> <\/span>-Value<\/span> <\/span>(<\/span>Import-Clixml<\/span> <\/span>-path<\/span> <\/span>$_<\/span>.FullName)<\/span>
<\/span>}<\/span> <\/p>\n

The next section of the script is a bit jumbled. After displaying a message about getting the startup time, the script gets every variable that begins with the name Process1<\/b>. These will be the first data points for each<\/a> computer that has data stored in the folder. Now a new variable is created that contains only an SMSS process object. Next, a new variable is created that only contains a SearchIndexer<\/b> process object. The starttime<\/b> of the SMSS process is subtracted from the starttime<\/b> of the SearchIndexer<\/b> process, and the result is displayed. Next, a sorted list of all processes from the first process snapshot is displayed in a table. This section of the script is shown here:<\/p>\n

“Getting startup time:”
<\/span>Get-Variable<\/span> <\/span>-Name<\/span> <\/span>Process1*<\/span> <\/span>|<\/span>
<\/span>ForEach-Object<\/span> <\/span>{<\/span> 
<\/span>$v1<\/span> <\/span>=<\/span> <\/span>New-Variable<\/span> <\/span>-Name<\/span> “$($_.name.substring(9))Smss” <\/span>-Value<\/span> <\/span>(<\/span>$_<\/span>.value<\/span> <\/span>|<\/span> 
<\/span>where-object<\/span> <\/span>{<\/span>$_<\/span>.name<\/span> <\/span>-eq<\/span> “smss”<\/span>})<\/span> <\/span>-passthru<\/span>
<\/span>$v2<\/span> <\/span>=<\/span> <\/span>New-Variable<\/span> <\/span>-Name<\/span> “$($_.name.substring(9))Search” <\/span>-Value<\/span> <\/span>(<\/span>$_<\/span>.value<\/span> <\/span>|<\/span> 
<\/span>Where-Object<\/span> <\/span>{<\/span>$_<\/span>.name<\/span> <\/span>-eq<\/span> “SearchIndexer”<\/span>})<\/span> <\/span>-passthru<\/span>
“$($_.name.substring(9)) start time $( $($v2.value.startTime) – 
$($v1.value.startTime) )”
“Startup process order:”
<\/span>$_<\/span>.Value<\/span> <\/span>|<\/span> <\/span>Sort-Object<\/span> <\/span>-Property<\/span> <\/span>startTime<\/span> <\/span>|<\/span>
<\/span>Format-Table<\/span> <\/span>-Property<\/span> <\/span>name,<\/span> <\/span>starttime<\/span> <\/span>-AutoSize<\/span>
<\/span>}<\/span> <\/p>\n

This portion of the report is shown in the following image.<\/p>\n

\"Image<\/a> <\/p>\n

A table listing the process counts from each of the process snapshots is created. The table uses a custom column that displays a count of the processes. This is shown here:<\/p>\n

“Listing Process counts:”
<\/span>Get-Variable<\/span> <\/span>-Name<\/span> <\/span>process*<\/span> <\/span>|<\/span> <\/span>Sort-Object<\/span> <\/span>-Property<\/span> <\/span>name<\/span> <\/span>|<\/span>
<\/span>Format-Table<\/span> <\/span>-Property<\/span> <\/span>name,<\/span> 
<\/span>@{LABEL<\/span>=<\/span>“count”<\/span>;<\/span>EXPRESSION<\/span> <\/span>=<\/span> <\/span>{<\/span>$_<\/span>.value.count}<\/span> <\/span>}<\/span> <\/span>-autosize<\/span> <\/p>\n

The process counts portion of the report is shown in the following image.<\/p>\n

\"Image<\/a> <\/p>\n

The last thing that is done is to look at all the processes that start up during the final process snapshot. The taskhost<\/b> process is used as the starting point for this list. The processes, the starttime, the company name, and product name are all listed in a table. This section of the code is shown here:<\/p>\n

“Getting the late starting processes from point 4”
<\/span>Get-Variable<\/span> <\/span>-Name<\/span> <\/span>process4*<\/span> <\/span>|<\/span> 
<\/span>ForEach-Object<\/span> <\/span>{<\/span>
“$($_.name.substring(9))”
<\/span>$task<\/span> <\/span>=<\/span> <\/span>$_<\/span>.value<\/span> <\/span>|<\/span> <\/span>Where-Object<\/span> <\/span>{<\/span> <\/span>$_<\/span>.name<\/span> <\/span>-eq<\/span> ‘taskhost’<\/span>}<\/span>
<\/span>$_<\/span>.value<\/span> <\/span>|<\/span> <\/span>Where-Object<\/span> <\/span>{<\/span> <\/span>$_<\/span>.startTime<\/span> <\/span>-gt<\/span> <\/span>$task<\/span>.startTime<\/span> <\/span>}<\/span> <\/span>|<\/span>
<\/span>Sort-Object<\/span> <\/span>-Property<\/span> <\/span>company<\/span> <\/span>|<\/span> 
<\/span>Format-Table<\/span> <\/span>-Property<\/span> <\/span>name,company,<\/span> <\/span>product,<\/span> <\/span>starttime<\/span> <\/span>-AutoSize<\/span>
<\/span>$task<\/span> <\/span>=<\/span> <\/span>$null<\/span>
<\/span>}<\/span> <\/p>\n

The process table report from this portion of the script is shown here.<\/p>\n

\"Image<\/a> <\/p>\n

Join us tomorrow as we begin User Management Week. We invite you to follow us on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to us at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n

 <\/p>\n

Ed Wilson and Craig Liebendorfer, Scripting Guys<\/b><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Use Windows PowerShell to create a formatted report from data stored in XML files.   Microsoft Scripting Guy Ed Wilson here. It is still dark outside, and the lights of the neighborhood are slowly beginning to come on. It is really humid this morning. I am sitting at the kitchen table with my laptop […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[25,31,87,3,4,61,45],"class_list":["post-17421","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-displaying-output","tag-operating-system","tag-processes","tag-scripting-guy","tag-scripting-techniques","tag-weekend-scripter","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Use Windows PowerShell to create a formatted report from data stored in XML files.   Microsoft Scripting Guy Ed Wilson here. It is still dark outside, and the lights of the neighborhood are slowly beginning to come on. It is really humid this morning. I am sitting at the kitchen table with my laptop […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/17421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=17421"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/17421\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=17421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=17421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=17421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}