Discover our Clipsal Smart Home packages as seen on The Block 2018

in location


I'm looking for

  • Wholesalers
    • Uncheck All Check All
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    How to quickly determine what measurements have been logged for a source in PME

    Product Line:
    StruxureWare Power Monitoring 7.0.x
    Power Monitoring Expert 7.2.x / 8.x / 9.0

    SQL Server Management Studio


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

    1) The following query can be run in SQL Server Management Studio. It will return a list of all measurements that have been logged (at least once) for the given source, as well as the Min and Max timestamps of the data in the ION_Data database. 

    USE ION_Data
    Select * From dbo.vSourceQuantityName
    Where SourceName = 'Group.Meter'
    Order by QuantityName

    Replace 'Group.Meter' with the name of the source you are trying to query (leave the single quotes). 

    *Note: The above query will work in Power Monitoring Expert 9.0, however the new Manual Data Editor can also be used to quickly determine what measurements have data for a particular source. 

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance