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'
Thanks & Regards,
Alagiri.P| TCS - Capacity Management Team
Tata Consultancy Services | Lion Court - 3rd Floor
25, Procter Street| Holborn| WC1V 6NY
alagiri.p@sainsburys.co.uk<mailto:alagiri.p@sainsburys.co.uk> | 07438862725
________________________________
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager (postmaster@sainsburys.co.uk) and delete it from your system.
J Sainsbury plc (185647 England)
Sainsbury's Supermarkets Ltd (3261722 England)
Registered Offices: 33 Holborn, London, EC1N 2HT
________________________________