• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.