michaeljbailey/GetAdministrators.sql

Created October 22, 2014 14:23

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/michaeljbailey/f0ea47818cc44951be8e.js"></script>
Save michaeljbailey/f0ea47818cc44951be8e to your computer and use it in GitHub Desktop.

Download ZIP

Finds all users in the sysadmin role that are not the sa account or are NT Services.

Raw

GetAdministrators.sql

	SELECT name
	FROM master.sys.syslogins [Login]
	WHERE [Login].[sysadmin] = 1
	AND [name] <> 'sa'
	AND [name] NOT LIKE 'NT Service%'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment