Integrations

New plugin for ODBC queries in Windows

April 29, 2015

New plugin for ODBC queries in Windows

This post is also available in: Spanish, Japanese

This is a VBScript Local Plugin that creates modules setting several parameters. Pandora_odbc reads a configuration file, which defines Module Name, System DSN Name, User, Password, Database, Module Type and a SQL Query in CSV Format.

You must set the SQL Query between double quotes, like shown in the following example:

dbcheck_data,UNO,sa,pandora,PRUEBA,generic_data,”SELECT COUNT(*) FROM dbo.ejemplo WHERE id <> ‘0’”

dbcheck_string,UNO,sa,pandora,PRUEBA,generic_data_string,”SELECT nombre FROM dbo.ejemplo ORDER BY id”

dbcheck_boolean,UNO,sa,pandora,PRUEBA,generic_proc,”SELECT MAX(id) FROM dbo.ejemplo”

odbc

This plugin is available in all versions of Pandora FMS.


    Written by:



    Leave a comment

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.