R12.1-2025Jul03
Automation Data Table Creation

ADT can serve to build an intent-based automation database for customized network assets to share across the organization, and you can use this database for Triggered and Preventive automation.

Where to Start?

  1. Go to the   menu, then click New Automation Data Table widget. In the popup dialog, define table name and select location to store the table.

  2. Go to Table Builder> Define Base Table to build a base table containing data fields to include automation asset data to be used.
      

  3. Go to Table Builder > Define Additional Column Groups, then click  to create column groups to enrich the base table data. 

  4. Go to Automation Data Table Builder (Auto-Build) to schedule to update ADT data periodically.

  5.  Go to Automation Data Table Manager (Add Column) to manually add or adjust the table data.

  6. Go to Automation Data Table Manager, then create tags for the automation column/map column from Tag Current Column of the drop-down menu. The tags can be applied to filtering the intents used for TAF, PAF, Bot, Auto Intent or Follow-up Intent.

    To build an ADT, several methods are provided to build the base table automatically. The following table provides an overview of the methods:

    Methods for Building Base Table 

    When do I need to use this method? Use Case
    DeviceDevice Group

    Need to create a critical device properties data table.

    Required Necessary Condition:

    • Create the device group.
    Build automation intent database for device groups with device properties in the device group. The resulting table contains 1 device per row.
    Site

    Need to create a critical device properties data table.

    Required Necessary Condition:

    • Create site containing useful devices.
    Build automation intent database for sites with device properties in a site. Each member device of the selected sites will occupy a row.
    Map

    Need to create a critical device properties data table.

    Required Necessary Condition:

    • Create map with useful devices.
    Build automation intent database for map with device properties in a map. Each map device of the selected maps will occupy a row.
    Pre-Decoded Intent Template

    Need to create a device-based data table using intent template.

    Required Necessary Conditions:

    • A suitable intent template.
    • Install this intent template to Intent Based Automation Center and enable decoding.
    Build the intent database for each pre-decoded device with the selected intent template. The resulting table contains 1 device and 1 replicated intent per row. Furthermore, the network attributes corresponding to the device can be extended by Macro Variables.
    Device InterfaceDevice Group

    Need to create a device and Interface data table.

    Required necessary group:

    • Create a device group.
    Build automation intent database for device groups with device and interface in the device group. Each member device interface of the selected device groups will occupy a row.
    Map

    Need to create a device and Interface data table.

    Required necessary group:

    • Create a map with devices having configured interface.
    Build automation intent database for device groups with device and interface ion a map. Each visible interface on selected maps will occupy a row.
    Application PathN/A

    Need to create a key application paths data table.

    Required Necessary Conditions:

    • Save some application paths in Path Browser.
    • Generate path intents for each path.
    Build automation intent database for a set of selected critical application paths. The resulting table contains 1 path per row. Furthermore, the path properties can be used to extend this table.
    Other ObjectMap & Map Intent

    Need to create a key map properties data table.

    Required Necessary Conditions

    • Create some key maps.
    • Generate map intents for each map.
    Build an automation intent center for a set of selected key maps and use this ADT for trigger automation to fix the network problem of the devices of the key map. The resulting table contains 1 map and 1 map intent per row. Further, the map properties can be used to extend this table.
    Device Group

    Need to create a key device group properties data table.

    Required Necessary Conditions

    • Create some device groups.

     

    Build an automation intent center for a set of selected device groups. Furthermore, the device group properties can be used to extend this table. Each selected device group will occupy a row.
    Site

    Need to create a critical site properties data table.

    Required Necessary Conditions:

    • Create some sites.
    Build automation intent database for a set of selected critical sites. The resulting table contains 1 site device and 1site map intent per row. Furthermore, the site properties can be used to extend this table.
    Intent from Intent Cluster

    Need to create a network automation asset data table about a specific network technology.

    Required Necessary Conditions:

    • A suitable Network Intent Cluster
    • Pre-generated the member intents of this intent cluster
    Build automation intent database for pre-generated member intents of an intent cluster. One intent cluster represents one network technology. The resulting table contains 1 member intent per row. Furthermore, the attributes corresponding to the automation asset can be extended by signature variables.
    Data from Other TableMerged ADT

    Some ADTs already exist and want to create a table by merging the data from those ADTs.

    Required Necessary Conditions:

    • Pre-define some ADTs.
    Build a new ADT by merging the data from several other tables with defined paired key. The method for joining table can be selected.
    Subset of ADT

    A source ADT already exists and want to create a table by extracting part of the data from the source ADT.

    Required Necessary Conditions:

    • Pre-define an ADT.
    Build a new ADT from the column data from an existing ADT. The data of the existing ADT can be filtered by empty cell or by defining conditions.
    Imported CSV

    A pre-generated CSV file is available and want to create a table data with the CSV data.

    Required Necessary Condition:

    • A suitable CSV file
    Build an intent database with the columns in the imported CSV file. The table key can be manually set. The resulting table contains 1 CSV row per row.
    Manual InputN/AThis method is applied when the auto-generated data cannot meet the requirements.Manually Build an automation intent database with the available data type. One row or column (added one by one).
    Information Tip: You can populate ADT column or update ADT column by using intent template data in Intent Replication Wizard

    If you need to enrich the ADT with more column groups, follow the instructions in Enrich Basic Table Data with Column Groups.