Disabled Users - SQL Table

Sort:
You are not authorized to post a reply.
Author
Messages
pops
Advanced Member
Posts: 46
Advanced Member

    I need to write a SQL query to identify Lawson users (actors) who have Is_Disabled set to yes.  What SQL Lawson 10 table contains the user information including the field Is_Disabled?

     

    Thank you in advance!

    Pops

    JimY
    Veteran Member
    Posts: 510
    Veteran Member
      For lsf they are in the LDAP not a table. If you have IPA you can use a resource query to get that information.
      pops
      Advanced Member
      Posts: 46
      Advanced Member
        I do have IPA. But I am new to it. How do I set up a query to do this?

        Thank you!
        JimY
        Veteran Member
        Posts: 510
        Veteran Member
          I have attached a simple resource query that will email you a list of employees where the isDisabled flag is set to YES.  I had to change it from a ".lpd" to ".txt" to attach it.
          Attachments
          pops
          Advanced Member
          Posts: 46
          Advanced Member
            Thank you! Is this for IPA? If so, how do I upload it to IPA.

            Thank you again!!
            Pops
            JimY
            Veteran Member
            Posts: 510
            Veteran Member
              You will need the Infor Process Designer for the version of Landmark that you are on.
              You are not authorized to post a reply.