1 SELECT A.DeviceID0 AS 'DeviceID', B.Netbios_Name0 AS 'Name', B.Operating_System_Name_and0 AS 'OS_Name', C.Storage0 AS 'Storage', C.StorageFree0 AS 'Storage_Available', STR(A.ResourceID) + '_' + A.DeviceID0 AS 'tSID', 'Mobile Device' AS 'Asset Type' FROM ((v_GS_DEVICE_COMPUTER_SYSTEM AS A LEFT JOIN v_R_System AS B ON A.ResourceID = v_R_System.ResourceID) LEFT JOIN v_GS_DEVICE_MEMORY AS C ON A.ResourceID = C.ResourceID) SCCMMobileDevices.xml Assets - SCCM Mobile Devices