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.
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. |