Clovertech

Can Cloverleaf query Active Directory for additional data?

› Clovertech Forums › Cloverleaf › Can Cloverleaf query Active Directory for additional data?

Tagged: 

  • Creator
    Topic
  • August 19, 2024 at 9:27 am #121560
    Joseph Bernard
    Participant

      Hi,

      Does anyone know if Cloverleaf can query Active directory to pull in additional information?  If so, how would I do that.  We’re trying to create a Cloverleaf table based on Active Directory data that we can’t get through the interface.

      Thank,

      Joseph

    • Creator
      Topic
    Viewing 4 reply threads
    • Author
      Replies
      • August 19, 2024 at 9:50 am #121561
        Jim Kosloskey
        Participant

          This link might be a start:

          https://wiki.tcl-lang.org/page/Active+Directory

          email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

        • August 19, 2024 at 10:27 am #121563
          Peter Heggie
          Participant

            #following

            Peter Heggie

          • August 19, 2024 at 11:41 am #121564
            David Barr
            Participant

              You can use the ldapsearch command on Red Hat. You may need to install the openldap-clients package. You would have to call the command through a script (TPS or XLTP).

            • August 20, 2024 at 4:24 am #121565
              Jim Vilbrandt
              Participant

                We have a system that exports personnel events to a CSV file. This file is then processed through a Windows Task and PowerShell. Each the personnel data in CSV is then augmented with information from Active Directory before it is written to a second CSV. This second CSV is then sent to various systems by Cloverleaf in the format they are expecting. This would be an easy work-around if you can’t get the TCL/AD connection to work.

              • September 5, 2024 at 6:13 pm #121585
                Rob Lindsey
                Participant

                  We have developed some web pages that use LDAP for checking to see if someone belongs to a group and we use TCL.
                  <pre>package require ldap
                  # Connect, bind, add a new object, modify it in various ways
                  set handle [ldap::connect <ldap server> <ldap port number>]
                  set x [ldap::search $handle “<breakdown>” “(userPrincipalName=$username)” {memberOf} ]
                  ldap::unbind $handle
                  ldap::disconnect $handle</pre>
                  The above code is very abbreviated but might give you some ideas.

              • Author
                Replies
              Viewing 4 reply threads
              • You must be logged in to reply to this topic.