SQL - Update Assets in Table

New
  • Published on Apr 24, 2025
  • 2 minute(s) read
Prev Next

SQL - Update Assets in Table updates the assets returned by the selected query, or assets selected on the relevant asset page, in the MSSQL table supplied (editing existing rows). The assets are updated based on the ID field, parsed in Axonius as mssql__id.

See Creating Enforcement Sets to learn more about adding Enforcement Actions to Enforcement Sets.

Note:

Required Fields

These fields must be configured to run the Enforcement Set.

  • Action name - The name of this Enforcement Action. The system sets a default name. You can change the name.
  • Configure Dynamic Values - Toggle on to enter a Dynamic Value statement. See Creating Enforcement Action Dynamic Value Statements to learn more about Dynamic Value statement syntax.

  • Use stored credentials from SQL Server adapter - Select this option to use credentials from the adapter connection. By default, the first connection is selected.

    • When you select this option, the Select Adapter Connection drop-down becomes available. Select the adapter connection to use for this Enforcement Action.
    Note:
    To use this option, you must successfully configure an SQL Server adapter connection.

  • Map Axonius fields to adapter fields - Use the Field Mapping Wizard to map Axonius fields to fields in external systems. In this way you can transfer data found in Axonius into the external system as part of the configuration of relevant enforcement actions. The wizard shows you which fields exist on the Axonius system, allowing you to map them easily.

    Note:

    For details, see Axonius to External Field Mapping.

  • Compute Node - The Axonius node to use when connecting to the specified host. For more details, see Connecting Additional Axonius Nodes.

Additional Fields

These fields are optional.

Connection and Credentials

When Use stored credentials from the adapter is toggled off, some of the connection fields below are required to create the connection, while other fields are optional.


For the full list of the connection fields for this action, see SQL Server Connection Parameters.

  • Gateway Name - Select the Gateway through which to connect to perform the action.

APIs

Axonius uses the SQL Alter User API.

Required Permissions

The stored credentials, or those provided in Connection and Credentials, must have the following permission(s) to perform this Enforcement Action:

  • WRITE privileges

For more details about other Enforcement Actions available, see Action Library.