• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

Lawson ACTOR ID & LAWPROD10X & SSOP

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
ALW
Basic Member Send Private Message
Posts: 8
Basic Member
7/8/2019 2:24 PM
We are migrating to a new Domain and to Lawson 11. I need to create a SQL Script to list out all the Lawson Actor ID's and their corresponding LAWPROD10x and SSOP settings. Example: ACTORID = somones.name LAWPROD10x = domain\somones.name SSOP = someones.name@domain.net

I cannot find what table contains the LAWPROD10X and SSOP fields so I can list them.

Can anyone please help me identify the table(s) that these two fields exist in?

Thank you in advance.

Allen
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
7/8/2019 4:01 PM
If you want to pull it from Landmark then you could try using the IDENTITYACTOR table in your LTM Database. The identity for LAWPROD will most likely be the SID if you are a windows shop (Not sure about Unix). If you want to pull it from the LSF side then you could use ssoconfig to pull the data based on the service (SSOP,LAWPROD). It will output an xml file that you would probably have to parse to get just the id's for LAWPROD and SSOP. Good luck.