Absent Member.. AlfredoMonasi Absent Member..
Absent Member..
434 views

Log when deleting Requests or Projects

Hi everyone,

There is a way how  can I audit when a user delete a request or project?

Regards,

Alfredo

0 Likes
4 Replies
Frequent Contributor.. hyllplan Frequent Contributor..
Frequent Contributor..

Re: Log when deleting Requests or Projects

My advice is to not give them delete, maybe cancel is enough?

0 Likes
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Log when deleting Requests or Projects

Sure, is better to have only cancel but in this case I would like to know which user delete a particular request.

0 Likes
Absent Member.. Mohit_Agrawal Absent Member..
Absent Member..

Re: Log when deleting Requests or Projects

I think we cannot audit a deleted requests or projects. When the workflow scope is set to "Requests" then you don't have the option to turn on Auditing.
Only packages have the audit feature.


Regards,
Mohit
0 Likes
Absent Member.. Mohit_Agrawal Absent Member..
Absent Member..

Re: Log when deleting Requests or Projects

Hi Alfredo,

 

There is one more way of tracking the deleted requests. You can create a custom trigger on KCRT_REQUESTS table and insert all the user and timestamp details in a newly created table USER_DELETED_REQUESTS.

 

 

CREATE [ OR REPLACE ] TRIGGER request_deletion BEFORE DELETE  ON KCRT_REQUESTS FOR EACH ROW
DECLARE
   -- variable declarations
BEGIN
Insert user details in the table USER_DELETED_REQUESTS.
EXCEPTION
   WHEN ...
   -- exception handling
END;

 

Hope it helps.

 

 

Regards,

Mohit

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.