0 Replies Latest reply on Aug 1, 2012 4:05 AM by yankeeexpat

    Creating EnergyWise Report with Stats and Domain Name

    yankeeexpat

      I'm trying to create an EnergyWise report which supplies a node's key EnergyWise stats--in the manner that the existing 'Total Energy Consumption and Savings per EnergyWise Device - Last 7 Days' report does--but with an additional 'Domain Name' field, so that nodes can be grouped by their EnergyWise domains.

       

      The domain name field is found in this location:

       

      NPM_NV_EW_DEVICE_V.DomainName AS Domain_Name

       

      The problem is integrating the NPM_NV_EW_DEVICE_V table (via a join, I assume) with the existing report code for 'Total Energy Consumption and Savings per EnergyWise Device - Last 7 Days'. Does anyone have any idea how to modify this report to incorporate the 'domain name' field from the  NPM_NV_EW_DEVICE_V table?