Requirements

The requirements in order this monitoring could work properly are the following:

• Pandora FMS agent 3.2.1 version or higher.
• Powershell 2.0 console to execute the plugin. By default is comes installed in Windows Server 2008 R2 and Windows 7 systems, but it should be downloaded for Windows previous versions. Powershell is not compatible with Windows XP SP1 or lower system
versions.
• SQLPS.exe, this is, the SQL Server administration console for Powershell.
• Install invoke-sqlcmd command in Powershell
• It is necessary that the user with which the Pandora FMS agent is executed, that is the user that will execute the plugin, has available the follwing system permissions:
◦ Local administrator.
• The Powershell scripts execution policy should be fixed as RemoteSigned or lower.

Set-ExecutionPolicy RemoteSigned

• The different plugins will get automatically the information about all the counters that we have specified to it in a list in the counters.txt file and it will generate one module for each one in Pandora (Plugin PerfCounter). They also will get information about the status of the critical elements regarding to the SQL (Plugin SQL) server.
• Adequate configuration of the connections and permissions to allow the software agent from which the plugin is executed, to establish connection and to log against the instances to monitor and extract information from their database:
◦ Public server Role with permissions to log in the instances.
◦ Databse db_datareader role in all the instance Databases.