Mod to the above script - Replace with (Test with/For ADDM 8.2.1 and above)
TPL File
if disk_size then
disk_size := text.toNumber(disk_size)/1073741824;
end if;
XML Report File
<show>
#:::Host.name AS "Host",
summary,
size AS 'Size (GB)',
media_loaded,
status,
last_seen,
#:::Host.last_update_success AS 'Host last success'
</show>
For Reference Custom Query
SEARCH Detail
WHERE type = "USB Drive"
ORDER BY #:::Host.name
SHOW #:::Host.name AS "Host",
summary,
size AS 'Size (GB)',
media_loaded,
status,
last_seen,
#:::Host.last_update_success AS 'Host last success'
(Added code tags - Charles)