Report Engine SQL Queries To Monitor Performance Data Collection

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    ProactiveNet Performance Management Suite


    COMPONENT:

    BPPM Business Objects Reports


    APPLIES TO:

    ProactiveNet Performance Management Suite : 9.6.00



    QUESTION:

     
        
    • Report Engine SQL Queries To Monitor Performance Data Collection
    •  


    ANSWER:

    --Query to check stats data collection per monitor name.

      select s.motypeid,m.displayname,count(*) from stats_data s, mo_meta m
    where m.motypeid=s.motypeid group by s.motypeid,m.displayname;
      
    --Query to check stats data collection per attribute name.  
      select s.attributeid,a.dispname,count(*) from stats_data s, attribute_meta a
    where a.attrid=s.attributeid group by s.attributeid,a.dispname;
      
    ----Query to check hourly summarized data collection per monitor name.  
      select s.motypeid,m.displayname,count(*) from hourly_data s, mo_meta m
    where m.motypeid=s.motypeid group by s.motypeid,m.displayname;
      
    ----Query to check hourly summarized data collection per attribute name.  
      select s.attributeid,a.dispname,count(*) from hourly_data s, attribute_meta a
    where a.attrid=s.attributeid group by s.attributeid,a.dispname;
      
    --Query to check all external report attribute set created on BPPM with attribute name  
      select attributesetname,attributename from externalreportattributeset where deleted=-1 order by attributesetname;

     


    Article Number:

    000135250


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles