[Perfparse-users] Delete some services

[Daniele C. <dan...@ti...>]

Hello,

Currently, I'm using perfparse 0.105.6 and nagios 1.2 on a FreeBSD-5.3; MySQL version is 4.1.9 for portbld-freebsd5.3.
As I'm trying to fine-tune system, I add and delete many service checks; now I have problems in deleting service data entirely. I marked services didn't need to delete bin and raw data always and ran perfparse-db-purge; data disappeared, but possibility to show graphs stayed. I checked the DB and noticed I can't delete the service from perfdata_service table as it was referenced by other tables - such as perfdata_raw_summary and perfdata_service_metric. So, to properly clean the DB I had to delete manually all entries releted to that service hoping not to leave trash around.
Has anyone had my same problem? How he solved?
I'd like to have a script - executed regurarly - that checks for services with no data and deletes them leaving no trash. May anyone who knows better perfparse DB sructure help me?

Thanks in advance.

Daniele