Print Page - Sql Query with no specific database

Title: Sql Query with no specific database
Post by: Egert143 on March 12, 2021, 01:47:10 PM

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 ?

Code Select

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

Title: Re: Sql Query with no specific database
Post by: Victor Kirhenshtein on March 16, 2021, 11:42:56 PM

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

NetXMS Support Forum

English Support => General Support => Topic started by: Egert143 on March 12, 2021, 01:47:10 PM