• State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 25 subscribers
  • Views 2883 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Terminated User Information

bobby torres
over 5 years ago

Looking for help please, creating an Enterprise Reporter report for auditing. Thank you in advance

Criteria

1. Employee Name
2. AD Account ID
3. Account Activation/Creation Date
4. Account Disable Date
5. Account Deletion Date
6. Last Logon Date

  • 0 over 5 years ago

    Items 4 and 5 are going to be almost impossible to obtain as Active Directory does not really store this information as a discrete property.  Disabling and deletion of accounts could be considered "modifications" and thus in the case of an account disabling you might consider its "last modified" date to be useful.  However , once an account is deleted, you only have access to its tombstone and I'm not sure that Enterprise Reporter can access the data on those.  Last Logon date will be available from the contents of the lastlogontimestamp attribute as long as the account still exists in AD.

  • 0 over 5 years ago

    Hello,

    The Enterprise Reporter product team will take a look at this request and be in touch shortly. 

    In the meantime please answer the following question about your request:

    To request a new custom report, please post in our Custom Reports Forum and provide the following information:

    1. An overview explaining the report you require.
    1. What version of Enterprise Reporter is being used?
    1. What discoveries have been run?
    1. Is there a library report that closely matches what you require?
    1. What fields are required in the report?
    1. How does the information in the report need to be sorted?
    1. What parameters are required for filtering the report?
    1. How will this report be consumed? For example, will the report be viewed in report display, exported to CSV, or exported to PDF?

    Thank you,

    -Angela

  • 0 over 5 years ago

    Hi, 

    In addition to the previous information requested, could you also specify the type of ID  for item 2 (AD Account ID) as AD ObjectGuid or Sid. Also as previously mentioned, items 4 and 5 are not collected properties in Enterprise Reporter. 

    Thank you,

    Philip

  • 0 over 5 years ago

    Hello,

    A sample custom report to show disabled and deleted users is available to download.

    Link: www.quest.com/.../231

    Thank you,

    Philip