daily increase in data in ise

[CCC3]

I would like to know the daily increase in the database of ise.

I know how to use the Database Utilization in Operational Data Purging to see it in pictures or numbers

I want to know exactly how much it accumulates in a day.

Is there a way to check it separately?

[Arne Bier]

One crude method could be to take a screenshot of the current state, and then repeat in 24 hours and compare.

Maybe there is an SQL table via ISE Dataconnect, that tells you the size of the retained data. I have not looked.

Regarding the size of the ISE Configuration Database ... you'll get an indication of that via a Config Backup. Although, the Config Backup contains a lot of non-configuration related junk.  Unless you know how the ISE Configuration is stored (possibly in various places/SQL tables and various formats) it might be tricky. You can take a config backup and then dump the contents to look inside - you will need the password to decrypt a config backup. Here's a link on how to do that, which I posted a while ago - but the process should still be the same.

[CCC3]

I already knew what you said

I posted a post because I was wondering if there was a way to know the exact figures.

I think you can check it with SQL syntax
I don't really like going into ISE ROOT
I think it'll be hard for me to check that part, too.

[Arne Bier]

Accessing ISE Monitoring databases via Dataconnect is quite easy and you can do it with a tool like DBeaver (there is a Community edition) - or with Thomas Howard's pysql script - yuou can issue SQL queries by running a simple but clever python script.

I still don't know whether you're looking for the Config Database size, or the RADIUS/TACACS database size ?

I had a look in DBeaver against ISE 3.4 and I cannot see any SQL table that contains the information you need. Cisco doesn't expose all tables to us.

If you have access to the MNT node CLI, you can run a "show tech-support" and then you see the size (in bytes) of the various /opt sub folders where (I suspect) the Oracle databases live.

screen-length 0
show tech-support

I see some stuff about directory sizes and also Oracle table sizes - but unless you know how ISE works under the hood, it might be a guessing game.