SELECT OH_Name AS “Agent”, HOST_HostAttrType AS “Platform”
FROM OH
JOIN HOST ON OH_Idnr = HOST_OH_Idnr
WHERE OH_OType = ‘HOST’
AND OH_DeleteFlag = 0
AND HOST_HostAttrType in ( ‘WINDOWS’, ‘UNIX’, ‘BS2000’, ‘OS400’, ‘OS390’ )
AND HOST_Active = 1
Statement (Oracle)
SELECT OH_Name AS “Agent”, HOST_HostAttrType AS “Platform”
FROM OH
JOIN HOST ON OH_Idnr = HOST_OH_Idnr
WHERE OH_OType = ‘HOST’
AND OH_DeleteFlag = 0
AND HOST_HostAttrType in ( ‘WINDOWS’, ‘UNIX’, ‘BS2000’, ‘OS400’, ‘OS390’ )
AND HOST_Active = 1