DataDirect - sorted by timestamp
Voted best answer
Eoin,
I am sending you an abbreviated example of a SOE Report where the output is configured around specific Severity Settings for certain alarms, however the concept is the same for any extraction of Message Data, assuming that you are extracting the data from an IM node. I am basing this on utilizing SQL to retrieve the data.
This picture shows a section of the report, where Rows 6 thru 41 are hidden, which contain the scripting of the query. Included you will find a partial Excel spreadsheet containing those lines visible. Note that on Row 20, there is a statement, "order by 1,2 asc". This is using the Index value 1 & 2 to order the output in ascending order. The term "localtime" can be substituted for "1,2", so that the data is in time order. Let me know if this is what you were looking for.
Regards,
Geof Ledin
Add new comment