Re: User profile Personal Info

Simon Hutchinson wrote an article and has examples of SQL for retrieving this information, but it is not pretty...

https://www.rpgpgm.com/2022/07/access-system-directory-information-via.html
[https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEge_fBxij9JYoF12sNQZMAoKkam2sUpIjRJo-ykW56ZGrmVWOFVMxDB4XonHJLBgpjnG4ZmZUqHCgxjxNMnJPSlMGgBrJywZvKuMl0uDZq2AlCtgsPSL7crbc2lO9H8CDn_QNdoKG-kXkEwQXO4ultAptciYm2qU4NOx-SjDSLNQf0BWEsD35OfMiY2/w1200-h630-p-k-no-nu/sql.png]<https://www.rpgpgm.com/2022/07/access-system-directory-information-via.html>
Access System Directory information via SQL<https://www.rpgpgm.com/2022/07/access-system-directory-information-via.html>
Retrieving system directory information, directory entries, using SQL
www.rpgpgm.com



Regards,
Steve Landess
(512) 289-0387
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Justin Taylor <jtaylor.0ab@xxxxxxxxx>
Sent: Tuesday, March 5, 2024 13:37
To: MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: User profile Personal Info

Unfortunately not. I checked those first, but they're basically equivalent
to DSPUSRPRF.


date: Mon, 4 Mar 2024 14:42:14 -0500

from: Glenn Gundermann <glenn.gundermann@xxxxxxxxx>
subject: Re: User profile Personal Info

Hi Justin,

Take a look at these two statement to see if they give you what you need:

SELECT *
FROM USER_INFO;

SELECT *
FROM USER_INFO_BASIC;

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Cell: (416) 317-3144



On Mon, 4 Mar 2024 at 12:59, Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:

Is there a SQL service that will return personal info from a user profile
(e.g. SMTP name, department)?

TIA

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C02%7C%7C535a9d9df62d4bfb6bb408dc3d4bc0e5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638452642778811787%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=tXx12oItbsxhc4bCVHxYB3xJ4Qn6T%2Be2aew5VaP%2BgO0%3D&reserved=0<https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=05%7C02%7C%7C535a9d9df62d4bfb6bb408dc3d4bc0e5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638452642778820281%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=2f%2BRWS58HLRJEvatl1qCYsg%2B5kwLIu2%2FHun5b94aG8s%3D&reserved=0<https://archive.midrange.com/midrange-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.