Deployment Architecture

Powershell script output ingestion

hagjos43
Contributor

I have deployed an app via our deployment server. The app includes a batch file that runs the following command:

powershell -Command "& {Get-WmiObject -Class Win32_Product | Select-Object -Property Name | format-Table -HideTableHeaders}" 

I've included the following inputs.conf in the deployment app:

[script://$SPLUNK_HOME\etc\apps\SoftwareList\bin\SW.bat]
disabled = 0
interval = 86400

The script executes with an output listing something like the following:

C:\Windows\system32>powershell -Command "& {Get-WmiObject -Class Win32_Product | Select-Object -Property Name | format-Table -HideTableHeaders}"  
Microsoft DCF MUI (English) 2013                                               
Microsoft Office Professional Plus 2013                                        
Microsoft OneNote MUI (English) 2013      

I want to ingest each output line of the file. But my script is ingesting everything not line by line of the powershell output. Also, I'd ideally like to ignore the command string. Can anyone point me in the right direction?

Thanks!

0 Karma

bsonposh
Communicator

Have you looked at using the PowerShell TA? https://splunkbase.splunk.com/app/1477/

When you use a batch file as a wrapper Splunk will write all the batch outputs to standard out. You can try putting @echo off on the top of the batch file but I'm not certain that will help.

halr9000
Motivator

This is the best way to go. Don't use a batch wrapper. Read the read me, there are some tips for output.

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 ...