{"id":517,"date":"2012-02-09T17:00:45","date_gmt":"2012-02-09T17:00:45","guid":{"rendered":"http:\/\/ec2-34-242-84-40.eu-west-1.compute.amazonaws.com\/?p=517"},"modified":"2012-02-09T17:00:45","modified_gmt":"2012-02-09T17:00:45","slug":"find-out-which-security-group-members-are-in-one-or-more-exchange-2010-databases","status":"publish","type":"post","link":"https:\/\/tomgeraghty.co.uk\/index.php\/find-out-which-security-group-members-are-in-one-or-more-exchange-2010-databases\/","title":{"rendered":"Find out which security group members are in one or more Exchange 2010 databases"},"content":{"rendered":"

First, run this command on a domain controller to extract the members of a security group:<\/p>\n

net group \"Security group name\" >c:\\groupmembership.csv<\/pre>\n
Then run this in an Exchange 2010 shell to extract the mailbox names from the database:<\/p>\n
Get-Recipient -PropertySet ConsoleLargeSet\u00a0 -ResultSize '9000' -SortBy DisplayName -RecipientType 'UserMailbox' -Filter '((Database -eq ''CN=DATABASENAME,CN=Databases,CN=Exchange Administrative Group (YOURADMINGROUP),CN=Administrative Groups,))' | Export-csv C:\\userslist.csv<\/pre>\n
Then paste\u00a0your names lists\u00a0into excel in two columns, one named group membership, and one database users. Use the below formula in the third column to find the names that occur in both columns of data.<\/p>\n
=VLOOKUP([first column entry,[Range E.G. A:A],1,FALSE)<\/pre>\n
 <\/p>\n
 <\/p>\n

\n\"\"<\/a>
\n<\/p>\n","protected":false},"excerpt":{"rendered":"
First, run this command on a domain controller to extract the members of a security group: net group “Security group name” >c:\\groupmembership.csv Then run this in an Exchange 2010 shell to extract the mailbox names from the database: Get-Recipient -PropertySet ConsoleLargeSet\u00a0 -ResultSize ‘9000’ -SortBy DisplayName -RecipientType ‘UserMailbox’ -Filter ‘((Database -eq ”CN=DATABASENAME,CN=Databases,CN=Exchange Administrative Group (YOURADMINGROUP),CN=Administrative Groups,))’ … <\/p>\n
Continue reading “Find out which security group members are in one or more Exchange 2010 databases”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,4],"tags":[22,28,29,41],"class_list":["post-517","post","type-post","status-publish","format-standard","hentry","category-blog","category-tech","tag-data","tag-excel","tag-exchange","tag-it"],"_links":{"self":[{"href":"https:\/\/tomgeraghty.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/517","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tomgeraghty.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tomgeraghty.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tomgeraghty.co.uk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tomgeraghty.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=517"}],"version-history":[{"count":0,"href":"https:\/\/tomgeraghty.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/517\/revisions"}],"wp:attachment":[{"href":"https:\/\/tomgeraghty.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tomgeraghty.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tomgeraghty.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}