Post reply

Query AD

  • April 8, 2011 at 5:14 pm

    #147779

    I'm a dba and in our enviroment the networkside don't install administrative tools on our computers.

    But sometimes I do need to check in AD, for example to see which people are in _DBA group, and which are in a Proj_developers group. Is there an easy way to do that, I can query the AD, I think.

    All I can do now is I can use net group /domain group_name, to see who is in the group, but sometimes there is a space in the group name, and I don't know what is the syntax, this makes my work hard.

    Any easier way to do this? and what is the mostly used to check group, member of group etc.

    Thanks

    --------------------------------------------------------------------------------

    SQLFriend

  • April 9, 2011 at 8:03 am

    #1309539

    In order to query groups, I think you will need to 1) Write .net code in the CLR to query AD using ADSI or 2) use the command line query tools to redirect to text files and then import into SQL Server. The problem is that AD groups are nested / multi valued and the OLEDB driver for ADSI can't handle that.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply