Server Management - Systems Insight Manager
1833777 Members
2239 Online
110063 Solutions
New Discussion

snapshotID and date conversions

 
Rob Buxton
Honored Contributor

snapshotID and date conversions

Hi All,

With HPSIM 4.2 I has a report that I generated from a perl script accessing the the HPSIM database.
This would use the DC_HistoricalOutput table and the use the Timestamp field when I needed data from a specific date.
I installed HPSIM 5.0 as a new install and this table no longer exists.
The historical data seems to reside in the CIM_* tables but there's no date, just the SnapshotID.
I suspect this is updated evertime the polling task is run, which will cause me problems as I has mistakenly configured the Historical Polling task to run repeatedly.
If I'm wrong about the SnapshotID and it is some kind of date representation then can someone let me know how to convert it.
If it is incremented everytime a polling task is run, is it possible to determine the date anywhere?
As always thanks in advance.