Retrieving information from PI Message Logs

Discussion created by s.grainger on Aug 30, 2013
Latest reply on Sep 4, 2013 by mhamel





             I'm trying to access some data from PI Message Logs and I need you guys' help. Currently I have the .dat files (pimsg_XXXXX.dat), and I like to access the files to determine who is accessing the PI server and what program they are doing it in. I have written VBA code such that once the file is in an Excel spreadsheet it will parse the data and return what I need. However, I'd like to automate the conversion between .dat and .csv files. I have no idea where to begin so I was hoping that you guys can lead me in the right path. I'm assuming that since this isn't directly PI related that I may have to create a script with PowerShell, but I'm not sure if this is even possible.