A new Flexera Community experience is coming on November 25th. Click here for more information.
Someone from our team has deleted one Purchase Order. Is there anyway to recover that PO and also want to know who has deleted it?
‎May 06, 2021 06:12 AM
Short answer: NO.
There is no trigger or audit trail on a delete event. For recovering the PO, you would have to restore a backup.
‎May 06, 2021 07:16 AM
If you are using FlexNet Manager Suite On-Premises then you may be able to find some information about the deleted PO record by querying the the CompilanceHistory view in the compliance database. This view contains one row for each tracked property value change. You may find rows recorded showing a non-NULL OldValue and a NULL NewValue that correspond to the deletion operation.
You will have to dig in to the data and work to identify a query with appropriate filtering to find exactly what you're looking for, but start with a query like the following and work from there based on what it shows:
SELECT TOP 1000 *
FROM dbo.ComplianceHistory
WHERE PurchaseOrderID IS NOT NULL
AND OldValue IS NOT NULL
AND NewValue IS NULL
ORDER BY ComplianceHistoryDate DESC
‎May 06, 2021 08:17 AM