Service Operations Insight

Top 10 Reasons To Consider CA Capacity Management

Predictive Outcomes With CA Capacity Management
The ROI Of CA Capacity Management

CA Capacity Management Customer Case Studies

Hi Jermey,

I hope you are doing well. I'm new to CA tool,So i need your input to create some useful dashboard in UMP tool. We are planning to create dashboard application wise like(CPU,Mem,Filesystem). Would it be possible to share some sql query where we can fetch the data from UMP database based on that i can modify and create dashboard for our current requirements.

Thanks

Alagiri

You can create custom dashboards in CA UIM. Please refer to below link

CA UIM Dashboards: Create a Dashboard & Customize a Canvas 

You can write your sql queries. Please refer to below mentioned just for sample:

And because you can write your own SQL you can also build reports from Oracle Databases, like the CA Capacity Manager database.   (CCR contains all the SQL you need to make reports!)

David

Do you have any sample query which you used recently to build dashboards.

I thinks there is some confusion. There is no need for sql queries if the source is QoS metrics from UIM. SQL is only used to connect to external databases.

QoS metrics can be add to the UMP HTML5 dashboards via drop down.

This post was originally about showing data from the capman db in UMP; but this effort has been cancelled by Product Management.

If your questions are about just UMP dashboards with QoS metrics you should post in the UIM community page for a better response.

>KIP

Kip,

  You are correct, but we do have customers who are writing there own dashboards in UIM reading from Capacity Manager database.  

David

Hi Kamal,

I have executed the below query but the output was none. Also I would like to see last 7 days data in dashboard with multiple servers.  Would it be possible to create a sql query which will fetch the historical data ?. if yes, please provide the query

select s.samplevalue from s_qos_data d

join s_qos_snapshot s on d.table_id=s.table_id

where d.source ='  ' and d.qos = 'qos_cpu_utilization'