Question: How would I extract Active Directory info (Username, first name, surname) and populate an SQL table with the results?

Many thanks

Scott

Answer: 
If you're on .NET 3.5, I would use the new `System.DirectoryServices.AccountManagement` namespace for this.

Learn about it here:

[Managing Directory Security Principals in the .NET Framework 3.5](http://msdn.microsoft.com/en-us/magazine/cc135979.aspx)

Basically, you'd set up a container (a `PrincipalContext`) and then enumerate the users you want to deal with. Loop over those and extract the info you need, and feed that into SQL Server.
There are different ways to do that. I use PHP to get data out of our Active Directory.Take a look at the chapter "[Lightweight Directory Access Protocol](http://www.php.net/manual/en/book.ldap.php)" in the PHP Documentation. It's also easy to populate a database using PHP, e.g. [MySQL](http://www.php.net/manual/en/book.mysql.php) or [Microsoft SQL Server](http://www.php.net/manual/en/book.mssql.php).