I'm not exactly sure what you're asking for, but it sounds like your SQL script executes on a database and returns a set of metrics. You'd like these metrics to be available in the Foglight model. Is that correct?

If that's correct, there are several approaches that you might use:

Simplest: If you are monitoring the database where the SQL script will be executed, you can configure the (Oracle, SQL Server, DB2) database agent to regularly execute a User-Defined Collection. When you configure the query, you define the result types and the database agent will store the output in the database model.

Medium: If you can run the SQL script from the command line and massage the results to write formatted output to stdout, then you can configure a custom Script Agent. You can deploy this script and configure it to run regularly. The formatted output will be parsed and the discovered metrics and properties stored in the foglight model.

Most sophisticated: you can engage the services of a consultant to leverage an existing custom agent or build a custom agent that executes the SQL and submits the results to the FMS using the Foglight DevKit.You can learn more about the Foglight DevKit by downloading this package from your FMS in Administration/Cartridges/Components for Download.

Regards,

Brian Wheeldon

Hi Brian,

thanks for this information.

i was wondering if you can direct me where does the outpot of this SQL script is stored in the foglight database model? once ran through the "user defined collection"

thanks a lot for your help

Eli

Where is the "User-Defined Collection" data stored in the Foglight model?

See How to see the execution result of a user-defined collection?

Regards,

Brian Wheeldon