Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Finding User vs "NT00000044" in DME Query

 4 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
jknox
Basic Member
Posts: 5
Basic Member
10/18/2010 7:54 PM
    Building a process flow similar to the flow in the tips and tricks section about sending an email about jobs that are in "Needs Recovery" status.
    First of all I can't get drill down in GEN from my API builder in PF (all I see is JO, LA, UN) but that isn't as big of deal (at the moment) because I can still pull data using the following query:

    \\PROD=GEN&FILE=QUEUEDJOB&FIELD=JOBNAME;USERNAME;STATUS;STOPDATE&SELECT=STATUS=34&OUT=CSV&DELIM=~

    Now, when I run this I am getting the username in the format "NT00000044" .. is there any way for me to convert this so I can know what user I am actually dealing with?

    Woozy
    Veteran Member
    Posts: 709
    Veteran Member
    10/19/2010 2:23 PM
      I can't tell what version you are on, or if you have ProcessFlow Integrator...

      If you're on LSF9 security, then you should be able to use a ResourceQuery node to query Security for the Name of the user.  If you need more data about the employee, pass in the productline and you can pull the COMPANY/EMPLOYEE from security, then turn around and query the EMPLOYEE table for whatever you need.
      Kelly Meade
      J. R. Simplot Company
      Boise, ID
      John Henley
      Posts: 3353
      10/21/2010 8:41 PM
        See this article, it shows how to go from a user id to an NT id:
        https://www.lawsonguru.co...tegration-Nodes.aspx
        You would need to do the opposite.
        Thanks for using the LawsonGuru.com forums!
        John
        jknox
        Basic Member
        Posts: 5
        Basic Member
        10/27/2010 7:08 PM
          That article looks very good my only problem is I can not seem to query using a Resource Query for some reason. Whenever I test it all I see is lines of ***** for my results. Any ideas on why this might be?

          For anyone interested, I ended up using a lid command to get the user from the listusermap file and using a data iterator and some JavaScript to get the portion of the line I needed.  It was pretty straightforward.
          JudeBac
          Veteran Member
          Posts: 129
          Veteran Member
          11/24/2010 1:18 PM
            I am successful using a Javascript as per the guru's article. I created a custom table and is populated twice a week through processflow by getting the UID identity via the ResourceQuery and converting it using a javascript.

            Regards,

            Judebac