iframe-proxy | Sunbelt Computer Software

53 lines (43 loc) · 1.13 KB

	Power Saving Check
	https://bornsql.ca/
	Copyright (c) BornSQL.ca
	Written by Randolph West, released under the MIT License
	Last updated: 19 June 2020
	A simple Windows Registry scan, using xp_cmdshell 'powercfg /list'.
	This script respects your 'show advanced options' and 'xp_cmdshell'
	settings under sp_configure, and will set them back the way it found
DECLARE @isCmdShellEnabled BIT;
DECLARE @isShowAdvanced BIT;
SELECT @isCmdShellEnabled = CAST(value AS BIT)
FROM sys.configurations
WHERE name = 'xp_cmdshell';
SELECT @isShowAdvanced = CAST(value AS BIT)
FROM sys.configurations
WHERE name = 'show advanced options';
IF (@isShowAdvanced = 0)
	EXEC sp_configure 'show advanced options', 1;
	RECONFIGURE;
IF (@isCmdShellEnabled = 0)
	EXEC sp_configure 'xp_cmdshell', 1;
	RECONFIGURE;
--Run xp_cmdshell to get power settings
EXEC xp_cmdshell 'powercfg /list';
--Turn off 'xp_cmdshell'
IF (@isCmdShellEnabled = 0)
	EXEC sp_configure 'xp_cmdshell', 0;
	RECONFIGURE;
--Turn off 'show advanced options'
IF (@isShowAdvanced = 0)
	EXEC sp_configure 'show advanced options', 0;
	RECONFIGURE;

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

Uh oh!

FilesExpand file tree

power_saving_check.sql

Latest commit

History

power_saving_check.sql

File metadata and controls