{"action":"closed","issue":{"url":"https://api.github.com/repos/facebook/osquery/issues/4209","repository_url":"https://api.github.com/repos/facebook/osquery","labels_url":"https://api.github.com/repos/facebook/osquery/issues/4209/labels{/name}","comments_url":"https://api.github.com/repos/facebook/osquery/issues/4209/comments","events_url":"https://api.github.com/repos/facebook/osquery/issues/4209/events","html_url":"https://github.com/facebook/osquery/issues/4209","id":306895547,"number":4209,"title":"querying IP","user":{"login":"kemalbayar","id":33925821,"avatar_url":"https://avatars1.githubusercontent.com/u/33925821?v=4","gravatar_id":"","url":"https://api.github.com/users/kemalbayar","html_url":"https://github.com/kemalbayar","followers_url":"https://api.github.com/users/kemalbayar/followers","following_url":"https://api.github.com/users/kemalbayar/following{/other_user}","gists_url":"https://api.github.com/users/kemalbayar/gists{/gist_id}","starred_url":"https://api.github.com/users/kemalbayar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kemalbayar/subscriptions","organizations_url":"https://api.github.com/users/kemalbayar/orgs","repos_url":"https://api.github.com/users/kemalbayar/repos","events_url":"https://api.github.com/users/kemalbayar/events{/privacy}","received_events_url":"https://api.github.com/users/kemalbayar/received_events","type":"User","site_admin":false},"labels":[{"id":337333843,"url":"https://api.github.com/repos/facebook/osquery/labels/SQL","name":"SQL","color":"5319e7","default":false},{"id":117911476,"url":"https://api.github.com/repos/facebook/osquery/labels/question","name":"question","color":"cc317c","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-03-20T14:41:51Z","updated_at":"2018-03-20T14:46:47Z","closed_at":"2018-03-20T14:46:47Z","author_association":"NONE","body":"There are three table to get the IP of the agent; interface_addresses and Interface_details and routes table but simply I want to add the IP addres(es) of the each agent to the log(json).\r\n\r\nto do this, I used decorator feature but I have to use such a query like that\r\nselect address as IP_Address from interface_addresses where address like '10%';\r\nbecause the tables contains mixed content so I have to filter.\r\n\r\n\r\n![image](https://user-images.githubusercontent.com/33925821/37661316-93ec38b2-2c65-11e8-913d-f337c98bc6d0.png)\r\n\r\nis there a more simple way to get the IP address(es) of agents without using such the query like above?"}}
{"actor":{"display_login":"muffins"}}