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

Catalog Is Now Generally Available on Splunk Cloud Platform

A Unified View of Your Data  Security logs, application events, business data, and historical telemetry often ...

Your Path to AgenticOps: AI Experiences for Every Splunk Practitioner

Your Path to AgenticOps: AI Experiences for Every Splunk Practitioner   Watch on demand us for a demo-driven ...