Windows Power Plan Audit
Operating SystemGet 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.
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'