NetXMS Support Forum

Hello

When polling MS Sql database with agent, what shoud be written in database name as the query is generic and not specific to single database ?

Database = id=db3;driver=mssql.ddr;server=x.x.x.x;dbname=????;login=xxxx;password=xxxxx
Query = query:db3:300:SELECT Count(name) From sys.databases WHERE database_id > 4 AND group_database_id IS not NULL

Hi,

you can use any database present on that server then, probably "master" could be a good choice as it always exists.

Best regards,
Victor