GetListOfActiveDirectoryUsernames.sql

SELECT (SELECT SUBSTRING(
		(SELECT ('; ' + Username  + '') FROM 
			(SELECT AD.sAMAccountName as Username
			FROM OPENQUERY(ADSI, 'SELECT sAMAccountName, displayName, userPrincipalName, userAccountControl, company
				FROM ''LDAP://myserver/OU=SBSUsers,OU=Users,OU=MyBusiness,DC=my-domain,DC=co,DC=uk''
				WHERE objectClass = ''Person'''
			) AD
			WHERE AD.userPrincipalName Is NOT Null 
			AND AD.sAMAccountName Is Not Null
			AND AD.userAccountControl NOT IN (512, 546, 514, 66050)
			AND AD.company Is NOT Null) x
			ORDER BY x.Username ASC
		FOR XML PATH(''))
	,3,200000)) AS Usernames;