Table does not exist

[canasdaq_deals]

Can anyone please help me. I am new to Active Directory.
When i try to run the query, i am getting an error
saying "Table does not exist". What do i need to do.
Please help?

 

[Matjaz Ladava [MVP]]

What kind of query. can you provide more info ?

--

Regards

Matjaz Ladava, MCSA, MCSE, MCT, MVP
Microsoft MVP Windows Server - Active Directory
(e-mail address removed), (e-mail address removed)

 

[Guest]

SELECT DisplayName, TelephoneNumber, mail, sAMAccountName,
sn, cn, givenname, telephonenumber
FROM 'LDAP://xxx.xxx.COM/OU=Companies,DC=xxx,DC=xxx,DC=com'
WHERE objectClass='*' and sAMAccountName = 'userid*' and
mail = '*' Order by sAMAccountName

 

[Matjaz Ladava [MVP]]

It is enough to use 'LDAP://OU=Companies,DC=xxx,DC=xxx,DC=com' in your
query. Alternatively you could use LDAP query in form of

'LDAP://OU=Companies,DC=xxx,DC=xxx,DC=xxx;()();DisplayName,TelephoneNumber,m
ail,
sAMAccountName,sn,cn,givenname,telephonenumber;(sAMAccountName=userid*);subt
ree'

--

Regards

Matjaz Ladava, MCSA, MCSE, MCT, MVP
Microsoft MVP Windows Server - Active Directory
(e-mail address removed), (e-mail address removed)