How to purge inactive devices [KATA/KEDRE]

[Antipova Anna]

Advice and Solutions (Forum Knowledgebase) Disclaimer. Read before using materials.

KATA doesn't have auto removal for inactive agents, and also it doesn't have support for VDI scenarios yet.

So if you have many VDI clients in use, they will quickly fill up the license.

Step-by-step guide

KATA 3.7.2

You can set up cron task to remove clients periodically, for example, this code will remove clients older than 3 days

sudo -u kluser psql antiapt -c "delete from agent_status where last_packet_time < (NOW() - INTERVAL '3 days');"

KATA 4.0/4.1/5.0

docker exec -it `docker ps | grep kedr_database_server | awk '{print $1}'` psql -U kluser antiapt -c "delete from agent_status where last_packet_time < (now() - interval '2 weeks');"

 It will delete 2 weeks old inactive agents.