• State Not Answered
  • Locked Locked
  • Replies 11 replies
  • Subscribers 24 subscribers
  • Views 12230 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

A/D report with expiration dates - not reporting all user objects

elongp
over 7 years ago

I started with the AD report "Account Expiration Date".

I am trying to find all user objects in the domain with an expiration date. I have tried the parameter for field "Domain User: Expiration Date (Domain User)" with a condition operator "has a value" and I only get back a handful, and I know there are more that are not listed. I wanted something for the field like "is not null" and it's not an available option. I even tried the past N days or future N days, as suggested in a post, and that is not returning all accounts, either. I run a discovery monthly.

When I clicked the link to the custom report in a previous post about similar issues, the page is missing. I prefer not to use the custom reports as one cannot modify the layout, which I do for all of your reports. :)

E L Powell

Parents
  • 0 over 7 years ago

    Hello Powell


    You said you started over with the report 'as is' from Report Library and it also lists people who have no expiration date - can you confirm if you have removed the hidden parameter 'Domain User: Expiration Date (Domain User)' ?

    I've attached a file containing a SQL query that lists all users in your domain irrespective of their 'Expiration Date', can you confirm the data in the database matches the data in your AD by running the SQL query...I'd like to verify if we have a data inconsistency issue.

    Also can you please mention the version of Enterprise Reporter that you are using.

    Thank you

    Aravind

Reply
  • 0 over 7 years ago

    Hello Powell


    You said you started over with the report 'as is' from Report Library and it also lists people who have no expiration date - can you confirm if you have removed the hidden parameter 'Domain User: Expiration Date (Domain User)' ?

    I've attached a file containing a SQL query that lists all users in your domain irrespective of their 'Expiration Date', can you confirm the data in the database matches the data in your AD by running the SQL query...I'd like to verify if we have a data inconsistency issue.

    Also can you please mention the version of Enterprise Reporter that you are using.

    Thank you

    Aravind

Children
No Data