All Apps and Add-ons

Windows Powershell Transcription: Parsing events

henryyam
Explorer

How are people parsing the powershell transcriptions files which have a large amount of command executions within the file?

For those not familiar, Powershell Transcription will create a log file once a user starts their powershell transaction.
It will log the users name at the top of the file and will not close the file until the command is closed.

In some cases we have a MMC running open all week and this can produce 100's of commands within the powershell transaction file.
Unfortunately, it only logs the user name who initially executed the command at the start at the launch of the process. The subsequent entries just show the command and output.

How do you associate the users name with each of these commands if you want to keep them as separate events?
Or are you just bundling all of those commands into one event?

Or has someone found a way to associate the username to each command?

Windows PowerShell transcript start

Start time: 20190216091018
Username: XYZ
RunAs User: ABC
Configuration Name: 
Machine: HOSTNAME 
Host Application: C:\WINDOWS\system32\mmc.exe 
Process ID: 1111
PSVersion: 5.1.111
PSEdition: Desktop
PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1.17134.590
BuildVersion: 10.0.17134
CLRVersion: 4.0.30319
WSManStackVersion: 3.0
PSRemotingProtocolVersion: 2.3
SerializationVersion: 1.1.

Command start time: 20190216091032

PS>CommandInvocation(Get-ConfigInstalledDBVersion): "Get-ConfigInstalledDBVersion"
>> ParameterBinding(Get-ConfigInstalledDBVersion): name="AdminAddress"; value="xyz.com:80"
>> ParameterBinding(Get-ConfigInstalledDBVersion): name="Upgrade"; value="True"

Command start time: 20190216091031

PS>CommandInvocation(Get-ConfigInstalledDBVersion): "Get-ConfigInstalledDBVersion"
>> ParameterBinding(Get-ConfigInstalledDBVersion): name="AdminAddress"; value="xyz.com:80"
>> ParameterBinding(Get-ConfigInstalledDBVersion): name="Upgrade"; value="True"

Command start time: 20190216091032

PS>CommandInvocation(Get-ConfigInstalledDBVersion): "Get-ConfigInstalledDBVersion"
>> ParameterBinding(Get-ConfigInstalledDBVersion): name="AdminAddress"; value="xyz.com:80"
>> ParameterBinding(Get-ConfigInstalledDBVersion): name="Upgrade"; value="True"

Command start time: 20190216091034

PS>CommandInvocation(Get-ConfigInstalledDBVersion): "Get-ConfigInstalledDBVersion"
>> ParameterBinding(Get-ConfigInstalledDBVersion): name="AdminAddress"; value="xyz.com:80"
>> ParameterBinding(Get-ConfigInstalledDBVersion): name="Upgrade"; value="True"

Command start time: 20190216091037

PS>CommandInvocation(Get-ConfigInstalledDBVersion): "Get-ConfigInstalledDBVersion"
>> ParameterBinding(Get-ConfigInstalledDBVersion): name="AdminAddress"; value="xyz.com:80"
>> ParameterBinding(Get-ConfigInstalledDBVersion): name="Upgrade"; value="True"
0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...