| Field | Description |
|---|---|
| Server Name |
Name of the PostgreSQL server. Mandatory: Yes |
| Database Name |
Name of the PostgreSQL database to use when running the query. Mandatory: Yes |
| Port |
Port number of the PostgreSQL server. Mandatory: Yes |
| Application Name |
Application name to be set to the connection created from the sampler to the Database Server. Mandatory: No Default: NetProbe (listen-port <Netprobe's port>) |
| Use Windows authentication |
Windows only. When enabled, the Netprobe authenticates to PostgreSQL using Windows SSPI instead of a password. If Username and Password are blank, the Netprobe process identity is used. If both are set, the Netprobe impersonates that Windows user for the connection. Mutually exclusive with Advanced Kerberos. Do not enable this setting when Advanced Kerberos is configured. Mandatory: No Default: |
| SSL Configuration > SSL Mode |
Mode of SSL connection. The following are the possible values:
Mandatory: Yes, if the SSL Configuration is enabled. |
| SSL Configuration > CA Certificate |
Path to the Certificate Authority (CA) certificate file used by the server. Mandatory: No |
| SSL Configuration > Client Certificate |
Path to the client's public key certificate file. Mandatory: No |
| SSL Configuration > Client Key |
Path to the client's private key file. Mandatory: No |
| Field | Description |
|---|---|
| Server Name |
Name of the SQL Server. When connecting to named instances the format should be Mandatory: Yes Note: Dynamic MS SQL instances are not supported. |
| Database Name |
Name of the database to use when running the query if the database name is not specified in the query. If the query contains a valid database name, this value will be ignored. Mandatory: No |
| Port |
Port number that SQL Server is listening on. Mandatory: No Default: |
| MultiSubnetFailover |
Allows you to enable or disable the Mandatory: No Default: |
| Application Name |
Application name to be set to the connection created from the sampler to the Database Server. Mandatory: No Default: NetProbe (listen-port <Netprobe's port>) Note: This option is only valid for Windows platforms. |
| Use Windows authentication |
Note: Beginning Geneos 5.6.x, this plugin supports Windows authentication for Linux platforms. For more information, see Active Directory: Using Kerberos Keytabs to integrate non-Windows systems. Login using Windows authentication instead of ASE authentication. User accounts used in Windows authentication should have a The credentials used for authentication are the username and password provided in the fields. On Windows, if the username and password fields are left blank, then the currently logged-on user executing the probe will be used. On Linux, if the username and password fields are left blank and useWindowsAuthentication is set to You can specify a domain by entering the username using the UPN format or the down-level logon format. If invalid credentials are supplied, then the sampler will fall back to SQL authentication. Mandatory: No Default: |
| gMSA |
When enabled, the SQL Toolkit plugin authenticates to an SQL Server database using the specified Group Managed Service Account (gMSA). Before enabling gMSA, ensure the following prerequisites are met:
Accepted credential formats:
Mandatory: No |
| SSL Configuration > Encryption option |
Specifies whether the data should be encrypted before sending it over the network. The following are the possible values:
Default: |
| SSL Configuration > Encryption option > Optional/Mandatory > Trust server certificate |
Enabling or disabling the Trust Server Certificate option affects how the Netprobe handles the server's SSL certificate during the connection process:
|
| SSL Configuration > Encryption option > Optional/Mandatory > Hostname in certificate |
Specifies the expected hostname in the server's certificate during encryption negotiation if it's different from the default value derived from This setting is ignored when TrustServerCertificate is |
| SSL Configuration > Encryption option > Strict > Server certificate |
Specifies the path to a certificate file to check if an exact match against the SQL Server TLS/SSL certificate. |
| SSL Configuration > Encryption option > Strict > Hostname in certificate |
Specifies the expected hostname in the server's certificate during encryption negotiation if it's different from the default value derived from This setting is Ignored when ServerCertificate is specified. |
| QUERY | SQL*PLUS | Netprobe |
|---|---|---|
| Simple SELECT query |
SELECT * FROM tbl_name;
|
SELECT * FROM tbl_name
|
| Function call without parameters |
SELECT func_name FROM dual;
|
SELECT func_name FROM dual
|
| Function call with input parameters |
SELECT func_name('str', 1)
FROM dual;
|
SELECT func_name('str', 1) FROM dual
|
SELECT func_name(col1, col2)
FROM tbl_name;
|
SELECT func_name(col1, col2)
FROM tbl_name
|
|
| Procedure call without parameters |
exec proc_name;
|
proc_name
|
BEGIN proc_name; END;
|
||
| Procedure call with input parameters |
exec proc_name('str', 1);
BEGIN proc_name ('str', 1); END;
|
BEGIN proc_name ('str', 1); END;
|
| Procedure call with output parameter |
DECLARE num NUMBER;
BEGIN
proc1(num); -- as output
proc2(num); -- as input
END;
|
DECLARE num NUMBER;
BEGIN
proc1(num);
proc2(num);
END;
|
| QUERY | ISQL | Netprobe |
|---|---|---|
| Simple SELECT query |
SELECT * FROM tbl_name
GO
|
SELECT * FROM tbl_name
|
| Function call without parameters |
SELECT dbo.func_name()
GO
|
SELECT dbo.func_name()
|
| Function call with input parameters |
SELECT dbo.func_name('str',1)
GO
|
SELECT dbo.func_name('str',1)
|
SELECT dbo.func_name(col1, col2)
FROM tbl_name
GO
|
SELECT dbo.func_name(col1, col2)
FROM tbl_name
|
|
| Procedure call without parameters |
EXECUTE proc_name
GO
|
Note If a procudure is returning multiple resultsets, only the first resultset will be displayed in the dataview. |
| Procedure call with input parameters |
EXECUTE proc_name 'str',1
GO
|
EXECUTE proc_name 'str',1
|
BEGIN proc_name 'str', 1 END
GO
|
BEGIN proc_name 'str', 1 END
|
|
| Procedure call with output parameter |
DECLARE @num TINYINT
EXECUTE proc1 @num OUTPUT
EXECUTE proc2 @num IN
|
DECLARE @num TINYINT
EXECUTE proc1 @num OUTPUT
EXECUTE proc2 @num IN
|
| QUERY | MYSQL | Netprobe |
|---|---|---|
| Simple SELECT query |
SELECT * FROM tbl_name;
|
SELECT * FROM tbl_name
|
| Function call without parameters |
SELECT func_name FROM dual;
|
SELECT func_name FROM dual
|
SELECT func_name;
|
SELECT func_name
|
|
|
Note Function calls without table reference can be called with or without 'FROM dual' |
||
| Function call with input parameters |
SELECT func_name('str', 1);
|
SELECT func_name('str', 1)
|
SELECT func_name(col1, col2)
FROM tbl_name;
|
SELECT func_name(col1, col2)
FROM tbl_name
|
|
| Procedure call without parameters |
CALL proc_name;
|
Note If a procudure is returning multiple resultsets, only the first resultset will be displayed in the dataview. |
| Procedure call with input parameters |
CALL proc_name('str',1);
|
CALL proc_name('str',1)
|
| Procedure call with output parameter |
EXECUTE proc1(@num); --as output
EXECUTE proc2(@num); --as input
|
EXECUTE proc1(@num);
EXECUTE proc2(@num)
|
| QUERY | DB2 | Netprobe |
|---|---|---|
| Simple SELECT query |
SELECT * FROM tbl_name
|
SELECT * FROM tbl_name
|
| Function call without parameters |
SELECT func_name
FROM SYSIBM.SYSDUMMY1
|
SELECT func_name
FROM SYSIBM.SYSDUMMY1
|
SELECT *
FROM TABLE(func_name)
|
SELECT *
FROM TABLE(func_name)
|
|
| Function call with input parameters |
SELECT func_name('str', 1)
FROM SYSIBM.SYSDUMMY1
|
SELECT func_name('str', 1)
FROM SYSIBM.SYSDUMMY1
|
SELECT func_name(col1, col2)
FROM tbl_name
|
SELECT func_name(col1, col2)
FROM tbl_name
|
|
SELECT *
FROM TABLE(func_name('str', 1))
|
SELECT *
FROM TABLE(func_name('str', 1))
|
|
| Procedure call without parameters |
CALL proc_name
|
CALL proc_name
|
| Procedure call with input parameters |
CALL proc_name('str',1)
|
CALL proc_name('str',1)
|
| Procedure call with output parameter |
BEGIN
DECLARE num SMALLINT;
CALL proc1(num); -- as output
CALL proc2(num); -- as input
END
|
BEGIN
DECLARE num SMALLINT;
CALL proc1(num);
CALL proc2(num);
END
|
| QUERY | ISQL | Netprobe |
|---|---|---|
| Simple SELECT query |
SELECT * FROM tbl_name;
|
SELECT * FROM tbl_name
|
| Function call without parameters |
SELECT func_name;
|
SELECT func_name
|
SELECT *
FROM func_name;
|
SELECT *
FROM func_name
|
|
| Function call with input parameters |
SELECT func_name('str', 1);
|
SELECT func_name('str', 1)
|
SELECT *
FROM func_name('str', 1);
|
SELECT *
FROM func_name('str', 1)
|
|
SELECT func_name(col1, col2)
FROM tbl_name;
|
SELECT func_name(col1, col2)
FROM tbl_name
|
|
| Procedure call without parameters |
EXEC proc_name;
|
EXEC proc_name
|
| Procedure call with input parameters |
EXEC proc_name 'str',1;
|
EXEC proc_name 'str',1
|
| Procedure call with output parameter |
DECLARE @lastRw TINYINT;
EXEC get_max_ @lastRw OUTPUT;
EXEC insertNextRow @lastRw;
|
DECLARE @lastRw TINYINT
EXEC get_max_ @lastRw OUTPUT
EXEC insertNextRow @lastRw
|
| QUERY | ISQL | Netprobe |
|---|---|---|
| Simple SELECT query |
SELECT * FROM tbl_name;
|
SELECT * FROM tbl_name
|
| Function call without parameters |
SELECT func_name();
|
SELECT func_name()
|
SELECT *
FROM func_name();
|
SELECT *
FROM func_name()
|
|
| Function call with input parameters |
SELECT func_name('str', 1);
|
SELECT func_name('str', 1)
|
SELECT *
FROM func_name('str', 1);
|
SELECT *
FROM func_name('str', 1)
|
|
SELECT func_name(col1, col2)
FROM tbl_name;
|
SELECT func_name(col1, col2)
FROM tbl_name
|
|
|
Function call with output parameter
Note: Output parameters are not included in the function call. |
SELECT func_name('str', 1);
|
SELECT func_name('str', 1)
|
SELECT *
FROM func_name('str', 1);
|
SELECT *
FROM func_name('str', 1)
|