OctoSAM tables and columns (Internal)¶
OctoSAM Internal Query
Internal queries are advanced queries for analysis of the inner workings of the OctoSAM application. These queries are geared towards administrators with an in-depth knowledge of OctoSAM.
List all tables and columns of the OctoSAM database schema.
The query also includes the description of each column as specified in the MS_Description extended property. The description is used in the OctoSAM Inventory user interface to provide additional information about the column. The query also includes the type of the column, whether it is part of the primary key, and the name of the table that is referenced by this foreign key column.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| Table Name | string | true | Table Name |
| Table Description | bool | false | True if the description belongs to the table, not the column |
| Data Type | string | true | SQL type of the column |
| Is Primary Key | bool | true | True if this column is part of the primary key |
| Column Name | string | true | Column Name |
| Primary Table | string | true | Name of the table that is referenced by this foreign key column |
| Description | string | true | Description of the column as specified in the OctoSAM Inventory database. This is the MS_Description extended property. |
| Current Date Time | date | false | Date and time the query was run. For reference if you use and save query results. |
Main entities referenced from this query¶
Query information¶
| Property | Value | Description |
|---|---|---|
| Query Guid | a6a2069b-8762-4c1f-ab3e-1b8bd05b2910 | The internal id of the query. Must be unique |
| SupportsDesktop | true | If true, the query can be started from the OctoSAM Windows GUI |
| SupportsWeb | true | If true, the query can be started from the OctoSAM Web UI |