Control Compliance Suite

Does anyone know if there is a way in bv-Control for AD ver. 8 (yeah, I'm laughing too) to run a report and have it "break" when a queried field changes.  For example, running a user report that queries the "users manager" field.  I would like to have the query generate a unique query result/report for each change in manager.  I suspect the most direct way would be to run the query and have an external routine parse the report file and break out the data however, I'm wondering if there is some way within the product to do this.   Any help is greatly appreciated!

Sincerely,

Vince

Vince

I do not believe there is a way to have the query do this in the manner you described. Are you interested in only seeing those persons in the report who have had a manager change?

Have you thought of running the report to gather the data....then run a baseline to display the differences between the two reports? the baseline may allow you to do this if I understand what you're looking to do

We do something like this to produce a daily change report from our ID vault which shows us changes in departmetn, manager, employee status etc etc. Helps with another process we setup for evaluation of user application access

Kevin,

Thank you for replying.   No, not looking for a manger change, this is a basic user re-certification report.  The report is run, then manually edited and sent to appropriate managers.  The idea would be to have the query create a new list per manager so they can be emailed out.

Vince

I do not think that is possible with RMS queries.

By chance are there other attributes on the account that would Identify a department / manager. If that were the case you might be able to create a query for each department/ manager then use a task list to email the report to the correct person. There would be one report for each area and then the task list you use to run all of the reports you could setup a step to export the report via email or to a network path.

Thanks again Kevin!   We were trying to avoid an individual report per manager since that could become unweildy to manage.  The most likely route will be to run the report and use some other process to break out the results based on the change in manager field.