SELECT OH_Name AS “Agent”, HOST_HostAttrType AS “Platform”
FROM OH
JOIN HOST ON OH_Idnr = HOST_OH_Idnr
JOIN HACL ON OH_Idnr = HACL_OH_Idnr
WHERE OH_OType = ‘HOST’
AND HACL_Client = ?
AND OH_DeleteFlag = 0
Statement (Oracle)
SELECT OH_Name AS “Agent”, HOST_HostAttrType AS “Platform”
FROM OH
JOIN HOST ON OH_Idnr = HOST_OH_Idnr
JOIN HACL ON OH_Idnr = HACL_OH_Idnr
WHERE OH_OType = ‘HOST’
AND HACL_Client = ?
AND OH_DeleteFlag = 0