Forum Discussion

Julian_Balog_34's avatar
Julian_Balog_34
Historic F5 Account
Oct 23, 2009

No report data (bandwidth utilization, connections, etc)

[continuing from an initial post, by Ravi]

 

 

Hi Ravi,

 

 

In response to your your reporting issues (no performance data displayed) with the F5 Management Pack, I would assume the following:

 

- your F5 reports are installed (i.e. you can access them but you see no data),

 

- you correctly enabled the performance rules (collection rules) for the statistics that you would like to gather (Click here for details on how to enable performance rules.

 

 

Do you see statistics collected in the Performance View associated with the device? If you do see performance stats collected in the performance view, and still no reports for the same stats (in the related F5 report), I would run an arbitrary non-F5 report first (in SCOM), to make sure data is at least getting collected from the OperationsManagerDW (data warehouse) SQL database, and your data warehouse runs true.

 

 

Let us know how this goes, and we'll take it from there...

 

 

Thanks,

 

Julian
management
microsoft
scom
  • ravi_75510's avatar
    ravi_75510
    Icon for Nimbostratus rankNimbostratus
    Oct 27, 2009
    Hi Julian,

     

     

    I have enabled the performace rules. I am able to pull reports like"Pool Members configured on Device" but not other reports related to Bandwidth and connections of LTM devices.

     

    In state view performnace column is laso showing as "Not Monitored". DO i need to chnage some thing at F5 ens. Please let me know. Can you please send me sql query to check data in warehouse database.

     

     

    Thanks

     

    ravi
  • ravi_75510's avatar
    ravi_75510
    Icon for Nimbostratus rankNimbostratus
    Oct 30, 2009
    HI,

     

    Can you please help me in collection performance data. I followed F5 document to enable performnace and collection rules but still no luck.

     

     

    With Regards

     

    Ravi
  • Julian_Balog_34's avatar
    Julian_Balog_34
    Historic F5 Account
    Nov 02, 2009
    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