PRTG Manual: PRTG Database Observer console
When you are starting to work with the PRTG Database Observer console, the first step is to open a Command prompt or PowerShell window with administrator rights and navigate to the Custom Sensors folder of your PRTG probe (by default: C:\Program Files (x86)\PRTG Network Monitor\Custom Sensors\EXEXML).
To receive more information about parameters, you can run the PRTG_DB_Plugin.exe with the -getHelp parameter.
The following parameters are possible:
Parameter |
Description |
|---|---|
-getHelp |
Returns the parameters that can be used. |
-encrypt: |
Followed by a password. Returns the encrypted form of the entered password. |
-profile: |
Followed by a profile name defined in PRTG Database Observer. |
-testConnection |
Returns a response with a channel called Connection: 0: The connection is valid. 1: There is a connection error. Must be placed after a -profile parameter. Example: -profile:mssql -testConnection |
-query: |
Followed by the name of a query. |
-queryFile: |
Followed by the path of the query. |
-params: |
Used with -query or -queryFile. Followed by maximum 9 parameters, separated by a comma. Example: -params:@param1:25,@params2:test |
-createProfile |
Used for creating a profile. Example: -createProfile -type:mssql -name:mssql -host:(local)\SQLEXPRESS -wa 1 |
-name: |
Followed by a profile name. Used with -createProfile. |
-host: |
Followed by a host or IP address. |
-database: |
This parameter is optional. Followed by the database name. |
-sid: |
This parameter is Oracle specific. Followed by a SID. |
-port: |
This parameter is optional. Followed by a port number. |
-wa: |
This parameter is MSSQL specific. Followed by 0 or 1 indicating the type of authentication used: 0: SQL server authentication 1: Windows authentication |
-user: |
Followed by a user name. |
-pwd: |
Followed by an encrypted password. You must use -encrypt first. |
-pwdne: |
Followed by a password. |
-type: |
Followed by the DBMS type: ▪MSSQL ▪ORACLE ▪MySQL ▪SAPHana ▪IBMDB2 ▪MAXDB ▪IBMINFORMIX ▪SAPASE ▪PostgreSQL |
-protocol |
Parameter for Informix: ▪drsocssl ▪drsoctcp ▪drtlitcp ▪onipcshm ▪onipcstr ▪ontlitcp ▪onsocssl ▪onsoctcp ▪onsocimc ▪ontliimc ▪onsqlmux |
-server |
This parameter is Informix specific. The server name. |
-service |
This parameter is Informix specific. The TCP/IP service name. If using the service name does not work, try adding the port number in this section. |
