Format object like SQL Table in PowerShell

Question

Say I have collected these counters with Perfmon:

$MemCounters = (Get-Counter -ListSet Memory).Paths
$hello = Get-Counter -Counter $MemCounters -MaxSamples 2

Now I would like to display the result where I both can see the Counter values but also the timestamp for when the counter is from:

$hello.CounterSamples  
$hello.CounterSamples.Timestamp

I would like column 1 to be $hello.CounterSamples.Timestamp and column 2 to be $hello.CounterSamples so that I later can import the data to SQL.

Olaf · Accepted Answer · 2023-01-31 06:38:23Z

1

Since there are several counter samples per timestamp you have to extract them with a nested loop ...

$hello |
ForEach-Object {
    $CounterSampleList = $_.CounterSamples
    foreach ($CounterSample in $CounterSampleList) {
        [PSCustomObject]@{
            TimeStamp                = $_.TimeStamp
            CounterSamplePath        = $CounterSample.Path
            CounterSampleCookedValue = $CounterSample.CookedValue
        }
    }
}

edited Jan 31, 2023 at 6:38

answered Jan 31, 2023 at 6:11

Olaf

5,3052 gold badges20 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Format object like SQL Table in PowerShell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related