{"action":"opened","issue":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/5076","repository_url":"https://api.github.com/repos/sqlcollaborative/dbatools","labels_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/5076/labels{/name}","comments_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/5076/comments","events_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/5076/events","html_url":"https://github.com/sqlcollaborative/dbatools/issues/5076","id":408950203,"node_id":"MDU6SXNzdWU0MDg5NTAyMDM=","number":5076,"title":"Unable to fetch User Permissions from AzureSQL","user":{"login":"Ayanmullick","id":17693249,"node_id":"MDQ6VXNlcjE3NjkzMjQ5","avatar_url":"https://avatars1.githubusercontent.com/u/17693249?v=4","gravatar_id":"","url":"https://api.github.com/users/Ayanmullick","html_url":"https://github.com/Ayanmullick","followers_url":"https://api.github.com/users/Ayanmullick/followers","following_url":"https://api.github.com/users/Ayanmullick/following{/other_user}","gists_url":"https://api.github.com/users/Ayanmullick/gists{/gist_id}","starred_url":"https://api.github.com/users/Ayanmullick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ayanmullick/subscriptions","organizations_url":"https://api.github.com/users/Ayanmullick/orgs","repos_url":"https://api.github.com/users/Ayanmullick/repos","events_url":"https://api.github.com/users/Ayanmullick/events{/privacy}","received_events_url":"https://api.github.com/users/Ayanmullick/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2019-02-11T19:57:25Z","updated_at":"2019-02-11T19:57:25Z","closed_at":null,"author_association":"NONE","body":"### Before submitting a bug report:\r\n\r\n- [x] Ensure you are able to reproduce it on the latest released version (_we release often_)\r\n- [x] Verified this bug is not already reported in an issue\r\n- [x] Verified errors are not related to permissions\r\n- [x] Can reproduce in a clean PowerShell session (_clean = `powershell -NoProfile`_)\r\n\r\n## Steps to Reproduce\r\n\r\n```powershell\r\nGet-DbaUserPermission -SqlInstance 'tcp:<AzSQL ServerName>.database.windows.net,1433' -Database <AzSQLdbName> -SqlCredential <SQLadmin> -Verbose|ft\r\n```\r\n\r\n## Expected Behavior\r\n| ComputerName| InstanceName| SqlInstance|Object|Type|Member|RoleSecurableClass|\r\n| ----------------- |:----------------:| -----------:|-------:|-----:|--------:|---------------------:|\r\n| ServerName | MSSQLSERVER |ServerName|SERVER|SERVER LOGINS|CORP\\<Group>|None|\r\n| ServerName | MSSQLSERVER |ServerName|SERVER|SERVER LOGINS|CORP\\<Group>|None|\r\n| ServerName | MSSQLSERVER |ServerName|SERVER|SERVER LOGINS|CORP\\<Group>|None|\r\n\r\n\r\n## Actual Behavior\r\n\r\n```\r\nVERBOSE: [19:13:53][Get-DbaUserPermission] Processing [<>] on TCP:<>.database.windows.net,1433\r\nVERBOSE: [19:13:53][Get-DbaUserPermission] Creating objects\r\nVERBOSE: [19:13:53][Get-DbaUserPermission] Building data table for server objects\r\nVERBOSE: [19:13:53][Get-DbaUserPermission] Building data table for [<>] objects\r\nVERBOSE: [19:13:53][Get-DbaUserPermission] Deleting objects\r\n```\r\n\r\n## Environmental data\r\n\r\n<!-- Provide output of the following two commands -->\r\n\r\n - PowerShell: \r\n\r\n|Name|Value|                                                                                                                                                                      \r\n|-------|:----:|  \r\n|PSVersion          |            5.1.14393.2636    |                                                                                                                                                            \r\n|PSEdition           |           Desktop             |                                                                                                                                                          \r\n|PSCompatibleVersions   |        {1.0, 2.0, 3.0, 4.0...}        |                                                                                                                                               \r\n|BuildVersion      |             10.0.14393.2636         |                                                                                                                                                      \r\n|CLRVersion          |           4.0.30319.42000         |                                                                                                                                                      \r\n|WSManStackVersion      |        3.0                       |                                                                                                                                                    \r\n|PSRemotingProtocolVersion    |  2.3                  |                                                                                                                                                         \r\n|SerializationVersion        |   1.1.0.1     |\r\n\r\n- SQL Server: Microsoft SQL Azure (RTM) - 12.0.2000.8   Dec 19 2018 08:43:17   Copyright (C) 2018 Microsoft Corporation \r\n"}}
{"actor":{"display_login":"Ayanmullick"}}