TrueSight Infrastructure Management(TSIM) Oracle tables/views where Linux/Unix KM related CPU/Memory/Disk/FileSystem related data gets stored

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:

    TrueSight Infrastructure Management


    COMPONENT:

    TSIM Agent Controller


    APPLIES TO:

    TSIM 11.3.x



    QUESTION:

    What are the oracle tables/views where Linux/Unix KM related CPU/Memory/Disk/FileSystem related data gets stored


    ANSWER:

    For UNIX KM, You can use below query to find out table related to CPU,Memory, Disk, FileSystem related stats data.

    SELECT owner, table_name FROM dba_tables where TABLE_NAME like '%_PATROL__CPU%STATS%'
    SELECT owner, table_name FROM dba_tables where TABLE_NAME like '%_PATROL__MEM%STATS%'
    SELECT owner, table_name FROM dba_tables where TABLE_NAME like '%_PATROL__DIS%STATS%'
    SELECT owner, table_name FROM dba_tables where TABLE_NAME like '%_PATROL__FIL%STATS%'

    For Linux KM, it gets stored in tables with name like, 
    SELECT owner, table_name FROM dba_tables where TABLE_NAME like '%_PATROL%NUK%STATS%'

    i.e.
    CPU           : _PATROL__NUK_7_STATS
    MEMORY  : _PATROL__NUK_5_STATS
    Disk           : _PATROL__NUK_19_STATS"
    FileSystem: _PATROL__NUK_2_STATS


    Article Number:

    000368318


    Article Type:

    FAQ/Procedural



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