{"action":"created","issue":{"url":"https://api.github.com/repos/inspec/inspec-azure/issues/198","repository_url":"https://api.github.com/repos/inspec/inspec-azure","labels_url":"https://api.github.com/repos/inspec/inspec-azure/issues/198/labels{/name}","comments_url":"https://api.github.com/repos/inspec/inspec-azure/issues/198/comments","events_url":"https://api.github.com/repos/inspec/inspec-azure/issues/198/events","html_url":"https://github.com/inspec/inspec-azure/issues/198","id":497601127,"node_id":"MDU6SXNzdWU0OTc2MDExMjc=","number":198,"title":"AzurermAdUsers.guest_accounts unusable for large AD","user":{"login":"james-stocks","id":12136665,"node_id":"MDQ6VXNlcjEyMTM2NjY1","avatar_url":"https://avatars1.githubusercontent.com/u/12136665?v=4","gravatar_id":"","url":"https://api.github.com/users/james-stocks","html_url":"https://github.com/james-stocks","followers_url":"https://api.github.com/users/james-stocks/followers","following_url":"https://api.github.com/users/james-stocks/following{/other_user}","gists_url":"https://api.github.com/users/james-stocks/gists{/gist_id}","starred_url":"https://api.github.com/users/james-stocks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/james-stocks/subscriptions","organizations_url":"https://api.github.com/users/james-stocks/orgs","repos_url":"https://api.github.com/users/james-stocks/repos","events_url":"https://api.github.com/users/james-stocks/events{/privacy}","received_events_url":"https://api.github.com/users/james-stocks/received_events","type":"User","site_admin":false},"labels":[{"id":522455611,"node_id":"MDU6TGFiZWw1MjI0NTU2MTE=","url":"https://api.github.com/repos/inspec/inspec-azure/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2019-09-24T10:30:42Z","updated_at":"2019-09-26T16:46:45Z","closed_at":null,"author_association":"NONE","body":"Customer is running this test and reports that it always fails:\r\n\r\n```\r\n  describe azurerm_ad_users do\r\n    its('guest_accounts') { should eq [] }\r\n  end\r\n```\r\n\r\n## Possible Solution\r\n\r\nThe customer has a very large AD and believes the problem is due to the FilterTable loading _all_ user data then filtering in memory.\r\nThe `guest_accounts` method makes use of FilterTable filtering when it could possibly use a faster explicit query for guest accounts.\r\n\r\nCurrent code:\r\n\r\n```\r\ndef guest_accounts\r\n    @guest_accounts ||= where(userType: 'Guest').mails\r\n  end\r\n```"},"comment":{"url":"https://api.github.com/repos/inspec/inspec-azure/issues/comments/535589559","html_url":"https://github.com/inspec/inspec-azure/issues/198#issuecomment-535589559","issue_url":"https://api.github.com/repos/inspec/inspec-azure/issues/198","id":535589559,"node_id":"MDEyOklzc3VlQ29tbWVudDUzNTU4OTU1OQ==","user":{"login":"trickyearlobe","id":3001322,"node_id":"MDQ6VXNlcjMwMDEzMjI=","avatar_url":"https://avatars2.githubusercontent.com/u/3001322?v=4","gravatar_id":"","url":"https://api.github.com/users/trickyearlobe","html_url":"https://github.com/trickyearlobe","followers_url":"https://api.github.com/users/trickyearlobe/followers","following_url":"https://api.github.com/users/trickyearlobe/following{/other_user}","gists_url":"https://api.github.com/users/trickyearlobe/gists{/gist_id}","starred_url":"https://api.github.com/users/trickyearlobe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/trickyearlobe/subscriptions","organizations_url":"https://api.github.com/users/trickyearlobe/orgs","repos_url":"https://api.github.com/users/trickyearlobe/repos","events_url":"https://api.github.com/users/trickyearlobe/events{/privacy}","received_events_url":"https://api.github.com/users/trickyearlobe/received_events","type":"User","site_admin":false},"created_at":"2019-09-26T16:46:45Z","updated_at":"2019-09-26T16:46:45Z","author_association":"NONE","body":"We have a separate repo we're sharing with UBS to track issues... I'll get some data in an issue there and link it (since we can't really give them access to raise issues on **this** repo.\r\n\r\nAnecdotally, the resource runs for several mins before barfing.\r\n"}}
{"actor":{"display_login":"trickyearlobe"}}