Skip to main content

1E SDK

Inventory.GetTables

Method

GetTables

Module

Inventory

Library

Inventory

Action

Returns details about the $tables used by Tachyon Activity Record.

Parameters

(None)

Return values

Table (string): The name of the table (without the $ prefix)

RowCount (int): The number of rows in the table.

Example

@tables = Inventory.GetTables();
@hasDnsLive = SELECT 1 FROM @tables WHERE Table = "DNS_Live" COLLATE NOCASE;
IF (@hasDnsLive)
   // perform query on table
ELSE
   // take appropriate action
ENDIF;

Platforms

  • Windows

  • Linux

  • MacOS

Notes

This method is useful to perform a defensive query against the inventory tables (which may not exist if the specific capture source has been disabled)

For more information, see Tachyon Activity Record.