...

** Please note the local_data_id value

Tidying Up Archived BOD Requests

To 'turn off' data sources of graphs that have been moved to the Archive_BOD_Requests graph tree

update data_template_data
set active = ''
where local_data_id in (select `Data Source Id` from archived_bod_request_view);

followed by:

select concat("rm -f /opt/cacti/rra/",SUBSTRING_INDEX(data_source_path,'/',-1)) as 'command'
from data_template_data
where name like '%_BoD_urn_uuid%'
and active <> 'on';

Export the data into a file called cleanup.sh and copy this into the /tmp folder on both production servers. Login to both servers and sudo as root. Navigate to the /tmp folder and change the chmod of the file to 755 then execute ./cleanup.sh. This will delete all the RRD files of the Archived BoD Requests.