Notifications
Clear all
Topic starter
i have the chart audit report, but it doesn't show detail (like removed/deleted a flag). Does anyone know of any other reporting mechanism to detail what user deleted a flag?
Posted : November 17, 2015 5:32 am
I run the below query against the database when I get asked about flags deletion.
select u.LOGINNAME as FromUser,
u1.LOGINNAME as ToUser,
f.DUE,
f.SUBJECT,
f.MESSAGE,
f.DELETED_DATE,
f.SENT
from FLAG f inner join USR u on u.PVID = f.FROMUSER
inner join USR u1 on u1.PVID = f.TOUSER
where u1.LOGINNAME = 'rcabello'
order by f.SENT desc
Posted : November 18, 2015 8:20 am
I know that this is a old response, I wanted to know if this report is being created in Crystal? If so what are the tables you used to create the report?
Thank you!
Posted : August 26, 2019 8:17 am
