Report showing changes from last report
Updated: 21 May 2010 | 3 comments
I have a report that we run once a month which shows a list of computers that have a particular Boolean data class selected. Each month, I would also like to run a delta report that shows the changes from the previous month. Only need to capture what is different at the time the report runs. In other words if the data class was selected one month, then changed several times during the month with an ending result of no longer selected, I only need to show that it is no longer selected. Do not need to show how many times or when it was changed.
discussion Filed Under:
Comments
You can do it, but it is tricky...
I actually just posted an article on how to do exactly what you are looking to do. Saved reports are all stored in the SavedReports table in XML format. You need to use SQL to parse through the XML, and then compare the results.
Here is the link to the article. I hope it helps!
https://www-secure.symantec.com/connect/articles/querying-against-xml-and-saved-reports-notification-server
Why don't you use the data class's history data?
It is worth of trying to utilize data class history data in this case.
1. U need to ensure the history of your data class with boolean value is enabled.
2. Write a sql query to retieve the original value from last month's history record, and compare with the current value.
3. Use this query inside a report
Magic Guru I think has the
Magic Guru I think has the best solution.
Would you like to reply?
Login or Register to post your comment.