Create an advanced query that displays the active directory users accounts with date attribute of when the account was created and when it was modified in Windows Active Directory

Article:TECH157104  |  Created: 2011-03-31  |  Updated: 2011-04-11  |  Article URL http://www.symantec.com/docs/TECH157104
Article Type
Technical Solution


Environment

Issue



Would like a report that displays the create date and time as well as the modifed date and time of a user on domain.


Environment



CCS Data Collections 9.0.1 CHF=6 Windows 2003 SP2 32 bit no admin.pak installed on Cata Collection server - ECS on same server. non-domain admin account as ccs admin trying to run active directory queries.


Solution



Follow these steps to build the query:
 

  1. In the RMS Console, launch the Query Builder Wizard by clicking the Red Book on the icon bar at the top.
  2. Expand bv-Control for Windows, then select the Users data source.
  3. On the Field Specification Tab, expand Raw Directory Attributes
  4. Double click the Date Attribute field to add it to Selected Fields at the bottom.
  5. The Date Attribute dialog box appears. Click Change Descriptor.
  6. Expand Directory in Name <Domain Name>.
  7. Expand <Domain Name>.
  8. Highlight  whenCreated and select Add.
  9. Click OK.
  10. Click OK.
  11. Double click the Date Attribute field to add it to Selected Fields at the bottom.
  12. The Date Attribute dialog box appears. Click Change Descriptor
  13. Expand Directory in Name <Domain Name>.
  14. Expand <Domain Name>.
  15. Highlight  whenChanged and select Add.
  16. Click OK.
  17. Click OK.
  18. Scope to the target objects.
  19. Click OK and Save or Run the query.



Article URL http://www.symantec.com/docs/TECH157104


Terms of use for this information are found in Legal Notices