.png?sv=2019-07-07&sig=VDrJVfqRhqf9MmqKQ%2BCLaH6o6pViZiSDvQ0HiDaZtug%3D&spr=https%2Chttp&st=2023-03-25T11%3A41%3A36Z&se=2023-03-25T11%3A51%3A36Z&srt=o&ss=b&sp=r){kind=logo}
SQL - Send Assets to Table
- 17 Jan 2023
- 3 Minutes to read
-
Print
-
DarkLight
-
PDF
SQL - Send Assets to Table
- Updated on 17 Jan 2023
- 3 Minutes to read
-
Print
-
DarkLight
-
PDF
SQL - Send Assets to Table (Send to SQl Table) inserts the entities retrieved from the saved query supplied as a trigger (or entities selected in the asset table) to the MSSQL table supplied.
When used with a saved query as a trigger, only the fields configured in the saved query are inserted into the table supplied.
See Creating Enforcement Sets to learn more about adding Enforcement Actions to Enforcement Sets.
General Settings
- Enforcement Set name (required) - The name of the Enforcement Set. A default value is added by Axonious. You can change the name according to your needs.
- Add description (optional) - Click to add a description of the Enforcement Set. It is recommended to describe what the Enforcement Set does.
- Run action on assets matching following query (required) - Select an asset category and a query. The Enforcement Action will be run on the assets that match the query parameters.
- A query only returns results for the asset type it was created for.
- Not all asset categories are supported for all Enforcement Actions.
- See Actions supported for Activity Logs and Adapter Fetch History Modules
- Action name - The name of the Main action. A default value is added by Axonious. You can change the name according to your needs.
- Configure Action Conditions - Toggle on to enter a condition statement. See Configuring Enforcement Action Conditions to learn more about condition statement syntax.
Required Fields
Click to view Required Fields
These fields must be configured to run the Enforcement Set.
-
DB Type (required) - Select the type of database, either Oracle,MSSQL or PostgreSQL.
-
SQL Server host (required) - The hostname / domain of the SQL server.
-
SQL Server port (required) - The port of the SQL server.
-
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 ";".
-
SQL Server database name (required) - The database to connect to.
-
SQL Server table name (required) - The name of the table to fetch information from. Axonius runs a 'SELECT * FROM [[specified value]]' statement.
-
Chunk size -When working with servers that are limited to certain data size in a request, set the chunk size to which the message is broken up to (default 50).
Additional Fields
Click to view Additional Fields
-
Truncate table data before update (required, default: False) - Select whether to truncate the table data before update.
- If enabled, the table data will be truncated and the table will contain only the newly added records.
- If disabled, the table data will not be truncated and new records will be added to the existing table.
-
Create table if not exist (required, default: True) - Select whether to create a new SQL table if the supplied table name does not exist.
- If enabled, a new SQL table will be created if the supplied table name is not found.
- If disabled, the action will fail, as the supplied table name is not found.
-
Re-create table each time (required, default: True) - Select to delete the table on the server side and create a new one every time the action is run
-
Map Axonius fields to SQL Server fields (optional, default: empty) - Use the Field Mapping Wizard to map Axonius fields to SQL Server table columns. In this way you can transfer data found in Axonius into SQL Server. The wizard shows you which fields exist on the Axonius system, allowing you to map them easily.
NOTEFor more details about the supported syntax for Axonius fields, see Axonius to External Field Mapping.
-
Split by field values - Use this option to create a new row for each item in the field. Enter a key (string) with data as stored in the database in the format of a list of dictionaries (str: str) or strings. If it's a list of strings only one column will be added for each In case of dictionary it will add a column for each key“
- Tunnel Name - For Axonius-hosted (SaaS) deployments. Select the tunnel through which to connect to perform the action.
For more details about other Enforcement Actions available, see Action Library.