NMS version 7 - SQL queries

Discussion created by 1_GSD on Jan 6, 2014
Latest reply on Jan 30, 2014 by 1_Javier



We have NMS v7 and id like to use the SQL database to get data and create some reports, i have found some examples but they apply to an older version of NMS, which i think the schema isnt the same, can anyone give me an example on how to query the database in order to get data from the DB? for example a query which i will give the name of the server, the duration of the collected data to create statistics, the metric in the form of QOS_CPU_USAGE_PERC and for output the AVG,MIN,MAX values..