I have this SQL that me and our developers use on a daily basis to see
who has answered messages on our systems. What date/time, the actual message
and the response. It runs on 5250 or ACS SQL (my preferred method and is pretty
quick. It can be run for a single day or a range of days.
Perhaps it can be modified for the purpose you want. Not sure but thought I'd throw it out there.
It may be a starting point and if not, you have something to use as it is.
--- QSYSOPR System Messages ---
--- Who answered the message? ---
--- Columns prefixed with the "A" come from the error result, and those "B" from the reply result. ---
SELECT A.MESSAGE_TIMESTAMP AS "Date/Time of Error Msg",
A.MESSAGE_ID AS "Msg ID",
A.FROM_JOB AS "Job Generated Error Msg",
A.MESSAGE_TEXT AS "Msg Text",
B.MESSAGE_TIMESTAMP AS "Reply Date/Time",
SUBSTR(B.MESSAGE_TEXT, 1, 10) AS "Reply",
A.FROM_USER AS "Reply by"
FROM TABLE (QSYS2.MESSAGE_QUEUE_INFO(QUEUE_LIBRARY => 'QSYS',
QUEUE_NAME => 'QSYSOPR',
SEVERITY_FILTER => 99)) A,
LATERAL (SELECT MESSAGE_TIMESTAMP,
MESSAGE_TEXT, FROM_USER
FROM TABLE (QSYS2.MESSAGE_QUEUE_INFO(QUEUE_LIBRARY => 'QSYS',
QUEUE_NAME => 'QSYSOPR',
SEVERITY_FILTER => 99))
Respectfully,
Michael Mayer
IBM i on Power System Admin / VMO Specialist
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Cell, Office and Text Messages: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx
https://www.ermco-eci.com/
https://ermcopower.com/
IBM i Award Winning Personal Blog Site:
https://ibmireference.blogspot.com/
Awarded IBM 2024 Advocate, Contributor, Influencer and IBM i Ready Badges.
Today's Topics:
1. How to see who has signed onto an IBM i and what they are
doing afterwards? (Thomas Burrows)
2. Re: How to see who has signed onto an IBM i and what they are
doing afterwards? (James H. H. Lampert via MIDRANGE-L)
3. Re: How to see who has signed onto an IBM i and what they are
doing afterwards? (Thomas Burrows)
----------------------------------------------------------------------
message: 1
date: Fri, 13 Sep 2024 12:40:01 -0400
from: Thomas Burrows <thomas.burrows.1957@xxxxxxxxx>
subject: How to see who has signed onto an IBM i and what they are
doing afterwards?
Is there a way to see who has signed onto an IBM i and what they are doing afterwards?
Maybe some history files out there somewhere?
Thomas in Texas
------------------------------
message: 2
date: Fri, 13 Sep 2024 09:42:38 -0700
from: "James H. H. Lampert via MIDRANGE-L"
<midrange-l@xxxxxxxxxxxxxxxxxx>
subject: Re: How to see who has signed onto an IBM i and what they are
doing afterwards?
On 9/13/24 9:40 AM, Thomas Burrows wrote:
Is there a way to see who has signed onto an IBM i and what they are
doing afterwards?
Maybe some history files out there somewhere?
Maybe do a DSPLOG? That will at least tell you when jobs started and ended, and under what user.
--
JHHL
------------------------------
message: 3
date: Fri, 13 Sep 2024 12:44:32 -0400
from: Thomas Burrows <thomas.burrows.1957@xxxxxxxxx>
subject: Re: How to see who has signed onto an IBM i and what they are
doing afterwards?
Does not DSPLOG only show for the user that you are signed on as??
Thank you for the quick response.
On Fri, Sep 13, 2024 at 12:43?PM James H. H. Lampert via MIDRANGE-L < midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
On 9/13/24 9:40 AM, Thomas Burrows wrote:
Is there a way to see who has signed onto an IBM i and what they are
doing
afterwards?
Maybe some history files out there somewhere?
Maybe do a DSPLOG? That will at least tell you when jobs started and
ended, and under what user.
--
JHHL
--
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://list/
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C02%7Cmichae
l.mayer%40ermco-eci.com%7C8add4c0aea9a4b79316d08dcd41584ba%7Cd2deeaf27
0e4425c91d7d99d784e89d6%7C0%7C0%7C638618436104623535%7CUnknown%7CTWFpb
GZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0
%3D%7C0%7C%7C%7C&sdata=YgChCy%2Ft7a%2Bcb%2FBznxM1cAk5%2Ftz8zzBlEopKaY0
AdM8%3D&reserved=0 or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.
------------------------------
Subject: Digest Footer
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
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://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
------------------------------
End of MIDRANGE-L Digest, Vol 23, Issue 786
*******************************************
midrange.com
