How do I query on the loglimit for each data stream in the AppManager repository? (NETIQKB9157)

How do I query on the loglimit for each data stream in the AppManager repository?

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

Formerly known as NETIQKB9157