Using Smart Notifications To Query LDAP

I was finally able to find a solution which I am sharing. On the infoset the quey would be

CN=* and then the next step or step 3 where you build the columns you would have to define the column to be each field that ldap displays. For eg we are using jexplorer to query LDAP so the column names would be the name of the field that jexplorer shows while querying LDAP.

You can get all the fields in the query by specifying ecah column name to be the field name that LDAP displays"

For eg the group name column in RM that the employee belongs to is zzlwsnattrGroup in jexplorer. This would be the name of the column in the infoset.

Could you elaborate a little bit more. I'm just starting with LDAP and I would love to know how the infoset gets set up and which values go into which boxes. Thanks a BUNCH!

Ruma,

Did you get what you needed. I can put together some screen shots for you. I also have a web-ex on this but it is 8 MB so I doubt it will make it out of our mail server. Let me know if you need this and I will send it offline.

I am uploading my screen shots that I used to query LDAP. The way I built the Search base is the way you would build a query for a single user in jexplorer.


However Mark I would like to see your screen shots to make sure if there is anything I missed. If you can send me the webex offline that would be great. thanks for all your help.

I am not able to upload a MS-word 7 document. When I try to attach it says file type is not allowed.

Zip it and upload the .zip =

I am zipping the file and uploading.

In addition to querying it using smart notifications on step 4 of the infoset we are checking the option that this is a large notification which then generates a table in the Lawson smart notifications schema and names the table the infoset id. I am writing a crystal report to go against this table to list all the different groups and roles a user belongs to. The Groups and roles are the ones defined for a user in RM and sec admin.

I am looking for a way to query LDAP that tells me which security profiles belong to a given group for a user.

I think I've got a Unix script that does very close to what you are looking for Ruma. Are you running Unix or Windows?

Unix AIX

This script will produce a web page containing all Roles and the users that belong to those roles. You could modify it to pull back other information as well. Note: I've put the areas that I know you will have to change in greater than and less than signs along with a description of what needs to be put there. ie.
<passwd>

Feel free to modify the script to your liking. I just ask that you leave me as the original author in the comments.

Hey, Ruma!! Thanks bunches for the screen shots!! I now have a working Infoset.
Now I just need to base some notifications off of it.

Thanks for the unix script. Will make sure that the original author does not change.