AssetComplianceColumn Table

The AssetComplianceColumn table lists the columns (or aspects of the asset record) for which compliance changes can be tracked.

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 AssetComplianceColumn table

Database Column

Details

AssetComplianceColumnID

Type: integer. Key. Generated ID

A unique identifier for each AssetComplianceColumn. Possible values and the corresponding default strings are:

  • 1 = Operating System
  • 2 = Service Pack
  • 3 = Number of Processors
  • 4 = Processor Type
  • 5 = Max Clock Speed
  • 6 = Total Memory
  • 7 = Chassis Type
  • 8 = Number of Hard Drives
  • 9 = Total Disk Size
  • 10 = Number of Network Cards
  • 11 = Number of Display Adapters
  • 12 = IP Address
  • 13 = MAC Address
  • 14 = Host
  • 15 = Number of Cores
  • 16 = Number of Threads.
ColumnNameResourceName

Type: text (max 256 characters). Nullable

The unique name of the localizable resource string representing a compliance-tracked column. Foreign key to the ComplianceResourceString table.

ColumnName

Type: text (max 128 characters). Key

The text to display if the column resource string has no translation.

IsColumnNumeric

Type: boolean

Indicates whether the column is numeric (True) or a string (False).

ComplianceAction

Type: integer

Bitwise value to indicate what type of action to track change on.

TrackComplianceBitwise Value

Type: integer

Bitwise value indicating which asset types compliance tracking is turned on for.