No report data (bandwidth utilization, connections, etc)

Hi Ravi,

Here are some sample SQL queries that you can run against the SCOM live operations database (default: OperationsManager) and data warehouse (default: OperationsManagerDW), to find out if any of your stats have been collected (as raw SQL data). Your SCOM environment may have different database names, make sure you use the appropriated ones in the SQL query.

Live data query (~OperationsManager):

  
    
  /**************************************************  
  * Get the stats from the live database  
  ***************************************************/  
  select  
  BME.FullName,  
  PCV.ManagedEntityId,  
  PCV.CounterName,  
  PDAV.SampleValue,  
  PDAV.TimeSampled  
  from [OperationsManager].[dbo].[BaseManagedEntity] BME with (nolock)  
  join [OperationsManager].[dbo].[PerformanceCounterView] PCV  with (nolock) on BME.BaseManagedEntityID = PCV.ManagedEntityId  
  join [OperationsManager].[dbo].[PerformanceDataAllView] PDAV  with (nolock) on PDAV.PerformanceSourceInternalId = PCV.PerformanceSourceInternalId  
  where BME.FullName like 'F5.%'  
    
  

Data warehouse query (~OperationsManagerDW):

  
    
  /**************************************************  
  * Get the stats from the data warehouse  
  ***************************************************/  
    
  select  
  PR.ManagedEntityRowId,  
  ME.ManagedEntityGuid,  
  PR.SampleValue,  
  PR.DateTime,  
  ME.FullName,  
  R.ObjectName,  
  R.CounterName  
  from [OperationsManagerDW].[Perf].[vPerfRaw] PR with (nolock)  
  join [OperationsManagerDW].[dbo].[PerformanceRuleInstance] PRI  with (nolock) on PR.PerformanceRuleInstanceRowId = PRI.PerformanceRuleInstanceRowId  
  join [OperationsManagerDW].[dbo].[PerformanceRule] R  with (nolock) on PRI.RuleRowId = R.RuleRowId  
  join [OperationsManagerDW].[dbo].[ManagedEntity] ME  with (nolock) on PR.ManagedEntityRowId = ME.ManagedEntityRowId  
  where ME.FullName like 'F5.%'  
    
  

Let me know if you get any results by running these queries. Watch for your specific stats (~bandwith, etc) if they show up.

Thanks,

Julian