Re: [Perfparse-users] Delete some services

[Ben C. <bcl...@pe...>]

Daniele

Thanks for showing this bug, we will have to look into this.  The 
addition of the summary tables is quite recent, you are probably the 
first person to notice.

The option to permanently delete a host is working.  Further you can 
manually set the flag to permanently delete a service or metric using 
SQL, which will then be deleted when the parse is run.

Since the main developers of PP all seem to be to busy to contribute 
much at the moment, my self included.  If there is anybody who would 
like to look into this it would be useful.

Regards,

Ben.

Daniele Coli` wrote:
> 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
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>