{"action":"created","issue":{"url":"https://api.github.com/repos/facebook/osquery/issues/4449","repository_url":"https://api.github.com/repos/facebook/osquery","labels_url":"https://api.github.com/repos/facebook/osquery/issues/4449/labels{/name}","comments_url":"https://api.github.com/repos/facebook/osquery/issues/4449/comments","events_url":"https://api.github.com/repos/facebook/osquery/issues/4449/events","html_url":"https://github.com/facebook/osquery/pull/4449","id":327462170,"number":4449,"title":"[posix] Introduce nslookup table","user":{"login":"jkeljo","id":6788825,"avatar_url":"https://avatars0.githubusercontent.com/u/6788825?v=4","gravatar_id":"","url":"https://api.github.com/users/jkeljo","html_url":"https://github.com/jkeljo","followers_url":"https://api.github.com/users/jkeljo/followers","following_url":"https://api.github.com/users/jkeljo/following{/other_user}","gists_url":"https://api.github.com/users/jkeljo/gists{/gist_id}","starred_url":"https://api.github.com/users/jkeljo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jkeljo/subscriptions","organizations_url":"https://api.github.com/users/jkeljo/orgs","repos_url":"https://api.github.com/users/jkeljo/repos","events_url":"https://api.github.com/users/jkeljo/events{/privacy}","received_events_url":"https://api.github.com/users/jkeljo/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-05-29T19:48:47Z","updated_at":"2018-05-29T20:18:27Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/facebook/osquery/pulls/4449","html_url":"https://github.com/facebook/osquery/pull/4449","diff_url":"https://github.com/facebook/osquery/pull/4449.diff","patch_url":"https://github.com/facebook/osquery/pull/4449.patch"},"body":"Query by `address`, get `hostname`. Query by `hostname`, get `address`(es):\r\n\r\n```\r\nosquery> select * from nslookup where address = '8.8.8.8';\r\n+---------+--------------------------------+\r\n| address | hostname                       |\r\n+---------+--------------------------------+\r\n| 8.8.8.8 | google-public-dns-a.google.com |\r\n+---------+--------------------------------+\r\nosquery> select * from nslookup where hostname = 'google-public-dns-a.google.com';\r\n+----------------------+--------------------------------+\r\n| address              | hostname                       |\r\n+----------------------+--------------------------------+\r\n| 0:0:2001:4860:4860:: | google-public-dns-a.google.com |\r\n| 8.8.8.8              | google-public-dns-a.google.com |\r\n+----------------------+--------------------------------+\r\n```"},"comment":{"url":"https://api.github.com/repos/facebook/osquery/issues/comments/392929476","html_url":"https://github.com/facebook/osquery/pull/4449#issuecomment-392929476","issue_url":"https://api.github.com/repos/facebook/osquery/issues/4449","id":392929476,"user":{"login":"osqueryer","id":9722826,"avatar_url":"https://avatars0.githubusercontent.com/u/9722826?v=4","gravatar_id":"","url":"https://api.github.com/users/osqueryer","html_url":"https://github.com/osqueryer","followers_url":"https://api.github.com/users/osqueryer/followers","following_url":"https://api.github.com/users/osqueryer/following{/other_user}","gists_url":"https://api.github.com/users/osqueryer/gists{/gist_id}","starred_url":"https://api.github.com/users/osqueryer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/osqueryer/subscriptions","organizations_url":"https://api.github.com/users/osqueryer/orgs","repos_url":"https://api.github.com/users/osqueryer/repos","events_url":"https://api.github.com/users/osqueryer/events{/privacy}","received_events_url":"https://api.github.com/users/osqueryer/received_events","type":"User","site_admin":false},"created_at":"2018-05-29T20:18:27Z","updated_at":"2018-05-29T20:18:27Z","author_association":"COLLABORATOR","body":":-1: The commit 6098a2002def10ac231c9b23f478b037cd230525 (Job results: [4225](https://jenkins.osquery.io/job/osqueryPullRequestWindows/4225/)) failed one or more tests (**Windows**).\n"}}
{"actor":{"display_login":"osqueryer"}}