Qdabra Active Directory Web Service

Find User Capability

BejeweledOne — Thu, 21 May 2015 14:35:53 GMT

I love the capability to use the FindUserbyAlias and FindUserByName. We use these to find user names with duplicate base names. I need the same capability for email. Is there a way in the QdabraAD tool to return an email address or multiple email addresses that contain the same base names as the comparison value?

Find Users By Alias

BejeweledOne — Tue, 12 May 2015 15:59:17 GMT

This is certainly a very nifty little tool. I have a form that our users will use when requesting a name change. Via rules the final name, email address and login name are set based on the information provided. We have many employees who would have duplicate login names if we didn't add numbers afterwords. I would like to be able to take this information and use it to generate a new logon name that is correctly numbered if necessary, but am not quite sure how to do this.

findusersbyalias might return something like this:]

juser

juser1

juser2 and so on, even into double digits, juser10. I need capture the numbers at the end of the login names returned by the finduserbyalias and get the one with the highest number or find a way to have it only return the highest numbered one. Once I can identify this one it's very simple to just add 1 to that to get the next number in the sequence.

Any ideas would be greatly appreciated.

GetUserInfo

BejeweledOne — Fri, 07 Jun 2013 17:29:08 GMT

I saw an earlier post (2006) where someone made the suggestion to allow other input methods in addition to username. The answer was we will consider it. I was hoping to find that you had configured it to take an email address since they are unique in addition to username. Is this still limited to username only for the input?

Query Mulitple Domains

mfrey — Tue, 06 May 2014 21:14:02 GMT

We have Qdabra AD installed and it works great with our main domain. We recently added a second trusted domain to our AD environment. The SharePoint server on which the service is installed on has the ability to query the second domain. Is it possible to have the AD service query both domains? My tests do not seem to return results when attempting to query users from the second domain, full results are returned when passing users from the first domain.

Thanks!

Qdabra AD with SharePoint 2013

BejeweledOne — Tue, 01 Apr 2014 14:18:34 GMT

We are in the process of migrating to SharePoint 2013. We have setup an interim server where we are testing everything to make sure we work out all the bugs prior to the migration going live. We have Qdabraad installed and it works on our forms in preview mode. When we publish the form (this is a list form edited in InfoPath), it is not pulling any data.

We tested with .net directly to the qdabraad installation and are able to pull the data fine. It seems that it's just from this sp2013 site that we are having issues.
There are no errors either in the event viewer or the log. What else can I look at to see what the issue might be?

GetUserInfo NOT getting all info requested

BejeweledOne — Thu, 09 Jan 2014 19:13:01 GMT

Having an odd issue using the getuserinfo method. I have a button that pulls employee info from the 'GetUserInfo' data connection of the Qdabraad webservice. I am successfully pulling the sAMAccountName and populating it into a text field.

I am trying to pull these additional pieces of information and populate them into their own text fields but nothing is happening. I do not get an error nor do I get data. I am testing with users that I know have that information populated in AD.

physicalDeliveryOfficeName
countryCode

On the button click the rule sets the 'getuserinfo' query username to their user logon name (firstinitiallastname). It then sets the field values for 'sAMAccountName', 'physicalDeliveryOfficeName' and 'countryCode'. The sAMAccountName is populating in it's field but the other information is not.

Any help will be greatly appreciated.

Retreive nested groups

Marzipan — Tue, 05 Nov 2013 13:30:28 GMT

When you get members of a group you can flag the query to retrieve nested members, i.e. members of groups nested in the group you are expanding. Is there a way to return the groups themselves, i.e. w/o members. Is there a way to identify at what level the nested group exist or it's parent group?

Not able to pull in other keys with GetMyInfo

ospmatt — Tue, 13 Aug 2013 17:27:05 GMT

I'd like to populate a form with the requestor info including phone, email, and title/department. I have been able to successfully get it to pull in the Display Name value, but when I drag the key field on to my form and preview to see what keys are available I only have a very short list, not all of the active directory attributes. I've only got objetcClass, cn, sn, givenName, distinguishedName, memberOf, name, sAMAccountName, userPrincipalName,objectCategory , and msDS-AuthenticatedAtDC. Nothing for phones, department, employee ID, email. Also, another thing that I've noticed is that pulling in the getallusers to populate a drop down box with all of our employees doesn't pull in the entire list, only the first 50 or so. I tried setting the limit criteria to a large number and it didn't seem to make a difference. How should I fix this?

