You are viewing limited content. For full access, please sign in.

Question

Question

Find deleted instances in Forms 10.4

Forms Version 10
Updated October 28, 2020
asked on October 26, 2020

I am looking for a way to find any deleted instances in Forms 10.4. I really just want some kind of auditing if an instance was deleted. So far, I don't see a way to find that.

I found a refernce to this SQL command,
SELECT * FROM [dbo].[cf_bp_main_instances] where status=99

I don't find anything with that status in SQL. 
 

0 0

Replies

replied on October 26, 2020

The instance data will be removed from the database when delete instance in Forms 10.4 to reduce the size of database. You want to audit who delete a instance or whether a instance is deleted? If you just want to tell whether a instance is deleted, you can tell from the bp_instance_id, the IDs are unique, so if a number is smaller than the current biggest one in the cf_bp_main_instances table, that means that instance was deleted already.

0 0
replied on October 27, 2020

I was kind of hoping to be able to audit who deleted it. We only have a few people with access, and this was the first instance that was stopped and deleted that shouldn't have been, but it'd be nice to know. 

0 0
replied on October 28, 2020

Forms doesn't have audit log for who deleted the instance. What you may refer to is check the IIS requests log under C:\inetpub\logs\LogFiles\W3SVC1. You can search for "DeleteProcessInstance" this keyword to find logs as following(the bold part is the user who did that action)

  /Forms/webapi/v1/instance/DeleteProcessInstance - 80 forms

But this request can only tell who did the delete instance action and won't tell which instance is deleted.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...