<div>
Awesome ..Thank you so much rscottvan!
</div>


<div>
Hello All,<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;I would like sql server 2005 script to get Get a list of users in a Distribution group<br />
<br />
how would i do this?<br />
<br />
I followed <a href="http://blog.tech-cats.com/2007/09/querying-active-directory-through-sql.html" rel="ugc">http://blog.tech-cats.com/2007/09/querying-active-directory-through-sql.html</a><br />
<br />
but now I want users belonging to a security/distribution group<br />

</div>


Hello All,

       I would like sql server 2005 script to get Get a list of users in a Distribution group

how would i do this?

I followed http://blog.tech-cats.com/2007/09/querying-active-directory-through-sql.html [http://blog.tech-cats.com/2007/09/querying-active-directory-through-sql.html]

but now I want users belonging to a security/distribution group


<div>
<div class="content wysiwyg-content">
Hi All,<br />
&nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;I was able to pull the users from Active Directory into my sql server 2005 User table.<br />
I followed <a href="http://blog.tech-cats.com/2007/09/querying-active-directory-through-sql.html" rel="ugc">http://blog.tech-cats.com/2007/09/querying-active-directory-through-sql.html</a><br />
<br />
It successfully pulls user's generic information like &nbsp;givenName ,sn ,displayName, &nbsp;sAMAccountName,<br />
telephoneNumber ,mobile , mail ,department, &nbsp;physicalDeliveryOfficeName<wbr /><br />
<br />
The company I work for is distributed globally. Each country is located as a separate folder in active directory. When I pull user's into sql server table I would like to know which folder from active directory are they coming from in order for me to group users correctly based on country<br />
<br />
Please help!!!<br />

</div>
</div>


Hi All,
 
         I was able to pull the users from Active Directory into my sql server 2005 User table.
I followed http://blog.tech-cats.com/2007/09/querying-active-directory-through-sql.html

It successfully pulls user's generic information like  givenName ,sn ,displayName,  sAMAccountName,
telephoneNumber ,mobile , mail ,department,  physicalDeliveryOfficeName

The company I work for is distributed globally. Each country is located as a separate folder in active directory. When I pull user's into sql server table I would like to know which folder from active directory are they coming from in order for me to group users correctly based on country

Please help!!!


Sql server 2005 active directory users - distribution group

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.