Verifying PO sources in PME

Before you can update an ETL job to synchronize PO and PME devices, it is recommended that you obtain a list of the device names that are already in the system. Doing so will prevent device naming conflicts and will also help you to edit the ETL job.

You cannot see PME source names that were created by ETL in PME Management Console; you must run a SQL query to return this information.

NOTE: You can also look for PO devices and their associated PME sources by creating and generating a tabular report in PME or by creating a dashboard that uses a trend from the PO source. See Power Monitoring Expert Help for more information.

To match PO devices to PME sources:

1. In Microsoft SQL Server Management Studio, click New Query.
2. To return all sources in alphabetical order, enter and execute the following query: 

   SELECT * FROM ION_Data.dbo.vSource

   To sort the sources beginning with the most recently added device, enter and execute the following query:

   SELECT * FROM ION_Data.dbo.vSource ORDER BY SourceID DESC

   Alternatively, you can click Use list of sources (allows aliasing) and click Recommended Pairs. Choosing this option returns the sources and quantities available at the time you clicked Recommended Pairs. To discover additional sources and quantities, you must click Recommended Pairs again.

   TIP: Copy the entire query result and paste it into Microsoft Excel to more easily sort and filter the devices.

3. (Optional) Use this information forEditing a PO to PME ETL job.