BES_COLUMN_HEADINGS
This view provides access to all the retrieved property information collected about client computers by the BigFix Database. Retrieved properties that return multiple results are expressed in this view by a value field that contains the multiple results separated by a newline character. Column headings whose “Value” contains more than 8000 characters are truncated to 8000 characters in this view.
| Column | Type | Description |
|---|---|---|
| ComputerID | int | Computer ID |
| Name | varchar(255) | Retrieved property name |
| Value | varchar(8000) | Newline separated list of retrieved property values |
| IsFailure | Tinyint | Nonzero if the retrieved property failed to evaluate on the BES Client |
Example:
select ComputerID, Name, Value, IsFailure from BES_COLUMN_HEADINGS where
Name = 'Total HD Space' order by ComputerID