Software view by device
Fields
| Field | Type | Description |
|---|---|---|
| composite_id | NVARCHAR (MAX) | Concatenation between the device name and the installed software id |
| installation_date | DATETIME | Software Installation Date |
| pc* | NVARCHAR (80) | Device Name |
| serial | NVARCHAR (510) | Device Serial |
| software_id | INT | Installed software ID |
| software_name | NVARCHAR (512) | Name of installed software |
| software_version | NVARCHAR (510) | Software version |