AD GetMembersOfGroup Error.

drewified — Thu, 08 Dec 2011 19:21:27 GMT

This should be simple enough. Unfortuntely I am getting the following error when I attempt to follow the tutorial for GetMembersOfGroup:

The query cannot be run for the following DataObject: GetMembersOfGroup
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred:

Server was unable to read request. ---> There is an error in XML document (1, 457). ---> Input string was not in a correct format.

New Proj will Qrules help?

Chris Rojek — Mon, 10 Dec 2012 14:22:34 GMT

I want to pull a record set of AD users filtered by supervisor.

Then I want to set the filter record set as a master detail.

Sort of like

Master Record Set.

user 1
user 2
user 3

________________

Detail for user 2

user is on time? true false

user is a good teammate? 1 2 3 4 5

user plays well in sand box. 1 2 3 4 5

_______________________________________

The master is the users AD record.

The detail is values set for each master record in the form.

Please respond if qrules will help, if so, I will purchase QRULES. Which one would you suggest to purchase for this project.

Thanks in advance.

Chris

GetMyInfo Keys

smonczka — Wed, 21 Nov 2012 19:51:14 GMT

Could someone please direct me to a complete list of the keys available when using the GetMyInfo method? I'm trying to figure out the key for Department and Manager are.

And yes I did try department and manager. :)

Difficulty installing ADWS

Deeayrian — Wed, 10 Oct 2012 12:19:21 GMT

Originally when I installed ADWS on my Sharepoint Server I had DefaultAppPool chosen and the account because I overlooked the step in the instructions that told me to change it to the Classic.NET AppPool. When I tried to create a data connection on my form to the ADWS, it would give me an error and say I didn't have the permissions to do so. So, I removed ADWS from the server and installed it again selecting the Classic.NET AppPool and now I can't even pull up the list of available methods. I get the error shown in my attachment. I tried to uninstall it a 2nd time and install it again using the Default AppPool but I am getting the same error when it pulls up the available methods page.

How to use GetAllUsers (Qdabra)

kizzie37 — Tue, 04 Sep 2012 16:24:03 GMT

I am trying to use the "GetAllUsers" function, but not understanding how to filter out what is not required, I have hooked up the connection and am trying to filter on OU, but it seems to only give the first 100 names (alphabetically) regardless of the filter I put in. For instance its giving me names of people who are no longer active etc. I have the active OU group names, I just cant work out how to filter out what i need. Can anyone help?.

Not retrieving Use Information

ek38 — Mon, 23 Apr 2012 20:03:02 GMT

We have GetMyUserInfo installed on server "X". Server "X" was the DC. We retired the server as a DC, but left the webservice running.

None of our forms that use the GetMyINfo webservice to pull the current users name are working.

If the DC is no on another server, do we need to change something in the configuration? We did move it to a Windows 2008 Server. Not sure if that could be the problem as well.

Job Title

smonczka — Thu, 19 Apr 2012 16:53:18 GMT

Using Qdabra Active Directory Web Service how do i pull "my" Job Title into a form. Using ADUserInfo and GetUserInfo I see no AD field for Job Title, but it's in AD so am I looking in the wrong place?

AD Service: How-To Set Field to GetMyInfo Result

Patrick Halstead — Tue, 13 Sep 2005 20:32:27 GMT

PROBLEM:

You have installed the AD Web Service and would like to set a value in your form to equal a value returned by the Web service, specifically, you'd like to pre-populate the user name or user info.

SOLUTION:

(In the InfoPath Designer )
After you add a data connection for the GetMyInfo method of the AD Web Service and specify to retrieve data on load of the form... take the following steps to set the data:

1. Double click on the field in the view that you want to set
2. In the Default Value section, click on the fx button to the left.
3. Click Insert Field or Group
4. Select the Get My Info (Secondary) data source from the dropdown
5. Expand dataFields->tns:GetMyInfoResponse->GetMyInfoResult->ADProp
6. Select Value
7. Click Filter Value
8. Click Add
9. Select Key in the first drop down
10. Leave the second dropdown as "is equal to"
11. In the third dropdown, type text "sAMAccountName" (or whatever key you want to set) without the double quotes. Notice that InfoPath adds double quotes after you type and tab out.
12. Click OK 5 times to close the dialogs
13. Preview your form

