Tenure of Data on SLA Dashboard
Hey Team, We have installed and configure SLA Dashboard and implemented Service Level trackings. All the view on the Dashboards are fine. We have completed this task 18 months back. Now when ever i try to change the ddashboard default view to last Quater or last year it is displaying as "Unable to Display Due to Insufficient Data" not sure how resolve the issue. -Vrkuamr01
February 16th, 2011 2:15pm

Hi, What are your setting for the datawarehouse. How long are storing the data in datawate house. Can you create report from Service Level that are from last quater or last year? \\Biks
Free Windows Admin Tool Kit Click here and download it now
February 16th, 2011 3:51pm

i tried generate a report on the availability and i am gettign the report from last year. can you guide me more on checking the setting of the datawarehouse please. -vrkumar01
February 16th, 2011 6:59pm

Hi vrkumar01 Please have look here: http://searchwindowsserver.techtarget.com/feature/Database-grooming-for-System-Center-Operations-Manager-2007 \\Biks
Free Windows Admin Tool Kit Click here and download it now
February 17th, 2011 4:53am

Hey Biks, with the help the link i tried to gather the information of the grooming settings by running the following SQL query: <tt>SELECT AggregationIntervalDurationMinutes, BuildAggregationStoredProcedureName, GroomStoredProcedureName, MaxDataAgeDays, GroomingIntervalMinutes, MaxRowsToGroom FROM StandardDatasetAggregation</tt> <tt>and here is output</tt> <tt> AggregationIntervalDurationMinutes BuildAggregationStoredProcedureName GroomStoredProcedureName MaxDataAgeDays GroomingIntervalMinutes MaxRowsToGroom NULL NULL EventGroom 100 240 100000 NULL AemAggregate AemGroom 30 240 100000 1440 AemAggregate AemGroom 400 240 100000 NULL PerformanceAggregate PerformanceGroom 10 240 100000 60 PerformanceAggregate PerformanceGroom 400 240 100000 1440 PerformanceAggregate PerformanceGroom 400 240 100000 NULL NULL AlertGroom 400 240 50000 NULL NULL StateGroom 180 60 50000 60 StateAggregate StateGroom 400 60 50000 1440 StateAggregate StateGroom 400 60 50000 </tt> not sure if this help you to guide me. -Vrkuamr01
February 17th, 2011 10:01pm

Hey Biks, with the help the link i tried to gather the information of the grooming settings by running the following SQL query: <tt>SELECT AggregationIntervalDurationMinutes, BuildAggregationStoredProcedureName, GroomStoredProcedureName, MaxDataAgeDays, GroomingIntervalMinutes, MaxRowsToGroom FROM StandardDatasetAggregation</tt> <tt>and here is output</tt> <tt> AggregationIntervalDurationMinutes BuildAggregationStoredProcedureName GroomStoredProcedureName MaxDataAgeDays GroomingIntervalMinutes MaxRowsToGroom NULL NULL EventGroom 100 240 100000 NULL AemAggregate AemGroom 30 240 100000 1440 AemAggregate AemGroom 400 240 100000 NULL PerformanceAggregate PerformanceGroom 10 240 100000 60 PerformanceAggregate PerformanceGroom 400 240 100000 1440 PerformanceAggregate PerformanceGroom 400 240 100000 NULL NULL AlertGroom 400 240 50000 NULL NULL StateGroom 180 60 50000 60 StateAggregate StateGroom 400 60 50000 1440 StateAggregate StateGroom 400 60 50000 </tt> not sure if this help you to guide me. -Vrkuamr01
Free Windows Admin Tool Kit Click here and download it now
February 17th, 2011 10:01pm

Hi, Please check if any information in the following thread will help: Unable to display due to insufficient data error in SCOM SLD v 2.0: http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/f4f943af-7efa-4aaf-b980-1a727b4574cb/Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
February 21st, 2011 3:56am

Hi, Please check if any information in the following thread will help: Unable to display due to insufficient data error in SCOM SLD v 2.0 http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/f4f943af-7efa-4aaf-b980-1a727b4574cb/Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
February 21st, 2011 3:57am

Hi, Please check if any information in the following thread will help: Unable to display due to insufficient data error in SCOM SLD v 2.0 http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/f4f943af-7efa-4aaf-b980-1a727b4574cb/Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
February 21st, 2011 3:57am

Checked the threads but no luck. -Vrkumar01
Free Windows Admin Tool Kit Click here and download it now
February 21st, 2011 2:18pm

Checked the threads but no luck. -Vrkumar01
February 21st, 2011 2:18pm

Hi VrKumar01, are you still experiencing issues, or did you reach a resolution? Thanks, Filip
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2011 8:44pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics