Getting Data In

Pretrained source type for PI log files

pytb
Explorer

Hi,
Is there a pretrained source type for .dat OSIsoft PI log files ?
I know I can create a .csv file manually from the .dat file, then use the .csv file in Splunk but I would like to read the logfiles directly without this extra manual step.
Thanks in advance

Tags (1)
0 Karma

pytb
Explorer

One of my collegues showed me a way to run the csv conversion from a command prompt:

pigetmsg -if "pimsg_1131112.dat" -st "1-jan-1971" -et * -fc > pimsg_1131112.csv

pigetmsg is part of the PI SMT (System Management Tools). It's in the adm folder.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Think Like an Architect: Introducing the Splunk Certified Cybersecurity Defense ...

In cybersecurity, defenders respond to threats. Architects design the systems that stop them.    As ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...