Report usage missing for deleted report objects. Version 11.1.1.3 Interavtive reporting
Sample SQL
SELECT AL3.NAME, AL3.EXPIRATION_DATE, AL3.CONTAINER_UUID, AL1.OBJECT_UUID, AL5.NAME, AL4.SEQUENCE_NUMBER, AL3.LAST_MODIFIED_DATE, AL3.CREATION_DATE, AL3.AUTO_DELETE, AL3.DELETED FROM HYPNPRPT.V8_USAGE_EVENT AL1, HYPNPRPT.V8_CONTAINER AL3, HYPNPRPT.V8_USAGE_ATTRIBUTES AL4, HYPNPRPT.V8_USAGE_EVENT_KEYVAL AL5 WHERE ( AL1.OBJECT_UUID = AL3.CONTAINER_UUID (+) AND AL1.EVENT_UUID=AL5.EVENT_UUID AND AL4.ATTRIBUTE_UUID=AL5.ATTRIBUTE_UUID) AND (((AL5.NAME='usageobjectpath' OR AL5.NAME IS NULL) AND AL1.STARTTIME BETWEEN {ts '2013-01-03 10:33:00.000'} AND {ts '2013-01-03 10:35:00.000'}))