PatchData — Advanced Software Management

Column Name	Type	Description

Column Name	Type	Description
DeviceGuid	uniqueidentifier	A unique ID to identify the device, associated with Advanced Software Management.
DeviceName	nvarchar(255)	Identifies the name of the device name associated with Advanced Software Management.
BulletinID	varchar(36)	A unique identifier for the bulletin.
Approval	varchar(11)	The approval status of the patch on the device. Possible values are: Install Uninstall Declined Not Approved
Status	varchar(22)	The status of the patch on the device. Possible values are: Unknown Not Needed Needed Needed Installed Failed Installed
InstallDate	datetime	The date and time the patch was installed.
TimeLastUpdate	datetime	The date and time of the last patch update.