LDAP Query:  whenCreated Atrribute

Posted on 2010-11-10
Last Modified: 2012-06-21
Hello Experts!

Does anyone know how to pull the whenCreated attribute using an LDAP query filter?  
Question by:itsmevic
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

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'"
LVL 17

Accepted Solution

Premkumar Yogeswaran earned 500 total points
ID: 34109491

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

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

LVL 57

Expert Comment

by:Mike Kline
ID: 34109625
See this question I helped with, several good methods outlined (adfind & powershell)



Author Comment

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.

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Active Directory security has been a hot topic of late, and for good reason. With 90% of the world’s organization using this system to manage access to all parts of their IT infrastructure, knowing how to protect against threats and keep vulnerabil…
Had a business requirement to store the mobile number in an environmental variable. This is just a quick article on how this was done.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

738 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