I wasn't able to locate how to see the data from PMWORKGENERATION but a possible indirect way to see the information was by using this SQL:
SELECT
w.REPORTDATE,
w.REPORTEDBY,
w.WONUM,
w.DESCRIPTION,
w.WORKTYPE,
w.SITEID,
p.PERSONID,
p.DISPLAYNAME
FROM
workorder w
JOIN
person p
ON w.reportedby = p.personid
WHERE
w.istask = 0
AND w.reportdate BETWEEN DATE('2025-07-01') AND DATE('2025-07-31')
AND w.worktype = 'PM'
AND w.reportedby <> 'MAXADMIN';
This SQL could possibly be optimized for better speed but this is a possible solution in case any one has a similar need.
------------------------------
Danny Richardson
Maximo Administrator Manager
Technimark LLC
------------------------------
Original Message:
Sent: 07-30-2025 10:12
From: Danny Richardson
Subject: How to view PMWORKGENERATION in the database
Hello MORE Maximo community,
I would like to check who has been manually generating PMs because I am wanting to make a change to a Security Group.
I see that the name is PMWORKGENERATION but there is not a table or view that I see available in the database with that name.
Does anyone have any suggestions on how to see the information I need?
Thank you,
#Administration
#EndUser
#EverythingMaximo
#Security
#WorkManagement
------------------------------
Danny Richardson
Maximo Administrator Manager
Technimark LLC
------------------------------