How to query or export alarm history from the database

Document ID : KB000034745
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

If you are interested in querying/reporting on older alarms which may not be visible in the NAS history/status window, you may be able to find information by querying the local database used by NAS.

There may also be additional information in the NimsoftSLM database, depending on your NiS Bridge/retention settings.



Instructions:

If "NiS Bridge" is enabled in NAS, then the alarms and history will be populated into three tables in the NimsoftSLM backend database:

NAS_ALARMS
NAS_TRANSACTION_LOG
NAS_TRANSACTION_SUMMARY

You can query these tables to find information on alarms.  The oldest age of alarms will be controlled by the retention settings in the NAS GUI under 'NiS Bridge'.


NAS also stores information in two locally-held database files under the \probes\service\nas\ folder.  

database.db
transactionlog.db

These files are in SQLite format and can be queried against using standard SQL queries and an SQLite browser such as:

http://sourceforge.net/projects/sqlitebrowser/

https://addons.mozilla.org/En-us/firefox/addon/sqlite-manager/