Hi all
I'm trying to get the "lastlogon" value from the "user" objectclass within our active directory using this query:
SELECT lastLogon
FROM OpenQuery(ADSI,
'SELECT lastLogon
FROM ''LDAP://DC=mydomain,DC=com''
where objectClass = ''user''')
but i get the following error message:
Server: Msg 7346, Level 16, State 2, Line 1
Could not get the data of the row from the OLE DB provider 'ADSDSOObject'. Could not convert the data value due to reasons other than sign mismatch or overflow.
the MSDN site describes the attribute to hold a "large integer".
Thankful for all replies
Robbomobb
I'm trying to get the "lastlogon" value from the "user" objectclass within our active directory using this query:
SELECT lastLogon
FROM OpenQuery(ADSI,
'SELECT lastLogon
FROM ''LDAP://DC=mydomain,DC=com''
where objectClass = ''user''')
but i get the following error message:
Server: Msg 7346, Level 16, State 2, Line 1
Could not get the data of the row from the OLE DB provider 'ADSDSOObject'. Could not convert the data value due to reasons other than sign mismatch or overflow.
the MSDN site describes the attribute to hold a "large integer".
Thankful for all replies
Robbomobb
