Import-Counter

Import-Counter [-Path] <string[]> [-Counter <string[]>] [-EndTime <DateTime>] [-MaxSamples <Int64>] [-StartTime <DateTime>] [<CommonParameters>]

Import-Counter [-Path] <string[]> -ListSet <string[]> [<CommonParameters>]

Import-Counter [-Path] <string[]> -Summary <switch> [<CommonParameters>]

C:\PS>$data = import-counter -path ProcessorData.csv

This command imports all of the counter data from the ProcessorData.csv file into the $data variable.

C:\PS>$i = import-counter -path ProcessorData.blg -counter "\\SERVER01\Processor(_Total)\Interrupts/sec"

This command imports only the Processor(_total)\Interrupts\sec counter data from the ProcessorData.blg file into the $i variable.

C:\PS>$data = import-counter .\processordata.blg

C:\PS> $data[0].countersamples | format-table path

Path
----
\\SERVER01\Processor(_Total)\DPC Rate
\\SERVER01\Processor(1)\DPC Rate
\\SERVER01\Processor(0)\DPC Rate
\\SERVER01\Processor(_Total)\% Idle Time
\\SERVER01\Processor(1)\% Idle Time
\\SERVER01\Processor(0)\% Idle Time
\\SERVER01\Processor(_Total)\% C3 Time
\\SERVER01\Processor(1)\% C3 Time
...

    
C:\PS> $IntCtrs = $data[0].countersamples | where {$_.path -like "*interrupts/sec"} | foreach {$_.path}
    

C:\PS> $IntCtrs

\\SERVER01\Processor(_Total)\Interrupts/sec
\\SERVER01\Processor(1)\Interrupts/sec
\\SERVER01\Processor(0)\Interrupts/sec


C:\PS> $i = import-counter -path .\processordata.blg -counter $intCtrs
    
C:\PS> $i | export-counter -path .\interrupts.csv -format CSV


Description
-----------
This example shows how to select data from a performance counter log file (.blg) and then export the selected data to a .csv file.

The first four commands get the counter paths from the file and save them in a variable. The last two commands import selected data and then export only the selected data.

The first command uses Import-Counter to import all of the performance counter data from the ProcessorData.blg files. The command saves the data in the $data variable.

The second command displays the counter paths in the $data variable. The display is shown in the command output.

The third command gets the counter paths that end in "Interrupts/sec" and saves the paths in the $IntCtrs variable.

The fourth command displays the selected counter paths.

The fifth command uses the Import-Counter cmdlet to import the data. It uses the Counter parameter with the $IntCtrs variable to import only data for the counter paths in $IntCtrs.

The sixth command uses the Export-Counter cmdlet to export the data.

C:\PS>import-counter -path processordata.csv -listset *

CounterSetName     : Processor
MachineName        : \\SERVER01
CounterSetType     : MultiInstance
Description        : The Processor performance object consists of counters that measure aspects of processor activity T
                     he processor is the part of the computer that performs arithmetic and logical computations, initia
                     tes operations on peripherals, and runs the threads of processes.  A computer can have multiple pr
                     ocessors.  The processor object represents each processor as an instance of the object.
Paths              : {\\SERVER01\Processor(*)\DPC Rate, \\SERVER01\Processor(*)\% Idle Time, \\SERVER01\Processor
                     (*)\% C3 Time, \\SERVER01\Processor(*)\% Interrupt Time...}
PathsWithInstances : {\\SERVER01\Processor(_Total)\DPC Rate, \\SERVER01\Processor(1)\DPC Rate, \\SERVER01\Process
                     or(0)\DPC Rate, \\SERVER01\Processor(_Total)\% Idle Time...}

C:\PS> import-counter -path processordata.csv -listset * | foreach {$_.paths}

\\SERVER01\Processor(*)\DPC Rate
\\SERVER01\Processor(*)\% Idle Time
\\SERVER01\Processor(*)\% C3 Time
\\SERVER01\Processor(*)\% Interrupt Time
\\SERVER01\Processor(*)\% C2 Time
\\SERVER01\Processor(*)\% User Time
\\SERVER01\Processor(*)\% C1 Time
\\SERVER01\Processor(*)\% Processor Time
\\SERVER01\Processor(*)\C1 Transitions/sec
\\SERVER01\Processor(*)\% DPC Time
\\SERVER01\Processor(*)\C2 Transitions/sec
\\SERVER01\Processor(*)\% Privileged Time
\\SERVER01\Processor(*)\C3 Transitions/sec
\\SERVER01\Processor(*)\DPCs Queued/sec
\\SERVER01\Processor(*)\Interrupts/sec


Description
-----------
This example shows how to display all the counter paths in a group of imported counter sets. 

The first command uses the ListSet parameter to get all of the counter sets that are represented in a counter data file.

The second command gets all of the counter paths from the list set.

C:\PS>import-counter -path .\disk.blg | format-table timestamp

C:\PS> $start = [datetime]"7/9/2008 3:47:00 PM"
C:\PS> $end = [datetime]"7/9/2008 3:47:59 PM"

C:\PS> $t-data = import-counter -path disk.blg -starttime $start -endtime $end

This example imports only the counter data that has a time stamp between the starting an ending ranges specified in the command.

The first command lists the time stamps of all of the data in the ProcessorData.blg file.

The second and third commands save particular time stamps in the $start and $end variables. The strings are cast to DateTime objects.

The fourth command uses Import-Counter to get only counter data that has a time stamp between the start and end times (inclusive). The command uses the StartTime and EndTime parameters to specify the range.

C:\PS>import-counter -path disk.blg -maxSamples 5

C:\PS> (import-counter -path disk.blg)[-1 .. -5]

This example shows how to import the five oldest and five newest samples from a performance counter log file.

The first command uses the Import-Counter cmdlet to import data from the Disk.blg file. The command uses the MaxSamples parameter to limit the import to five counter samples. This command gets the first (oldest) five samples in the file.

The second command uses array notation and the Windows PowerShell range operator (..) to get the last five counter samples from the file. These are the five newest samples.

C:\PS>import-counter D:\Samples\memory.blg -summary

PS C:\ps-test> import-counter D:\Samples\memory.blg -summary

OldestRecord            NewestRecord            SampleCount
------------            ------------            -----------
7/10/2008 2:59:18 PM    7/10/2008 3:00:27 PM    1000


Description
-----------
This command uses the Summary parameter to get a summary of the counter data from the Memory.blg file.

C:\PS>$counters = import-counter olddata.blg -ListSet * | foreach {$_.PathsWithInstances}

get-counter -counter $counters -maxSamples 20 | export-counter c:\Logs\newdata.blg

This example updates a performance counter log file. 

The first command uses the ListSet parameter of Import-Counter to get the counters in OldData.blg, an existing counter log file. The command uses a pipeline operator (|) to send the data to a Foreach-Object command that gets only the values of the PathsWithInstances property of each object.

The second command uses those same counters in a new Get-Counter command to get a current sample, and export it to the NewData.blg file.

C:\PS>$counters = "d:\test\pdata.blg", "d:\samples\netlog.blg" | import-counter

This command imports performance log data from two logs and saves the data in the $counters variable. The command uses a pipeline operator to send performance log paths to Import-Counter. 

Notice that each path is enclosed in quotation marks and that the paths are separated from each other by a comma.