Setting power consumption data
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>.
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:
Open SQL Server Management Studio on your NightWatchman database server or a console that can access it
Click on New Query to create an empty query window
Ensure the AgilityFrameworkReporting database is selected in the Available Databases dropdown list
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
Click the Execute button
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.
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:
Tick the Custom column checkbox for the row you want to update.
Click the value in the field to display the edit field.
Edit the value. This supports accuracy up to the first decimal place.
Press Enter on the keyboard or click another row in the table to save the value.
Note
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.