I looked at my table size on my logger. The table t_Persistent_Variable have 16 only 16 row but take 475Mb of the database. I do a SELECT to check the data and I'm sure that those 16 row cannot occupied 475Mb of the databas. Is there something that I can do to clean some space from that particular table.
The Persistent Variable table is unlike the other historical tables. The other tables have date/time entries that indicate historical data. Persistent Variable, on the other hand, only contains one record for each variable that is persisted, which contains the current value. The PV table may be updated frequently, depending on the usage of the variables. The frequent updates may cause fragmentation, which could possibly be the cause of the table taking up a lot of space. HKEY_LOCAL_MACHINE\SOFTWARE\Cisco Systems, Inc.\ICM\li102\LoggerA\Recovery\CurrentVersion\Purge\Retain\Variables\Persistent could be reduced from 30 to lesser days if the data being populated is too frequent.
These are the paths to get to each CCX logs through CLI. They may be helpful if you are having issues accessing RTMT or downloading logs through it.
If you want to download them you have to prefix "file get " and you can add one of the options (re...