Operating System data is empty in OS Column under Device data
book
Article ID: 132014
calendar_today
Updated On:
Products
CA IT Asset ManagerCA Software Asset Manager (CA SAM)ASSET PORTFOLIO MGMT- SERVERCA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
Issue/Introduction
The Operating System Column in Device data is empty for all the devices. All the OS are listed there in Operating System Master data however when we are checking the Device data, the OS filed is empty.
Environment
4.3.1
Resolution
dTb.[OS] as Operating_system. Is the Query which is being used.
In newer systems the table operating systems is split of the devices table, so you need to import operating systems into the tables operating system and reference it in the device import by using dTb.[os] AS import_operating_system_id.