Accessing AD data from user name using codeless solution

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ianb - 14 Nov 2007 20:50 GMT

Hi

I have a form that refers to users (other than the current user) and I want
to validate them and access their Active Directory data. I have played with
the method outline in the first part of wkriebel's blog:
http://weblogs.asp.net/wkriebel/archive/2005/01/24/359669.aspx
This involves setting the query value field in the GetUserProfileByName
webservice (supplied with MOSS) to the user Name and interrogating the
results.

From analysis I know the query field is being updated but for some reason
the query doesn't seem to be firing as the results are not updated.

Can anyone help with this - I have trolled the Internet without success

Note that I am using MOSS and Infopath 2003 SP2 (which seems to be supplied
with MOSS). Any solution has to be codeless

Thanks

Ian B

Reply to this Message

Clay Fox - 14 Nov 2007 20:55 GMT

Hey Ian.

Have you looked at the AD webservice included with the Database Accelerator
at http://www.qdabra.com?
It is codeless and can do a lookup and return all of the data on a
particular user, return the current user's domain account(not just the local
account which can be different in a VPN or RAS scenario), and verify a user's
group membership.

I use that so I am not real familiar with the MOSS version.

Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

> Hi
>
[quoted text clipped - 17 lines]
>
> Ian B

Reply to this Message

Ianb - 14 Nov 2007 21:06 GMT

Thanks Clay

I just need something to tidy up a process - theres no will to buy a
solution. There are some web services around on the net that provide some of
the funtionality but I am trying to work under the IT radar. From what I have
seen I should be able to do this relatively simply using inbuilt Infopath
functionality. I'm just missing that vital piece of the jigsaw

Ian

> Hey Ian.
>
[quoted text clipped - 28 lines]
> >
> > Ian B

Reply to this Message

S.Y.M. Wong-A-Ton - 16 Nov 2007 06:32 GMT

I'm unfamiliar with the solution, but have you added a rule somewhere (such
as on a button) with an Action to "Query using a data connection" and
selected the "GetUserProfileByName" data connection? You need to query the
data connection after you've set the value for the username, otherwise no
data will be returned.
---
S.Y.M. Wong-A-Ton

> Hi
>
[quoted text clipped - 17 lines]
>
> Ian B

Reply to this Message

Ianb - 19 Nov 2007 03:31 GMT

Thanks Wong-A-Ton

The information you provided worked and the codeless updating of user
details is functioning from the user account name which is a great step
forward.

Is there a web sevice (or some other way) that will support a query on Full
Name and either return account name or other profile details?

Thanks

Ian

> I'm unfamiliar with the solution, but have you added a rule somewhere (such
> as on a button) with an Action to "Query using a data connection" and
[quoted text clipped - 25 lines]
> >
> > Ian B

Reply to this Message

S.Y.M. Wong-A-Ton - 20 Nov 2007 00:44 GMT

I don't know of any, but I'm sure you could write a custom web service to
retrieve that kind of information. It might be worth posting your question in
one of the SharePoint groups?
---
S.Y.M. Wong-A-Ton

> Thanks Wong-A-Ton
>
[quoted text clipped - 38 lines]
> > >
> > > Ian B

Reply to this Message