![\"PS_Itteration01.png\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2014\/05\/PS_Itteration01.png\")
<\/a><\/p>\nAnd the results it returns when executed against my home laptop server.<\/p>\n
These results looked good and for a long time I was concerned with other parts of the script, for all intents and purposes quite happy that this was an accurate assessment of the server.<\/p>\n Let’s just review my logic for each step of the code at the top.<\/p>\n Lines 1 to 7 just set up our variables and write out the header message<\/p>\n Line 8 our first loop, to go through each login on the server<\/p>\n Line 10 an inner loop that will assess each role name that each login has been assigned<\/p>\n Line 11 a test to see if each role has the name ‘sysadmin’<\/p>\n Line 13 write out the login name with a bright format as it is a sysadmin login<\/p>\n Line 17 write out the login name with no formatting<\/p>\n It is quite possible that here someone with more PowerShell experience than me will be shouting at their screen pointing at the error I made but to me this made total sense.<\/p>\n Until I altered the code, I altered lines 6 and 7 of code above to be:<\/p>\n write-host “There are $c Logins on the server”<\/p>\n This changed my output to look like this:<\/p>\n This started alarm bells ringing – there are clearly not 13 logins listed<\/p>\n So, let’s see where things are going wrong, edit the script so it looks like this. I’ve highlighted the changes to make<\/p>\n Running this code shows me these results<\/p>\n Our $n variable should count up by one for each login returned and We are clearly missing some logins.<\/p>\n I referenced this list back to Management Studio for my server and see the Logins as below, where there are clearly 13 logins.<\/p>\n We see a Login called Annette in SSMS but not in the script results so I opened that up and looked at its properties and it’s server roles in particular.<\/p>\n The account has only public access to the server. Inspection of the other logins that the PowerShell script misses out show they too are only members of the public role.<\/p>\n Right now I can’t work out whether there is a good reason for this and if it should be expected behaviour or not. Please spend a few minutes to leave a comment if you have an opinion or theory for this.<\/p>\n How to get the full list of logins. Clearly I needed to get a full list of the logins so set about reviewing my code to see if there was a better way to iterate through the roles for each login.<\/p>\n This is the code that I came up with and I think it is doing everything that I need it to.<\/p>\n It gives me the expected results like this:<\/p>\n So it seems that the ListMembers() method is the trouble maker in my first versions of the code. I would have expected that ListMembers should return Logins that are only members of the public role, certainly Technet makes no reference to it being left out in it’s Login.ListMembers details<\/a>. Suffice to say, it’s a lesson learned and I will approach using it with caution in future circumstances.<\/p>\n","protected":false},"excerpt":{"rendered":" I’ve yet to have a totally smooth experience with PowerShell and it was late on Friday when I crashed into this problem. I haven’t investigated if this is a generally well understood circumstance and if it is then I apologise for repeating everything. Scenario: I wanted to scan a number of server for many properties,……<\/p>\n","protected":false},"author":101210,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[],"class_list":["post-6963","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/6963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/101210"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=6963"}],"version-history":[{"count":7,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/6963\/revisions"}],"predecessor-version":[{"id":42384,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/6963\/revisions\/42384"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=6963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=6963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=6963"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=6963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/a><\/p>\n$c = $Svr.Logins.Count<\/pre>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n