DX Unified Infrastructure Management

  • Private Community

  • 1.  disk utulization report of 5 server in iReport

    Posted Mar 16, 2017 12:46 AM

    Hi everyone,

     

    i want to create a disk utilization report of 5 server but i am not able to create . can anyone suggest me , how to create a report in ireport 5.2.0. What are the SQL queries that are necessary  to create this report . Am using MSSQL database.

     

     

    Can anyone help me with a sample report.



  • 2.  Re: disk utulization report of 5 server in iReport

    Posted Mar 16, 2017 03:21 AM

    To report on current disk utilization percentage I'm using:

    SELECT qd.origin,qd.robot,qd.qos, qd.source,qd.target,qs.samplevalue,qs.sampletime
    FROM S_QOS_SNAPSHOT qs
    JOIN S_QOS_DATA qd on qs.table_id = qd.table_id
    where qos = 'QOS_DISK_USAGE_PERC'
    order by qs.samplevalue