CompliancePredefinedSearch Table

The CompliancePredefinedSearch holds a list of the predefined asset and licenses searches available to the operator. Each predefined search has its own grid in the IT Asset Management UI, and is accessed from a node which is a child of either Licenses or Assets nodes.

Table 1. Database columns for CompliancePredefinedSearch table

Database Column

Details

CompliancePredefined SearchID

Type: integer. Key. Generated ID

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

  • 1 = New Inventory
  • 2 = Changed Assets
  • 3 = Lease Expiry
  • 4 = Warranty Expiry
  • 5 = Missing Computers
  • 6 = License At Risk
  • 7 = License Expiry
  • 8 = License Contract Expiry
  • 9 = License Unused
  • 10 = UnLicensed Apps
  • 11 = UnLicensed Installs
  • 12 = License Group At Risk
  • 13 = License Upgrade Downgrade.
SearchNameResource

Type: text (max 128 characters). Key

Resource string identifying the predefined search.

SearchNameDefault

Type: text (max 128 characters)

The name of the predefined search.

AmberThreshold

Type: integer

Indicates when the amber state should be shown in the related traffic light summary.

RedThreshold

Type: integer

Indicates when the red state should be shown in the related traffic light summary.

DateSearch

Type: boolean. Key

True indicates that the search is date based. False means count based.

ComplianceSearchType

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

Type of search. Matches the name of a row in the ComplianceSearchType table.