• Search Forums
    Advanced Search Topics Posts
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: 3362
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