Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
Situation
Resolution
Run the following queries to verify the current data loglimit: The following query shows the loglimit for each data stream:
SELECT DISTINCT loglimit FROM Dataheader
The following sets the data loglimit to 10 days:
UPDATE Dataheader SET loglimit=10
The following returns how much data has been collected for each DataID:
SELECT COUNT(*), Dataid FROM data GROUP BY dataid
After setting the loglimit to 10, run the NetIQ PurgeAllData task to remove the Data from the Data table.
Alternate query to set the loglimit on existing data streams:
UPDATE DataHeader SET LogLimit = n where LogLimit > n
n = the number of days that the customer wants to keep