Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

LDAP Query:  whenCreated Atrribute

Posted on 2010-11-10
4
Medium Priority
?
3,375 Views
Last Modified: 2012-06-21
Hello Experts!

Does anyone know how to pull the whenCreated attribute using an LDAP query filter?  
0
Comment
Question by:itsmevic
4 Comments
 
LVL 3

Expert Comment

by:Anurag_Tiwari
ID: 34109402
You can use below given part in any of the VBSCript to retrive User object attribute.Please let me know your requirement so that i will create script for you

Set objConnection = CreateObject("ADODB.Connection")
Set objCommand =   CreateObject("ADODB.Command")
objConnection.Provider = "ADsDSOObject"
objConnection.Open "Active Directory Provider"
Set objCommand.ActiveConnection = objConnection
objCommand.CommandText ="Select Name,whenCreated,sAMAccountName from " & _
                                    "'LDAP://DC=domain Name,DC=Domain Name' where objectClass='user' and sAMAccountName = 'User Name'"
0
 
LVL 17

Accepted Solution

by:
Premkumar Yogeswaran earned 2000 total points
ID: 34109491
Hi,

this is the LDAP query for object created date...!

(&(objectCategory=person)(objectClass=user)(&(when Created>=20060120000000.0Z)))

Cheers,
Prem
0
 
LVL 57

Expert Comment

by:Mike Kline
ID: 34109625
See this question I helped with, several good methods outlined (adfind & powershell)
http://www.experts-exchange.com/Database/LDAP/Q_26253451.html

Thanks

Mike
0
 

Author Comment

by:itsmevic
ID: 34112477
Hi Mike, yeah I think you actually helped me with this @ one time and had recommended adfind and powershell.  I have the syntax for both actually.  However our ADMS system only accepts LDAP statements unfortunately, so I was looking for something soley within that technology.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
High user turnover can cause old/redundant user data to consume valuable space. UserResourceCleanup was developed to address this by automatically deleting user folders when the user account is deleted.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question