<div>
Infact it would also be useful if I could add a column to the data with average run rates etc based on other columns data... If someone could show me roughly how I could acheive that I should be able to work the rest out... Code so far (coutesy of segwig is...)<br />
<br />

<pre><code id="code-20-38863590-1">$total= 5785
'MAC1,'MAC2','MAC3','MAC4' | %{
$path = &quot;\\$_\Z$\TEST\ROUTE&quot;
$mach = $_
Get-ChildItem $path -include ('initialised.txt') -recurse | Select-Object CreationTime, LastWriteTime, @{Name=&quot;Machine&quot;;Expression={$mach}} , @{Name=&quot;Harness&quot;;Expression={($_.Directory -Replace ([regex]::Escape(&quot;\\$_\Z$\TEST\ROUTE&quot;),&quot;&quot;))}}, @{Name=&quot;TotalHarnesses&quot;;Expression={$total_harnesses}}, @{Name=&quot;RunTime&quot;;Expression={&quot;{0:N0}&quot; -f ($_.LastWriteTime - $_.CreationTime).TotalMinutes}}| Where-Object {$_.RunTime -gt 0} | Sort-Object CreationTime 
} # | Export-Csv &quot;C:\MachineLoad.txt&quot;</code></pre>
</div>


Infact it would also be useful if I could add a column to the data with average run rates etc based on other columns data... If someone could show me roughly how I could acheive that I should be able to work the rest out... Code so far (coutesy of segwig is...)



$total= 5785
'MAC1,'MAC2','MAC3','MAC4' | %{
$path = "\\$_\Z$\TEST\ROUTE"
$mach = $_
Get-ChildItem $path -include ('initialised.txt') -recurse | Select-Object CreationTime, LastWriteTime, @{Name="Machine";Expression={$mach}} , @{Name="Harness";Expression={($_.Directory -Replace ([regex]::Escape("\\$_\Z$\TEST\ROUTE"),""))}}, @{Name="TotalHarnesses";Expression={$total_harnesses}}, @{Name="RunTime";Expression={"{0:N0}" -f ($_.LastWriteTime - $_.CreationTime).TotalMinutes}}| Where-Object {$_.RunTime -gt 0} | Sort-Object CreationTime 
} # | Export-Csv "C:\MachineLoad.txt"

<div>
Sorry for the late reply, perfect answer!
</div>


Sorry for the late reply, perfect answer!

<div>
<div class="content wysiwyg-content">
I have a load of data which I am applying a Sort-Object to, is there a way I can add a row number to the data after the sort. I will be using this to calculate a percentage of the overall work complete...
</div>
</div>


I have a load of data which I am applying a Sort-Object to, is there a way I can add a row number to the data after the sort. I will be using this to calculate a percentage of the overall work complete...

Add row number to data after sort-object has been applied

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.