I've been looking at report editor, and while I'm familiar with building reports, I can't seem to figure out how I build a report based on changes (account disabled) that occurred during a specific date range. Requirements A report that includes all ADSAccounts that were disabled within the last week The report will be scheduled to run weekly Notes I'm unsure if this would be required, but our professional services contractor did not implement History DB. Any push in the right direction is greatly appreciated. Thank you!

Hi The History DB is not required for that. What you have to check is, if the property watch for the appropriate columns is enabled. You can do that within the Designer: Changes (old values) that will be done are saved in the tables DialogWatchOperation and DialogWatchProperty. So, use these tables as data sources for your report Definition. Hope this will help you a Little bit. - Regards Sven

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

Weekly Scheduled Report for ADSAccount Disabled by Identity Manager

Victoria.Cottet-Duncan over 6 years ago

I've been looking at report editor, and while I'm familiar with building reports, I can't seem to figure out how I build a report based on changes (account disabled) that occurred during a specific date range.

Requirements

A report that includes all ADSAccounts that were disabled within the last week
The report will be scheduled to run weekly

Notes

I'm unsure if this would be required, but our professional services contractor did not implement History DB.

Any push in the right direction is greatly appreciated. Thank you!

+1 Sven Früh-Klima over 6 years ago

Hi

The History DB is not required for that. What you have to check is, if the property watch for the appropriate columns is enabled. You can do that within the Designer:

Changes (old values) that will be done are saved in the tables DialogWatchOperation and DialogWatchProperty. So, use these tables as data sources for your report Definition.

Hope this will help you a Little bit.

-
Regards
Sven
Cancel
Up 0 Down

Cancel
0 Victoria.Cottet-Duncan over 6 years ago

Wow, this is great. I will attempt this and return if I need additional direction. Thank you very much for your assistance.
Cancel
Up 0 Down

Cancel

Endpoint Privilege Management

Weekly Scheduled Report for ADSAccount Disabled by Identity Manager