Deleting License Transactions and Definitions

You may at some point need to truncate licensing data and license definitions. The SQL script below will truncate the data in the relevant tables.  N.B. Comment out the relevant lines in the script.  If you are unsure how to use this script please contact Certero support on helpdesk@certero.com

BEGIN TRAN

-- Delete Microsoft Licensing Data

DELETE FROM LicensingMicrosoft.MicrosoftTransaction

DELETE FROM LicensingMicrosoft.MicrosoftCategoryItemObject

DELETE FROM LicensingMicrosoft.MicrosoftEntitlement

DELETE FROM LicensingMicrosoft.MicrosoftLicenceMetric

-- Delete Adobe Licensing Data

DELETE FROM LicensingAdobe.AdobeTransaction

DELETE FROM LicensingAdobe.AdobeCategoryItemObject

DELETE FROM LicensingAdobe.AdobeEntitlement

DELETE FROM LicensingAdobe.AdobeLicenceMetric

-- Delete Generic Licensing Data

DELETE FROM LicensingCommon.LicenceTransaction

DELETE FROM LicensingCommon.LicenceCategoryItemObject

DELETE FROM LicensingCommon.LicenceAgreement

DELETE FROM LicensingCommon.LicenceSupplier

COMMIT