Applies to RiskVision Versions: 7.0, 8.0, 8.5
Resolution: Refer to the following query:
SELECT cs.host_name AS HOST_NAME, cs.domain_name AS DOMAIN_NAME , CONCAT((ep.ipv4_address >> 24) & 0xFF, '.', (ep.ipv4_address >> 16) & 0xFF, '.', (ep.ipv4_address >> 8) & 0xFF, '.', (ep.ipv4_address) & 0xFF) AS IP_ADDRESS FROM agl_asset a, agl_computersystem cs INNER JOIN agl_endpoint ep ON cs.asset_id = ep.asset_id WHERE a.asset_id =cs.asset_id;