Prev
Next
Forums Lawson S3 Financials

Lawson ACTOR ID & LAWPROD10X & SSOP

Sort:
You are not authorized to post a reply.
Author
Messages
ALW
Basic Member
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
    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.
      You are not authorized to post a reply.