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

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
  • What hidden parameter? I thought you were talking about the parameter I added to the Expiration Date field. I'm confused.

    Where do I run the SQL query? Do I save this on the report server? Sorry, I don't use SQL very often.

    Should I submit this to your Help Desk so we don't have to write posts back and forth? A phone call with a remote session might clear this up more quickly.

    E Powell

Reply
  • What hidden parameter? I thought you were talking about the parameter I added to the Expiration Date field. I'm confused.

    Where do I run the SQL query? Do I save this on the report server? Sorry, I don't use SQL very often.

    Should I submit this to your Help Desk so we don't have to write posts back and forth? A phone call with a remote session might clear this up more quickly.

    E Powell

Children
No Data