The ability to groom data based on server role or type or environment
It would be nice to have the ability to groom selective data from data warehouse based on the server role, environment, location etc. For example if/when I am monitoring all my environments (PROD, DEV, QA, TEST) in a single management group and I only want to keep data as following:
PROD = 365 Days
QA = 90 Days
DEV = 30 Days
Test = don’t save any test data in DW DB
I don’t have the ability to purge data according to the scenario listed above and we end up with lots of useless data that’s just filling up our DW DB and forcing SCOM SSRS to go through gigs of unnecessary data before it will render my reports.