Skip to Content
0
Sep 15, 2016 at 10:18 AM

Identify/Trace the user who deleted the Universe

483 Views

Hi Experts,


We are using BO 4.1(SP4 Patch 1); Someone from my team has deleted a universe and I want to identify who this user is. I have access to Query Builder tool (http://localhost:8080/AdminTools/querybuilder/ie.jsp) and tried the running the following query in there but always getting-FWB 00025-error (There was an error retrieving data from the server: Not a valid query): 😕


(I) SELECT A.EVENT_TYPE_ID,B.EVENT_ID, B.DETAIL_TEXT, A.USER_NAME,A.OBJECT_CUID,A.START_TIMESTAMP FROM AUDIT_EVENT A INNER JOIN AUDIT_DETAIL B ON A.EVENT_ID = B.EVENT_ID WHERE A.EVENT_TYPE_ID =65543 AND A.START_TIMESTAMP BETWEEN '2016-09-14' AND '2016-09-15' AND B.DETAIL_TEXT LIKE '%xxxx%';


(ii) SELECT * FROM AUDIT_EVENT WHERE EVENT_TYPE_ID =65543;




Can anyone help me with the right query to identify the user who deleted this universe? Thanks in advance for your ideas and suggestions.


Regards

Naveen Kumar