SLA Dashboard Data for SCOM 2012 R2

I have made different type of SLA dashboard in SCOM 2012 r2 the problem is that when I select to show data for 2 to 3 weeks it shows ok but when I select 2 or 3 months it doesn't show data it present blank screen or it some times show duplication of data but it is rare so anybody can tell me what the problem or I think it is bug in the application. So anybody can tell me the solution of it.

Regards,

Syed Tauseef Ahmed

July 5th, 2015 3:05pm

Check if you have latest update rollup installed.
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2015 8:32am

It seemed to be the DW pulling the OM db had stopped somwhere during the installation of the system. So the script tended to re-initialize the pulling of data from OM DB to DW DB.

The synchronous writing worked and we had data in the DW database but the SLA Dashboard couldn't solve the data.

Check the discovered Inventory and target it to "Data Warehouse Synchronization Server"

!!! If it's empty you should run the script, if not empty, do not run the script !!!


So here is the .ps1 script (change the servernames, Run the script from the RMS server,restart the services, wait about 15min and it will work)

-----------------------------------------------------------------------------
#Populate these fields with Operational Database and Data Warehouse Information

 #Note: change these values appropriately
 $OperationalDbSqlServerInstance = "OMDBserver.domain.local"
 $OperationalDbDatabaseName = "OperationsManager"
 $DataWarehouseSqlServerInstance = "DWDBServer.domain.local"
 $DataWarehouseDatabaseName = "OperationsManagerDW"

 $ConsoleDirectory = "C:\Program Files\System Center 2012\Operations Manager\Console"

 ##########################################


 $dataWarehouseClass = get-SCOMClass -name:Microsoft.SystemCenter.DataWarehouse
 $seviewerClass = get-SCOMClass -name:Microsoft.SystemCenter.OpsMgrDB.AppMonitoring
 $advisorClass = get-SCOMClass -name:Microsoft.SystemCenter.DataWarehouse.AppMonitoring

 $dwInstance = $dataWarehouseClass | Get-SCOMClassInstance
 $seviewerInstance = $seviewerClass | Get-SCOMClassInstance
 $advisorInstance = $advisorClass | Get-SCOMClassInstance

 #Update the singleton property values
 $dwInstance.Item($dataWarehouseClass.Item("MainDatabaseServerName")).Value = $DataWarehouseSqlServerInstance
 $dwInstance.Item($dataWarehouseClass.Item("MainDatabaseName")).Value = $DataWarehouseDatabaseName

 $seviewerInstance.Item($seviewerClass.item("MainDatabaseServerName")).Value = $OperationalDbSqlServerInstance
 $seviewerInstance.Item($seviewerClass.item("MainDatabaseName")).Value = $OperationalDbDatabaseName

 $advisorInstance.Item($advisorClass.item("MainDatabaseServerName")).Value = $DataWarehouseSqlServerInstance
 $advisorInstance.Item($advisorClass.item("MainDatabaseName")).Value = $DataWarehouseDatabaseName

 $dataWarehouseSynchronizationServiceClass = get-SCOMClass -name:Microsoft.SystemCenter.DataWarehouseSynchronizationService
 #$dataWarehouseSynchronizationServiceInstance = $dataWarehouseSynchronizationServiceClass | Get-SCOMClassInstance

 $mg = New-Object Microsoft.EnterpriseManagement.ManagementGroup -ArgumentList localhost
 $dataWarehouseSynchronizationServiceInstance = New-Object Microsoft.EnterpriseManagement.Common.CreatableEnterpriseManagementObject -ArgumentList $mg,$dataWarehouseSynchronizationServiceClass

 $dataWarehouseSynchronizationServiceInstance.Item($dataWarehouseSynchronizationServiceClass.Item("Id")).Value = [guid]::NewGuid().ToString()

 #Add the properties to discovery data
 $discoveryData = new-object Microsoft.EnterpriseManagement.ConnectorFramework.IncrementalDiscoveryData

 $discoveryData.Add($dwInstance)
 $discoveryData.Add($dataWarehouseSynchronizationServiceInstance)
 $discoveryData.Add($seviewerInstance)
 $discoveryData.Add($advisorInstance)

 #$connector = Get-ScomConnector -name:"Operations Manager Internal Connector"
 $momConnectorId = New-Object System.Guid("7431E155-3D9E-4724-895E-C03BA951A352")
 $connector = $mg.ConnectorFramework.GetConnector($momConnectorId)

 $discoveryData.Overwrite($connector)

 #Update Global Settings. Needs to be done with PS V1 cmdlets
 Add-pssnapin microsoft.enterprisemanagement.operationsmanager.client

 cd $ConsoleDirectory

 .\Microsoft.EnterpriseManagement.OperationsManager.ClientShell.NonInteractiveStartup.ps1

 Set-DefaultSetting ManagementGroup\DataWarehouse\DataWarehouseDatabaseName $DataWarehouseDatabaseName
 Set-DefaultSetting ManagementGroup\DataWarehouse\DataWarehouseServerName $DataWarehouseSqlServerInstance

Roger

July 7th, 2015 11:32pm

Hi, you should check Data Warehouse DB directly (State Dataset) for that inf.

https://technet.microsoft.com/ru-ru/library/gg508713.aspx?f=255&MSPPError=-2147217396

Free Windows Admin Tool Kit Click here and download it now
July 8th, 2015 12:53pm

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

Other recent topics Other recent topics