RVY200847: Deleting unwanted usage metering data from the RayVentory database

Background

An unwanted or incorrect configuration of the Software Metering Agent (part of RayVentory Inventory Agent RVIA) may result in unwanted or unneeded software usage data.

Solution
To remove metering information from the RayVentory database, run the attached MS SQL script ("Delete-Usage-Data.sql").

How to prepare the script

Enter the full file name in variable @Filename.

For example, if you want to remove usage data gathered for application Microsoft Word, you need to set the @Filename variable to "winword.exe".

How it works

- The script checks if the filename is present in the usage data
- The script reports and logs every step
- Nothing will be deleted, if no usage data is recorded for the given file name.