Windows Power Plan Audit

Get an Overview of Power Plans in Your Organization

Windows power plans might not be used frequently, but they are key to optimizing your work environment for a diverse range of use cases while at the same time reducing waste of energy. Discover which power plans are being used in your IT environment and which servers or workstations are using the wrong power plans for their specific usage. If you’re interested in more ways to efficiently manage power consumption you can take a look at the related Power Management blog post.

Before running the audit, add the following registry keys to your custom registry scanning.

Rootkey: HKEY_CURRENT_USER
Regpath: SYSTEM\CurrentControlSet\Control\Power\User\PowerSchemes
Regvalue: ActivePowerScheme

Windows Power Plan Query

Select Top 1000000 tblAssets.AssetID,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
Case
When tblComputersystem.Domainrole > 1 Then 'Server'
Else 'Workstation'
End As [Workstation/Server],
tsysOS.OSname As OS,
Case tblRegistry.Value
When '381b4222-f694-41f0-9685-ff5bb260df2e' Then 'Balanced'
When '8c5e7fda-e8bf-4a96-9a85-a6e23a8c635c' Then 'High Performance'
When 'a1841308-3541-4fab-bc81-f71556f20b4a' Then 'Power Saver'
Else 'Unknown/Custom'
End As [Power plan],
Case
When tblErrors.ErrorText Is Not Null Or
tblErrors.ErrorText != '' Then
'Scanning Error: ' + tsysasseterrortypes.ErrorMsg
Else ''
End As ScanningErrors,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID,
Max(tblErrors.Teller) As ErrorID
From tblErrors
Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID =
ScanningError.ID
Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller
Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype =
tblErrors.ErrorType
Where tblAssetCustom.State = 1 And tblRegistry.Valuename = 'ActivePowerScheme'

Show

Hide