- 16 May 2022
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
BeyondTrust Insight SQL
- Updated on 16 May 2022
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
BeyondTrust Insight SQL provides discovery, management, auditing, and monitoring for any privileged credential.
Types of Assets Fetched
This adapter fetches the following types of assets:
- Devices
Parameters
- Server Host or IP Address (required) - The DNS / IP Address of the Microsoft SQL Server your BeyondTrust Insight SQL Database instance is using.
- To use a specific named instance, the value supplied should be in the following format: {server_host}{instance_name}.
- If no instance is supplied, the default instance will be used.
- Port (optional, default: 1433) - The required ports are:
- Microsoft SQL Server discovery port - 1433.
- The specific port for the supplied named instance, if relevant.
- User Name (required) - The credentials for a user account that has the required permissions to fetch assets.NOTE
- The best practice is to create a dedicated SQL local user for Axonius usage. For details on creating an Axonius user for Microsoft SQL Server, see Creating a Local Read-Only User for Microsoft SQL Server.
- If you are using a domain user, specify the domain and the user name in the following format: domain\username.
- Password (required) - The user's password. The password must not include ";".
- For details on the common adapter connection parameters and buttons, see Adding a New Adapter Connection.
Advanced Settings
From version 4.6 Advanced settings can either apply for all connections for this adapter, or you can set different advanced settings and/or different scheduling for a specific connection, refer to Advanced Configuration for Adapters
- SQL pagination (required, default: 1000) - Set the number of results per page received for a given SQL query, to gain better control of the performance of all connections for this adapter.
For details on general advanced settings under the Adapter Configuration tab, see Adapter Advanced Settings.
Required Permissions
The value supplied in User Name must have Read permissions to fetch assets.
Supported From Version
Supported from Axonius version 4.5
Troubleshooting
- "Login failed" - If you are using a domain user, in the User Name field, specify the domain and the user name in the following format: domain\username.