Return
-
Question
Databases: Can custom queries be run on a DB2, SQL Server, or Oracle database from Foglight? -
Answer
The Foglight cartridges for DB2, Oracle, and SQL Server has a user defined query (user defined collection) component that allows users to provide custom SQL statements to retrieve data. With this solution you would be able to run custom queries to gather data in addition to data the Foglight SQL Server cartridge provides without installing an agent on the monitored server.
Please refer to the Database cartridge user guide available for download from here for more information on configuring and viewing User-Defined Collections in Foglight.