RE: Sql To Active Directory Quickie
From: mkdesigns2004 (mkdesigns2004_at_discussions.microsoft.com)
Date: 01/13/05
- Next message: galenboyerdev_at_hotpop.com: "Re: Normalization insanity"
- Previous message: Adam Machanic: "Error converting datatype varchar to datetime"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 Jan 2005 09:25:08 -0800
I have a similar question. I would like to use a stored procedure to get a
list of our groups and their members. I have been able to program the sp to
get the list of groups or get a list of users. However, i can not figure out
how to get a list of users and what groups they are a part of or get a list
of groups and who the members are. I was using the following code to pull the
list of groups:
SELECT * FROM OPENQUERY( ADSI,
'SELECT name
FROM ''LDAP://CN=Builtin,DC=domain name here, DC=com''
WHERE objectClass = ''group'' ')
I tried adding member to the select statement however i get the following
error: Could not convert the data value due to reasons other than sign
mismatch or overflow.
Is there a way to pull a list of groups and their memebers?
Thanks!
Meghann
"Jm" wrote:
> Hi all
>
> Im not sure if this is possible, but im sure ill get the answer here. In SQL
> Server is it possible to create a stored procedure that will take a username
> supplied by you and check the active directory account for that user and
> find what active directory groups the user is a member of, and in some way
> report back ? Any help is greatly appreciated
>
> Thanks
>
>
>
- Next message: galenboyerdev_at_hotpop.com: "Re: Normalization insanity"
- Previous message: Adam Machanic: "Error converting datatype varchar to datetime"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
