Operating System data is empty in OS Column under Device data

book

Article ID: 132014

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA 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.