This SQL view within the ConfigMgr database stores warranty details for each device within ConfigMgr. The data is populated via Data Discovery Records (DDRs) via Recast Management Server tasks.
NOTE: ConfigMgr will delete stale data via the Site Maintenance task, Delete Aged Inventory History.
| Column Name | Description |
|---|---|
ResourceID | Internal ConfigMgr field, do not use. |
Creation_Date0 | Internal ConfigMgr field, do not use. Date the record was added to ConfigMgr. |
ResourceType | Internal ConfigMgr field, do not use. |
DataSourceCheck0 | Internal Recast field - defines how the warranty was collected. Anything less than 100 means the warranty is good. Anything 100 or greater means that RMS will check daily until the warranty is finally collected. See Understanding Warranty Data Source Check Codes. |
Description0 | Description of device |
HWDeliverables0 | Description of warranty deliverables |
HWEndDate0 | Ending date of warranty (YYYY-MM-DD) |
HWService0 | Description of warranty services |
HWServiceLevel0 | Description of warranty |
HWStartDate0 | Starting date of warranty (YYYY-MM-DD) |
HWStatus0 | Active / Expired status at the time the warranty data was collected. |
Line0 | Normal model name or part number |
Manufacturer0 | Normalized manufacturer name |
Model0 | Wordy model name |
Name0 | Do not use. |
ResourceID0 | Resource ID of the device within ConfigMgr. All joins should be on this column. |
SerialNumber0 | Validated Serial Number |
Version0 | Version of RMS used to collect the warranty details |
VPC0 | Defines whether the device is a virtual machine. (true/false, aka 1/0) |