Logo
My activities
Submit a Ticket >

Toll Free: 1.877.776.2995

Run a Database Query for the IPV4 Address of an Entity

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;

Follow
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk