Who's On?

	Membership:
	Latest: BDell92
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5275

	People Online:
	Visitors: 540
	Members: 0
	Total: 540

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

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 Send Private Message

Posts: 5

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 Send Private Message

Posts: 709

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.

John Henley

Posts: 3351

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.

jknox

Basic Member Send Private Message

Posts: 5

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 Send Private Message

Posts: 129

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