Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Disabled Users - SQL Table

 5 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
pops
Advanced Member
Posts: 46
Advanced Member
6/28/2016 3:59 PM

    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
    6/28/2016 5:22 PM
      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
      6/28/2016 5:59 PM
        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
        6/29/2016 3:23 PM
          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
          6/29/2016 3:41 PM
            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
            6/30/2016 9:37 AM
              You will need the Infor Process Designer for the version of Landmark that you are on.