Querying a user email address from the NT user ID

We recently migrated from AIX to Windows server. I have a flow that notifies the receiving clerk that an overshipment message (PO52) has been released. It queries the RM data to find the user's email address based on the user id that created the receiver. But now in Windows the user id is NTXXXX so the flow is failing to find this user in RM. Is there some place that ties the original user id with the NT user id and I can bring the original back into the flow?

downloadexport876_1 (2).zip

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

cleverly

There is a command line utility you can run, listusermap (in our environment it was installed in LSFgenin), which will list the NTxxxx user name along with the Windows account (domainuser). You could parse its output to come up with an email address (user@domain).

rmbell

We use a resource query to get to the employee, user info, and the email address. v_UID is the variable that holds the NTID. It won't come up in the builder, but it works for us. It looks like:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><TRANSACTION user="user@domain.com" method="getRMQuery"><SERVICE><![CDATA[LSENV]]></SERVICE><SERVICEATTRS><SERVICEATTR><NAME><![CDATA[UID]]></NAME><VALUE><![CDATA[<!v_UID>]]></VALUE></SERVICEATTR></SERVICEATTRS><OBJECT><![CDATA[People]]></OBJECT><ATTRIBUTES><ATTRIBUTE><![CDATA[ID]]></ATTRIBUTE><ATTRIBUTE><![CDATA[Email]]></ATTRIBUTE><ATTRIBUTE><![CDATA[Name]]></ATTRIBUTE></ATTRIBUTES><OUTPUTSERVICEATTRS><OUTPUTSERVICEATTR serviceName="dataarea_EMPLOYEE"><![CDATA[COMPANY]]></OUTPUTSERVICEATTR><OUTPUTSERVICEATTR serviceName="dataarea_EMPLOYEE"><![CDATA[EMPLOYEE]]></OUTPUTSERVICEATTR><OUTPUTSERVICEATTR serviceName="LSENV"><![CDATA[UID]]></OUTPUTSERVICEATTR></OUTPUTSERVICEATTRS></TRANSACTION>

Copyright © 2025 Infor. All rights reserved.