This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I hate tables without timestamps. Rowstamps aren't reallly good enough for auditors. Luckily, I only need to get close enough to produce a list of people with changes to their permissions (in a gross sense, obviously):
SELECT * FROM groupuser WHERE LENGTH(rowstamp) = 10 AND rowstamp >
(SELECT MIN(rowstamp) FROM workorder WHERE TRUNC(changedate) = '02-JAN-2015')
ORDER BY rowstamp; -- group adds, changes
I guess if I was feeling really crazy I could look at which options were touched, but my gosh, why?!
-C