Where are the alarms stored in UIM? Where are the alarms that show in the Operator Console alarm viewer and IM actually stored?
What would be some basic queries to extract NAS alarms from the DB?
UIM 20.x.x
Guidance
Below is a list of all of the NAS tables:
The alarms that show in IM are stored in 2 SQLlite db files named database.db and transactionlog.db located in the nas folder \Nimsoft\probes\service\nas.
This is because the transaction logging and compression configuration (e.g., how long the transaction history is stored) for the 2 databases are managed separately: in The Transaction Log Tab and in The NiS Bridge Tab.
The IM and the OC should show the same amount of open alarms, meaning that the 2 NAS_ALARMS tables in both databases should be in sync.
If they are not in sync, check this KB
Basic Select Queries to pull out alarms from the UIM DB:
-- Select all open alarms:
Select * from NAS_ALARMS
-- Select all Open and Closed alarms (this includes all alarms, closed and open alarms)
select * from NAS_TRANSACTION_SUMMARY
--Select all Open CDM Alarms:
select * from NAS_ALARMS where prid = 'cdm'
--Select all Open CDM Alarms, show the most recent occurrence that arrived first
select * from NAS_ALARMS where prid = 'cdm' order by time_arrival DESC
--Select all Open and closed CDM Alarms, show most recent first:
select * from NAS_TRANSACTION_SUMMARY where prid = 'cdm' order by closed DESC
-- If you'd like to look for some CDM alarms for a particular server you can add the source:
select * from NAS_ALARMS where prid = 'cdm'
AND source = '<name_of_the_server>'
Related Articles:
nas Best Practices, Tips and Techniques (for Large Environments)
What do the time related fields mean in the Alarm Tables in UIM?
Where is the NAS address table data stored?
Nas alarm counts are not in sync between UMP USM and the Infrastructure Manager alarm subconsole
Why do some alarms' "count" increase immediately in the alarm console while others don't show the count increasing even when the alarms are suppressed?
nas (alarm server) techdoc