Asset Report - Purchase and Expiration Date

Summary

Dataview displays the information gathered by the CWM - Automate - Script - Get CWM Configurations - Active And Managed Only script along with some basic information.

Dependencies

• CWM - Automate - Script - Get CWM Configurations - Active And Managed Only
• CWM - Automate - Custom Table - pvl_cwm_configurations

Columns

Column	Description
clientid	Client ID
locationid	Location ID
computerid	Computer ID
Client	Client Name
Location	Location Name
Computer	Computer Name
Operating System	Operating System
Last Logged In User	Last Logged In User
Last Contact	Last Contact with Automate
Purchase Date	Purchase Date (From CW Manage)
Expiration Date	Warranty Expiration Date (From CW Manage)
Is Virtual	Is Virtual? (Yes/No)
Status	Warranty Status of the computer. Conditional formatting is applied to this column: - Expired: Dark Red - Expiring < 90 Days: Dark Orange - In Warranty: Dark Green - N/A: Virtual computers/Computers not having Warranty Date available
Model Number	Computer's Model (From CW Manage)
Serial Number	Serial Number of computer (Hidden)
Data Collection Time	Data Collection Time