Technical FAQs

Ask a Question

How to determine the Min and Max Timestamp for a device in PME?

Issue:
A user would like to determine the earliest and most recent timestamps for a device in PME

Product Line:
Power Monitoring Expert 7.2.x, 8.x

Environment:
SQL Server Management Studio

Resolution:

*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.* 

The attached SQL query will return a list of all devices in the system that have logged data, as well as the Minimum and Maximum timestamps.
*Note: This query does not specify which measurements are associated with those timestamps. It simply returns the earliest and most recent timestamps for that device. 




 
Was this helpful?
What can we do to improve the information ?