Unsolved
This post is more than 5 years old
1 Message
0
446
September 21st, 2009 18:00
device Availability in Reporter
Hello there,
Apologies if this seems a bit easy, I am new to Smarts/reporter
I am trying to find out the availability of devices inside the reporter ITPR database. The report engine is not accessible (well it will take time to get access)but we have access to the DB and we need to develop a query ASAP to figure that availability for all our devices.
Any idea which tables anf fields I may find that information in ITPR?
thank you much!
Apologies if this seems a bit easy, I am new to Smarts/reporter
I am trying to find out the availability of devices inside the reporter ITPR database. The report engine is not accessible (well it will take time to get access)but we have access to the DB and we need to develop a query ASAP to figure that availability for all our devices.
Any idea which tables anf fields I may find that information in ITPR?
thank you much!
No Events found!
JWPY
1 Message
0
May 7th, 2010 01:00
Hi,
ITPR uses this sql statement to obtain data for its availability report. the availability in % is calculated from total OUTAGE. Can anyone show how the % is calculated or better still, modify the sql below to come up with availability % as a column in the table? Thank you.
select SUMMARYAT, ELEMENTCLASS, ELEMENTINSTANCE, MAXOUTAGE, OUTAGE from IC_T_ELEMENT_SUMMARY where (IC_T_ELEMENT_SUMMARY.SUMMARYAT>='2010-04-07 11:30:05.215' and IC_T_ELEMENT_SUMMARY.SUMMARYAT<'2010-05-07 11:30:05.215') and IC_T_ELEMENT_SUMMARY.ELEMENTCLASS='Router'