Hello.

I have a question about SCOM DW data grooming related to reports and dashboards.

In our environment we are using SLA reports among others. But what bother me is that Instances which are deleted from SCOM or renamed are still present in report/dashboard if it is made for longer period.

What i managed to check is that performance data are shown only for 400 days(this is the setting for DW grooming), but the availability for Instances is shown even for longer period.

Can anyone help me how to remove this instances from reports/dashboard (or DW), because it is very annoying. As you can see from attached pictures we see 12 VMware Clusters but there are only 7 in SCOM console which are still operational.

The dashboard is for 18 months and on the dashboard are two SLA layers (P-performance, S-service).

I hope I have clearly enough written what is the issue.

You can use Remove-SCOMDisabledClassInstance PS cmd to resolve this issue, but you could also try re-creating the report once and check if these obsolete instances are appearing

Hope this helps...

Hi,

Would you please disable the discovery for those object and then running the Remove-SCOMDisabledClassInstance Powershell command.

Here is a helpful blog for your reference:

http://blogs.technet.com/b/jonathanalmquist/archive/2008/09/14/remove-disabledmonitoringobject.aspx

And you may create a new dashboard with only 3-4 months and check the result.

Regards,

Yan Li

Hi,

above listed proposal does not eliminate the problem.

1. If you want to use "Remove-SCOMDisabledClassInstance" first you have to explicit discovery with override for an Instance. But in our case Instance is not present in SCOM anymore - see picture where only 7 VMware clusters are discovered. So I can not remove something what is not present in SCOM anymore right?

2. Creating a dashboard for 3-4 months is showing only VMware clusters still present in SCOM. But this is not an solution for our customer which want a report/dashboard for 1 Year.

A more detailed explanation what happened in the past.

There were 4 VMware clusters for which we create SLT( SLT is targeted for a group VMWare clusters - Veam MP). After some time (March 2014) this clustershave been bundled in one cluster and renamed. So SCOM discovered new instance. But when this happened the old cluster were not in SCOM anymore but have not disappeared from REPORTS or dashboards if the report duration is for 1 year.

Maybe next month they will not be shown anymore but this is very annoying, because few months ago another cluster was renamed again

So it will be present in dashboard for at least one year and i can do nothing about it???

Thanks for help.

Regards

Janez

Hi,

We may need to find those stored data for those deleted objects in the data warehouse database, and manually remove them.

Here are three blogs regarding to data warehouse grooming, you may refer to them:

Everything you wanted to know about OpsMgr Data Warehouse Grooming but were afraid to ask

http://blogs.technet.com/b/stefan_stranger/archive/2009/08/15/everything-you-wanted-to-know-about-opsmgr-data-warehouse-grooming-but-were-afraid-to-ask.aspx

Grooming in SCOM

http://blogs.technet.com/b/sudheesn/archive/2010/08/03/gooming-in-scom.aspx

Cleaning up old data from the Data Warehouse database in OM 2007 R2

http://blogs.technet.com/b/mihai/archive/2012/05/11/cleaning-up-old-data-from-the-data-warehouse-database-in-om-2007-r2.aspx

Regards,