Table
The Table node is used to select and store the data that you will do further analysis in the Output node. This is a sample workflow with two types of tables for different usage:
- Device Data Table (DDT) is exported from parsed variables in a Device or Command node. It only stores data for devices in the current loop and can only be referenced inside the Canvas node. The following table type is also a Device Data Table:
- System Data Table — built-in data types (including Route Table, ARP Table, MAC Table, NDP Table, STP Table, NCT Table), and only can be extended from a Command node. See Configuring system data table for more reference.
- Device/Interface Report — used to store the device or interface attributes, and can be only extended from a Device node.
- Global Data Table (GDT) is converted from a Device Data Table by the Convert Operator. It stores the data for all devices in the Device Queue. The variables in a GDT can be referenced by all Canvas nodes within a Qapp.
Configuring Device Data Table
- Extend a Device Data Table node after a Command node. For how to extend nodes, see Extending a node for reference.
- Click the
icon between the Command node and the Table node to specify which variables will be included in the table.
For interface-level variables (multi-instance variables) such as interface MTU, duplex and input/output errors, click Table>> to add them to the table. For device-level variables (single-instance variables) such as CPU usage, version, and memory size, click Attribute>> to add them to the attribute table. - Click the Table node to configure more table attributes if necessary.
- Enter the table name and description.
- In the table area, click New Column to create a new column. There are the following two types of columns:
Static Variable
Static Variable is used to create a variable manually. The variable can be called in any sub nodes within the Canvas node.
You can repeat the steps to add more columns to the table. |
Variable by formula
Variable by Formula is used to generate a new variable based on existing variables in a device data table via a calculation formula. The calculation formula supports Python expression syntax, such as operators (+, -, * and /) and parentheses. The generated variables by formula can be called in any sub nodes within the Canvas node. Configure its property as follows:
|
![]() | Tip: The attribute table pane on the right displays the built-in system attributes as long as you retrieve the live data via CLI in the Command node. When you convert the table to a Global Data Table by using the Convert Operator, the table attribute $_device will be added as a new column in the Global Data Table. |
![]() | Note: The following instructions take a Route Table for example. You can also follow the steps to configure other types of System tables. |
- Extend a Route Table node from a Device node. For how to extend nodes, see Extending a node for reference.
- Click the Route Table node to configure more attributes based on your needs.
- Modify the node name if necessary.
- Enter a description of the node in the Description field.
- Select a branch to apply if multiple branches are created in the Device node.
- Click Retrieve, select a device to retrieve route tables with live data.
Next Node: