https://github.com/osquery/osquery logo
Title
g

girish

05/24/2023, 4:10 PM
Hello all..please help.. how to get the ip address using a query. i see the ip when i click 'hosts' but unable to retrieve it. thank you
k

Kathy Satterlee

05/24/2023, 5:16 PM
Here are the queries Fleet is using to get IP information. There's some processing that happens server side, as well as grabbing data from the headers when a host checks in. How are you planning in using this info? It may be more reliable to let Fleet handle it, and then get the info from the REST APi.
g

girish

05/25/2023, 8:20 AM
Thanks Kathy. We are planning to use osq+fleet for providing data to the cmdb repository..example - xyz server, win/linux, cpu name, cpu manufacturer, ip address etc. the query mentioned in the page did not yield a result :(