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