Voila!

Patrick Halstead [InfoPath MVP]
InfoPathDev

Qdabra Active Directory Web Service is unavailable.

drewified — Tue, 17 Apr 2012 17:17:39 GMT

Hi Guys,

This morning something odd happened - the AD Web Service stopped working - when I got to the AdUserInfo.asmx page I get the following error message:

Server Error in '/QdabraAD' Application.

Runtime Error

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="Off"/>
    </system.web>
</configuration>

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
    </system.web>
</configuration>

Naturally, forms that are using this service are unable to open correctly because queries cannot execute. Please let me know what I can do to fix! Thank you.

Get Other User profile by registration number

wissems — Fri, 16 Mar 2012 14:26:05 GMT

Hi, i have an infopath 2010 form who contain three field : full name ,Service and registration number , these information are avalaible in sharepoint 2010 group. I would get the full name and Service by entering the registration number of employer. I tried it with drop down list but it's not comfortable (that what i tried http://www.youtube.com/watch?v=mATsK0aVZ9I) thank you ahead

Can I do this with ADWS?

justinr — Fri, 24 Feb 2012 21:58:17 GMT

I've used my GoogleFu, searched around InfopathDev.com, and looked through the ADWS documentation, but was unable to find what I needed, so here goes my first post on the site :)

I'd like to populate a dropdown with all users that are listed as a Manager in AD, filtered by department selection/input. I imagine the process going something like this:

Drop-down list populated with Departments of the AD users in a specific OU

I choose a department

Department is set as input for another query

2nd drop-down list is populated with all users in that department, where the Manager AD field = their name

I think it can be done, I'm just not sure how to go about using the ADWS, UserProfileService, or a combination of both to create this functionality for the form. Can a set of queries be constructed to do this? Thanks for any help in advance :)

Set Submitter Group Membership

kizzie37 — Mon, 20 Feb 2012 16:29:59 GMT

We are using Qdabra AD web service. I can easily get the groups for the current logged in user, and can even fix the name of the submitter and the submitters manager. I now want to know how to set the submitters group memberships using the same service.

GetMembersOfGroup dropdown

smonczka — Tue, 22 Nov 2011 15:47:52 GMT

Is it posible to use GetMembersOfGroup to populate a dropdown and if so how?

Thanks,

Steve

Installing Qdabra ADWS

smonczka — Tue, 10 May 2011 19:24:34 GMT

Big Time Noob Question....

I just purchased ADWS and I'm trying find documentation on installing it. Can someone tell me where that might be?

thanks,

ADWS Standalone Installation

bCloud09c — Tue, 20 Dec 2011 14:23:57 GMT

I have a SharePoint 2010 farm set up with 1 WFE, 1 APP, and 1 DB server. Which server do I install the standalone ADWS on?

Thanks,
Brandon Copeland

Using AD groups for form user roles

ZhenYuan — Wed, 23 Nov 2011 11:14:54 GMT

Hi,

We have been using AD groups to determine a user's user role for our forms. However, for some users, despite belonging to the right AD group, their group membership is not detected and thus they are not recognized via the form's user role.

Is there a limit to the no. of levels for a nested AD group to be recognized? i.e, Main group -> sub group A -> sub group B -> sub group C. Can a user in sub group C be recognized if I configure my form to recognized people in the main group as "super users"? Right now, what is happening is that users in sub group C are not recognized as "super users".

Thanks,

Zhen Yuan, Ang

Unable to retrieve getmyinfo data from AD

aguerrero — Thu, 10 Nov 2011 17:59:32 GMT

I followed the example in your getting started guide for the expense report form and it works fine with infopath preview.

However, when I publish it to sharepoint and view it in a web browser it is not able to retrive the getmyinfo data from AD.

Here's the error that I get from sharepoint:

"You do not have permissions to access a Web service that provides data required for this form to function correctly. An entry has been added to the Windows event log of the server. Log ID:5566"

The windows event log shows this:

"You do not have permissions to access a Web service that provides data required for this form to function correctly.
The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

I get the same error if I try submitting the data.

Here's some other related information:

I have Qdabra installed with https enabled and alternate access mappings configured. The certificate uses an FQDN and I'm not sure if this might be related, but when I go to https://servername:1234 it shows a certificate mismatch error. However, I'm not using that address in any of my configurations that I am aware of. I made sure that the data connections all point to https://FQDN:1234