1 Reply Latest reply on Dec 16, 2019 1:39 AM by Ben Davies

    TSCO 11.0 -- Query to pull back CPU Utilization metrics

    Steve Lake
      Share This:

      Need to pull CPU Utilization metrics directly form the TSCO 11.0 ORACLE database. Anyone have a query that does that

        • 1. Re: TSCO 11.0 -- Query to pull back CPU Utilization metrics
          Ben Davies

          Query Examples   Query examples - Documentation for BMC TrueSight Capacity Optimization 11.0 - BMC Documentation

           

          The two highlighted are the ones I think you are looking for.   A bit of adjusting the sample queries could deliver a query for your specific purpose. 

           

          Given a domain, find all systems currently in the domain

          Given a system and a time series metric, find daily values for the last 7 days.

          Find the latest value of a configuration metric of a system

          Given a domain and a config metric, find the latest value for each system that is currently a child of that domain.

          Listing business drivers present in a domain

          Retrieving business driver data

          Retrieving business driver data (including missing samples)

          Retrieving system metric values

          Retrieving top 10 systems based on CPU consumption

          Given a system, find all systems that are children or descendants of that system currently

          Given a domain, find all systems that are children or descendants of children of that domain currently

          Given a domain, count the number of systems that are direct children of that domain.

          Given a domain, count the number of systems that are descendants of that domain.

          Given a domain, produce a monthly count of all the systems that were descendants of that domain at least once in that month, for the past 12 months.

          Discover the results produced by a golden model (system, metric, stat)

          Explain how to get statistic with single value (such as days to crash)

          Explain how to work with a statistic that produces more than one value (estimated daily value)

          1 of 1 people found this helpful