In TSCO, where can I get assistance with the creation of custom reporting SQL?

Version 7
    Share This:

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


    TrueSight Capacity Optimization


    BMC TrueSight Capacity Optimization 11.5, 11.3, 11.0,10.7.01,10.7,10.5, 10.3, 10.0 ; BMC Capacity Optimization 9.5



    I am looking to create a custom report or view in TrueSight Capacity Optimization (TSCO) and I am looking for assistance extracting the desired performance and configuration data from the TSCO database. Where can I obtain assistance with the creation of custom SQL based reports or views within TSCO? Is this something that TSCO Technical Support can assist with?





    The creation of custom SQL is outside of the scope of TrueSight Capacity Optimization (TSCO) Technical Support. In general, customization of TSCO including custom SQL is provided via Professional Services on a fee for service basis.

       000028422: What level of support is available for TSCO customization from TSCO Technical Support? (

    One possible avenue for assistance with the creation of custom reports is the TSCO Community forum site ( The TSCO Community forum site is a user-to-user forum where people who use TSCO can ask and answer questions related to TSCO. The TSCO Community forum may be able to assist with the creation of custom SQL or with recommendations on different ways to obtain the same information from TSCO without the use of custom SQL. 

    In general, for the extraction of system and configuration data from TSCO one would want to use the Public Views: 
        000095686: Request for TSCO Database Internal Schema documentation ( 000095686

    The TSCO documentation describes the Public Views and provides several query examples using those Public Views:

    This document maps the metrics displayed on the system summary page to the internal metric names within the BCO database 
        000106518: In TSCO, How do I fill in the Summary tab for a system? (

    One thing to be aware of in relation to TSCO is that each metric isn't a column in a table -- each metric is a row in a table. So, you'll see that there is a different Public View per data summarization level (detail, hourly, daily, monthly). Each Public View would then contain rows where each row represented a particular metric for a particular system for a particular interval. So, each row in the table represents the data for a single metric for a single point of time for a single system. So, a query to select CPU_UTIL would be identical to a query to select MEM_UTIL -- except in one query you'd have " PV_SYS_METRIC.METRIC = 'CPU_UTIL'" and the other you'd have "PV_SYS_METRIC.METRIC = 'MEM_UTIL' in the WHERE clause (See the "Given a system and a time series metric, find daily values for the last 7 days." example in the BCO documentation). 

    TSCO supports the following data summarization levels:  
    •  Detail (the granularity of the data coming from the ETL itself.  As low as 5 minutes but depending on the ETL 5, 15, 30, or 60 minutes)
    •  Hour (Hourly summarization -- one data point per hour)
    •  Day (Daily summarization -- one data point per day)
    •  Monthly (One data point per month)
    Each of those summarization levels is accessed via a different Public View: 

    Summary LevelPublic View Name
    The queries you run against the views would have the same structure but they would return different data summarization levels.  Most of the time the PV_SYS_DATA_DH (Hourly) data is the level you are looking for.  Note that in TSCO version 10.0 and later the PV_SYS_DATA_DETAIL level will only be populated with data if the ETL is bringing in data at a granularity less than hourly.  If the base ETL is bringing in hourly data than SYS_DATA_DETAIL will be skipped and data will be imported directly to SYS_DATA_DH. 

    The PV_SYS_METRIC public view lists every metric that has ever been associated with that entity in TSCO.  That means that finding a metric associated with an entity in the PV_SYS_METRIC view doesn't mean that metric necessary is currently reporting data for that entity.  It just means that at some point in the life system of the entity data had been reported for that metric. 

    Related Products:  
    1. TrueSight Capacity Optimization
    3. BMC Capacity Optimization
       Legacy ID:KA417721


    Article Number:


    Article Type:

    Solutions to a Product Problem

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