Audited Events for objects below specified folder

Eric_Mallo

We have an existing LR from our old LL 9.2 that displays any audited events that occur to objects in folders below a selected folder after an entered date.I need help in updating the SQL to make it work with 9.7.1. I read that there is a DAUDITNEW table which replaced the DAUDIT from older LL versions. SELECT DA.DNAME AS "Object Name", COUNT(DA.DNAME) AS "# of Audited Events" FROM DAUDIT DA WHERE DA.AUDITDATE >= %2 AND DA.DATAID IN (select dataid from dtree start with dataid = %1 connect by parentid = prior dataid) GROUP BY DA.DNAME

Appu_Nair

I looked at your query and I substituted this not sure if the event counts are right or not.Somebody more knowledgeable may chip in...SELECT DA.VALUEKEY AS "Object Name", COUNT(DA.VALUEKEY) AS "# of Audited Events" FROM DAUDITNEW DA WHERE DA.AUDITDATE >= %2 AND DA.DATAID IN (select dataid from dtree start with dataid = %1 connect by parentid = prior dataid) GROUP BY DA.VALUEKEY