select  
		'HQ\'+sAMAccountName,
		mail,
		displayname,
		department,
		telephoneNumber,
		blockedinad =	case		
						when msExchUserAccountControl=2 then 'Blocked in AD'
						else ''
					end
	from  openquery(adsi, '
				select  
							sn,
							sAMAccountName,
							displayName,
							mail,
							telephoneNumber,
							mobile,
							physicalDeliveryOfficeName,
							department,
							division,
							msExchUserAccountControl
			from    ''LDAP://DC=hq,DC=corp,DC=company,DC=ru''
			where   objectCategory = ''Person''
					and
					objectClass = ''user''
			')
	where sAMAccountName is not null
	and department is not null