![\"Script](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/ad.jpg\" "\\"Script")
<\/a><\/p>\nHey, BG. As you probably already figured out, you have two issues: you need to get a list of all the users in an OU, and then you need to figure out which Exchange server they\u2019ve been assigned. Believe it or not, this is probably one of the easiest scripts you\u2019ll ever have to write. <\/p>\n
Well, OK, that we\u2019ll ever have to write for<\/i> you \u2026.<\/p>\n
Let\u2019s start by getting a list of all the users in an OU. There really isn\u2019t much to say about that; all you have to do is bind to the OU and you automatically get back a collection of all the objects in that OU. Thus if we want to get a collection of all the objects found in the Finance OU (and echo back the object\u2019s common name, or CN), we can use this code:<\/p>\n
Set objOU = GetObject(\"LDAP:\/\/OU=Finance,DC=fabrikam,DC=com\")\nobjOU.Filter = Array(\"user\")\nFor Each objItem in objOU\n Wscript.Echo objItem.CN\nNext\n<\/pre>\nNotice the one little \u201ctrick\u201d we did here. We set a filter on the collection using this line of code:<\/p>\n
objOU.Filter = Array(\"user\")\n<\/pre>\nThis tells our script, hey, filter out everything in the collection except<\/i> user accounts. Why do we do that? Well, suppose you have computer accounts or print queues or other objects in the OU. We don\u2019t want to try to determine the Exchange server for a bunch of print queues, so we use the filter to weed out everything except user accounts.<\/p>\n
And now comes the \u201chard\u201d part: retrieving each user\u2019s Exchange server. Of course, that\u2019s hard only if you don\u2019t know that the name of the attribute. But seeing as how you are told us the attribute you\u2019re looking for is msExchHomeServerName, well:<\/p>\n
Set objOU = GetObject(\"LDAP:\/\/OU=Finance,DC=fabrikam,DC=com\")\nobjOU.Filter = Array(\"user\")\nFor Each objItem in objOU\n Wscript.Echo objItem.CN\n Wscript.Echo objItem.msExchHomeServerName\nNext\n<\/pre>\nAnd just for the heck of it, here are a few more Exchange-related properties you might want to grab while you\u2019re at it:<\/p>\n
Set objOU = GetObject(\"LDAP:\/\/OU=Finance,DC=fabrikam,DC=com\")\nobjOU.Filter = Array(\"user\")\nFor Each objItem in objOU\n Wscript.Echo objItem.CN\n Wscript.Echo objItem.mailNickname\n Wscript.Echo objItem.msExchHomeServerName\n Wscript.Echo objItem.homeMDB\n Wscript.Echo objItem.mdbUseDefaults\nNext\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Hey, Scripting Guy! How do I get a list of the Exchange servers (msExchHomeServerName) assigned to the users in an OU? — BG Hey, BG. As you probably already figured out, you have two issues: you need to get a list of all the users in an OU, and then you need to figure out […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[7,27,28,29,3,5],"class_list":["post-71363","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-active-directory","tag-exchange","tag-messaging-and-communication","tag-microsoft-exchange-2003","tag-scripting-guy","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How do I get a list of the Exchange servers (msExchHomeServerName) assigned to the users in an OU? — BG Hey, BG. As you probably already figured out, you have two issues: you need to get a list of all the users in an OU, and then you need to figure out […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/71363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=71363"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/71363\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=71363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=71363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=71363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
<\/p>\n![\"Spacer\"](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\")
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")