Inventory_DIM Table

Inventory_DIM is a dimension table storing the inventory devices data

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for Inventory_DIM table

Database Column

Details

ComplianceComputerID

Type: integer. Key

Primary key of the inventory device.

ComputerName

Type: text (max 256 characters). Nullable

The name of the computer.

ComplianceComputerTypeID

Type: integer

A unique identifier for the type of computer.

OperatingSystem

Type: text (max 128 characters). Nullable

The operating system of the computer.

InventoryDate

Type: datetime. Key. Nullable

The date the computer last had inventory reported.

LocationID

Type: text (max 128 characters). Key. Nullable

Any enterprise location associated with this computer.

CorporateUnitID

Type: text (max 128 characters). Key. Nullable

Any corporate unit in the enterprise associated with this computer.

CostCenterID

Type: text (max 128 characters). Key. Nullable

Any cost center in the enterprise associated with this computer.