One of our requirements is to produce reports in an Excel format. Using SQL scripts we have been able to generate a report from the database displaying objects in AD and file paths that are assigned to a Data Owner and the recertification process has been started. The report we have indicates what has been approved and what has not. What it does not display is any recertification task that are assigned but have not been started.
We are in need of a SQL script that will output all items, file store or AD, that have been assigned to a Data Owner regardless of if the process has been started or not.
