{"action":"opened","issue":{"url":"https://api.github.com/repos/rapid7/nexpose-client/issues/210","repository_url":"https://api.github.com/repos/rapid7/nexpose-client","labels_url":"https://api.github.com/repos/rapid7/nexpose-client/issues/210/labels{/name}","comments_url":"https://api.github.com/repos/rapid7/nexpose-client/issues/210/comments","events_url":"https://api.github.com/repos/rapid7/nexpose-client/issues/210/events","html_url":"https://github.com/rapid7/nexpose-client/issues/210","id":139075228,"number":210,"title":"Return nexpose_id via API using vulnid","user":{"login":"ben-git-hub99","id":15223006,"avatar_url":"https://avatars.githubusercontent.com/u/15223006?v=3","gravatar_id":"","url":"https://api.github.com/users/ben-git-hub99","html_url":"https://github.com/ben-git-hub99","followers_url":"https://api.github.com/users/ben-git-hub99/followers","following_url":"https://api.github.com/users/ben-git-hub99/following{/other_user}","gists_url":"https://api.github.com/users/ben-git-hub99/gists{/gist_id}","starred_url":"https://api.github.com/users/ben-git-hub99/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ben-git-hub99/subscriptions","organizations_url":"https://api.github.com/users/ben-git-hub99/orgs","repos_url":"https://api.github.com/users/ben-git-hub99/repos","events_url":"https://api.github.com/users/ben-git-hub99/events{/privacy}","received_events_url":"https://api.github.com/users/ben-git-hub99/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-03-07T19:48:16Z","updated_at":"2016-03-07T19:48:16Z","closed_at":null,"body":"Hi,\r\n\r\nI would like to see if the ability exists or can be easily created to pull the nexpose_id via API just in general. The SQL query is incredibly slow ``` SELECT nexpose_id from dim_vulnerability where vulnerability_id = 'xxx'```\r\n\r\nI am aware that #list_device_vulns exists. However, if the vulnerability was resolved prior, this causes my code to throw an exception or force a full scan. \r\n\r\nThis would help resolve 2 major bugs in our code deployment. Thanks!\r\n\r\nHere is some example code.\r\n```\r\n      a = nsc.list_device_vulns(d)\r\n      id = ''\r\n      a.each {|v| v.console_id == vulnid.to_i ? (id = v.id) : (raise Exception.new(\"No vulnerability found.\"))}```"}}