entity optionf for recorder (include/exclude and purge days)

[L0bit0]

Hi

Background:

I spent a lot of time tiring to get my DB organized and not growing dramatically.

There are some entities I do not care, and I have excluded, and others where I have different retention depending on some different factors:
Short term: 1 week
Medium term: 3 months
Large: 1 year
Large: I do not remove
In my case I use some export to excel and pivot tables to determine the list of entities in each case and update some purge jobs
NOTE: not sure if it is the most effective way, but it works for me…

In summary I what to remarks that there is no a simple way to keep data retention configure

Proposal:
Add a Data section on each entity to cover this.
I would ad the following fields:
Include:
- Field type: Yes/no
- If no, consider on db exclude section, and no more options will be showed/enabled
- If yes new options will be showed/enabled
Default Purge:
- Field type: Yes/no
- If YES: no other option will be showed/enabled
- If yes new option will be showed/enabled
Purge Days
- Field type: number
- User should type a number of days to keep this entity stored

NOTE: I assume this option could be a bit complex, but at least I think we should consider a better/easy way to manage our storage, having on mind that number of devices use to grow and information of these devices are really different, with some entities that make sense just on actual moment, and other where is good to keep some info to check history, see trends… keep this info for medium long term and do not have a huge DB is a hard as it is configured right now.

Thanks in advance