Report's modified date change Alert

[Ravisha]

Hello Cognoise,

In the Prod environment, we have a folder called as 'Highly Secured Reports'  and has 40 reports. The requirement is
1) whenever any report's modified date is changed then the BI team should get an alert (email).
2) If any new report is added to that folder then the BI should get an alert (email).

I'd really appreciate  any valuable suggestions.

Thanks

[AnalyticsWithJay]

Hi,

You could do this with SDK or by querying the content store directly if SDK is not an option.

For the query option:
- Write a query to grab the modified date from the content store for the object
- Have a table that contains current_date, and previous_date.
- In Event Studio, check for modified_date = current_date, and send an e-mail if it isn't.
- If they're not equal, copy current_date to previous_date and update current_date with modified_date. You may call a stored procedure for this.

There are lots of previously written queries that go against the content store on this board and on google. If you choose this option let us know if you need help with the query.

[Andrew Weiss]

Ravisha,

Avnet BSP's Integrated Control Suite and MetaManager can both provide this functionality.  Using ICS's Version Control System you can easily trigger on a change to a report and take action.  While ICS is a more complete solution for this sort of oversight, a quick a dirty approach can be achieved using MetaManager's Script Runner.  In MetaManager you can write a script that checks the modification date periodically for changes and then sends an email if the date has changed.  I would be happy to provide a sample script that achieves this if you're interested.

You can download MetaManager from http://www.bspsoftware.com



Thanks,

-Andy