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!

Persistent Queue at TcpOut — One of Splunk's Most Practical Features

Splunk introduced persistent queueing at the tcpout layer as one of the most practical resilience features in ...

Skip the Awkward Silence: Have a .conf-ersation at .conf26

Picture this. You arrive at .conf26 already having your socializing and networking plans mapped out. No ...

Rethinking Zero Trust: From Product Purchases to Logical Control Evidence

Implementing Zero Trust (ZT) across complex environments often falters at the very beginning due to a ...