SELECT     
			lastlogon as lg ,
					title, sAMAccountName, givenname AS 'First name', middleName AS Initials, sn AS 'Last name', displayName, telephonenumber AS Telephone, 
                      mail AS Mail, info AS Remarks, department AS Department, company AS Company, manager AS Manager

FROM         OPENQUERY(ADSI, 
                      'SELECT
		lastlogon,
        title,
    sAMAccountName,
    givenname ,
    middleName,
    sn ,
    displayName, 
    telephonenumber,
    mail,
    info,    
    department ,
    company,
    manager
    
    FROM
        ''LDAP://dc=company,dc=ru''
    WHERE
        objectCategory = ''Person''
        AND objectClass = ''user''
    ')
                       AS derivedtbl_1