Somebody knows which table of the database must I have to query to get information about historic alarms?
I need to know how much days I don't have alarms for an specif server.
This should help you out
declare @robot varchar(50) = 'robotname'
DATEDIFF(HOUR, (select MAX(created) from NAS_TRANSACTION_SUMMARY where robot = @robot), GETDATE()) 'hours since last alarm'
I found the tables on the link http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec000003997.aspx
However, I'd like some help to build the query to get how much days I don't have alarms for an specif server.
Can you guys help me?
This was very useful
Thanks a lot.
Retrieving data ...