Managing power consumption data in the NightWatchman console

You can view and modify the power consumption figures of the hardware found on your network in the NightWatchman console. Editing these values affects the information in NightWatchman reports. They are based on information available from your computer vendors. This information is usually available on the support pages of your vendors' web sites, where you download manuals and other documentation. The regulatory documents are most likely to contain the needed data.

The NightWatchman power consumption information is divided into three tabs: Desktops, Laptops and Monitors with information for each category shown in its own tab. Default values are used when hardware information cannot be found; these are <default chassis> for the desktop type, <default laptop> for the laptop type and <default monitor>.

On this page:

The Desktops tab

In the Desktops tab, you can set power consumption values for specific types of computers in four operation states; namely, on, standby, hibernate and off.

  • Manufacturer – the hardware manufacturer
  • Type – the type of computer
  • Model – the model of the computer
  • On – the power consumption when the computer is on
  • Standby – the power consumption when the computer is in standby mode
  • Hibernate – the power consumption when the computer is in hibernate mode
  • Off – the power consumption when the computer is connected but turned off
  • Source – the source of the information

The Laptops tab

In the Laptops tab, you can set power consumption values for specific types of laptops in five operation states; namely, on, on with screen in standby, standby, hibernate and off.

  • Manufacturer – the hardware manufacturer
  • Type – the type of computer
  • Model – the model of the computer
  • On – the power consumption when the computer is on
  • On with screen in standby – the power consumption when the computer is on but the display is in standby mode
  • Standby – the power consumption when the computer is in standby mode
  • Hibernate – the power consumption when the computer is in hibernate mode
  • Off – the power consumption when the computer is connected but turned off
  • Source – the source of the information

The Monitors tab

In the Monitors tab, you can set power consumption values for specific types of monitors in two operation states; namely, on and off.

  • Model – the model of the computer
  • On – the power consumption when the computer is on
  • Standby – the power consumption when the computer is in standby mode
  • Source – the source of the information

Automated power consumption catalog updates

As of August 2018, NightWatchman Enterprise can no longer integrate with ActiveEfficiency to enable the power consumption tables to be automatically updated via the cloud. 1E is still pleased to provide the same data to you using a slightly more manual process. Contact 1E Support for details.

Support will ask you to:

  1. Open SQL Server Management Studio on your NightWatchman database server or a console that can access it
  2. Click on New Query to create an empty query window
  3. Ensure the AgilityFrameworkReporting database is selected in the Available Databases dropdown list
  4. Paste these queries into the query window:
select [Type], SubType, Manufacturer, Model, HardwareID, count(*) 'Count' from tbAFR_Lookup_HardwareComponent hw 
join tbAFR_Dimension_ComputerSystem systems on hw.HardwareId=systems.HardwareComponentId
where IsDefault=0 group by [Type], SubType, Manufacturer, Model, HardwareId order by Count(*) desc
select [Type], SubType, Manufacturer, Model, HardwareID, count(*) 'Count' from tbAFR_Lookup_HardwareComponent hw 
join tbAFR_Dimension_DisplayMonitor systems on hw.HardwareId=systems.HardwareComponentId
where IsDefault=0 group by [Type], SubType, Manufacturer, Model, HardwareId order by Count(*) desc
  1. Click the Execute button 
  2. Two results tables will appear. Right click each and select Save Results As. Save the first as "computers.csv" and the second as "monitors.csv" in a location that is convenient for you.
  3. E-mail the two CSV files to 1E support

Support will e-mail you a file with SQL statements that you will execute in the same manner to populate the power consumption table.

Modifying Power Consumption values

To modify the power consumption values:

  1. Tick the Custom column checkbox for the row you want to update.
  2. Click the value in the field to display the edit field.
  3. Edit the value. This supports accuracy up to the first decimal place.
  4. Press Enter on the keyboard or click another row in the table to save the value.
Entering decimal fractions beyond the first decimal place will initially display but is rounded up to the nearest first decimal when navigating away from the power consumption values page.

Click here for a more detailed step-through.