NGA MSSQL

[jcbaar]

We are evaluating the usage of NGA with the MSSQL backend as a replacement for our current custom SQL server archiving solution (Archie). We currently have a SQL Server reporting solution which has direct access to the alert information in the SQL server database. However, as far as I can tell, the database schema that is used by the NGA MSSQL backend is not documented anywhere which makes it a risk to re-write our reports to make use of the NGA data from the database.

So the question is :

• Is there documentation regarding database schema publicly available?
• Is it safe to just use the 'dbo.view_alarms_1' view to access the alert information (The _1 seems to suggest a view per system?)
• How likely is it that the result from this view will change between NGA versions (additional columns excluded)?
• Is it at all unadvised to use the schema and, if so, will there be any publicly available views/procedures to make this information available?

[leoknipp]

At the moment a documentation is not available. We have asked our development department to include the description in the documentation in future releases.
The information saved in the schema itself may be changed in future if there is a need for it.

Best Regards
Leopold Knipp
Senior Support Specialist