Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Query MS ADAM

 2 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
mondrar
Advanced Member
Posts: 35
Advanced Member
2/25/2008 9:37 PM

    I would like to query MS ADAM and export a list of fields. I'd like to start with exporting the username and email address of all users. Can anyone give me a jumpstart here. I can query using the LDAP browser tool, JExplorer without any problems. I have seen some examples using an LDAP query in vbscript which outputs to a text file, but I am unsure how to get something like this done in MS ADAM.

    Any ideas would be greatly appreciated...

    ./Richard

    John Henley
    Posts: 3353
    2/25/2008 10:05 PM

      I ran into so many problems using JExplorer that I switched to this one: http://www-unix.mcs.anl.gov/~gawor/ldap/, which had no problems doing exports--but only to LDIF format.  One other option you might be able to get to work (I haven' t tried it) is to hook Crystal up to MS ADAM...I know you can hook it up to AD, but not to Tivoli Directory Server.

      Thanks for using the LawsonGuru.com forums!
      John
      rockie12_us
      Advanced Member
      Posts: 32
      Advanced Member
      7/15/2008 1:07 PM
        I have written serveral taylored queries against our Tivoli Directory Server and Adam is similar... the basis is an understanding of where your data is in the LDAP tree. That will be your root of your search. You can use the tool like JExplorer to get familiar with where the data you want is located... then you will want to pull back attributes for the most part of elements, like cn. These attributes usually begin with a prefix of zylwsnattr.... like zylwsnattrgroup for a group attribute

        I have written my code with Java. There is a nice book "Implementing LDAP" by Mark Wilcox which will show some examples of code for different searches you can do in an LDAP. The key is knowing where to search, the root DN to start in, makes all the difference.

        Dean-O