SQL queries used for the discovery of Microsoft SQL Server

Last published : Jun 19, 2026
The Veritas InfoScale Operations Manager agentlet uses the following SQL queries to discover Microsoft SQL Server:
  • select * from sysdatabases
  • DBCC SQLPERF(LOGSPACE)
  • use database_name; exec sp_helpfilegroup
  • use database_name; DBCC SHOWFILESTATS
  • use database_name; select * from dbo.sysfiles where groupid=group_id
    Note: The agentlet runs the first query for every SQL Server instance. This query returns the list of the databases in an instance. For the remaining set of queries, thedatabase_nameis the value that is returned from the first query.
More Information
Application setup requirements for Microsoft SQL Server discovery