Recommended options for ADMIN_archive_log_tables.pl

[jessiekidfernando]

Hello VICI Team,

Just like to know your inputs. We would like to know the recommended options for this script.


/usr/share/astguiclient/ADMIN_archive_log_tables.pl

print " [--daily] = only archives call_log, vicidial_log_extended, vicidial_dial_log and vicidial_drop_log tables, only last 24 hours kept\n";
print " [--carrier-daily] = will also archive the vicidial_carrier_log table when --daily is run\n";
print " [--vlog-daily] = will also archive the vicidial_log table when --daily is run\n";
print " [--days=XX] = number of days to archive past, default is 732(2 years)\n";
print " [--months=XX] = number of months to archive past, default is 24(2 years) If 'days' used then 'months' ignored\n";
print " [--queue-log] = archive QM queue_log records\n";
print " [--only-trim-archive-level-one] = will not perform normal archive process, instead this will only delete records\n";
print " that are older than XX months from least important log archive tables:\n";
print " call_log_archive, vicidial_log_extended_archive, vicidial_dial_log_archive, vicidial_drop_log\n";
print " [--only-trim-archive-level-two] = same as --only-trim-archive-level-one, except includes tables:\n";
print " vicidial_carrier_log_archive, vicidial_api_log_archive, vicidial_rt_monitor_log_archive\n";
print " [--only-trim-archive-level-three] = same as --only-trim-archive-level-two, except includes tables:\n";
print " vicidial_log_archive, vicidial_agent_log_archive, vicidial_closer_log_archive, vicidial_xfer_log_archive\n";
print " [--recording-log-days=XX] = OPTIONAL, number of days to archive recording_log table only past\n";
print " [--did-log-days=XX] = OPTIONAL, number of days to archive vicidial_did_log table only past\n";
print " [--cpd-log-purge-days=XX] = OPTIONAL, number of days to purge vicidial_cpd_log table only past\n";
print " [--wipe-closer-log] = OPTIONAL, deletes all records from vicidial_closer_log after archiving\n";
print " [--wipe-all-being-archived] = OPTIONAL, deletes all records from most tables after archiving\n";
print " [--quiet] = quiet\n";
print " [--calc-test] = date calculation test only\n";

Our cluster consists of 10 agent/dialer server and single database with slave replication.

Regards,

Jessie

[williamconley]

the answer to that question is based entirely on YOUR needs.

every single option there suits a specific need.

If you're not sure, set the system to archive monthly and to retain 12 months of data and not to delete anything.

Or just uncomment the first archive option in the crontab at its default settings.

[jessiekidfernando]

Thanks a lot for your response Williamconley. I have adjusted it based from our current settings.

[dhijrwn]

the answer to that question is based entirely on YOUR needs.

every single option there suits a specific need.

If you're not sure, set the system to archive monthly and to retain 12 months of data and not to delete anything.

Or just uncomment the first archive option in the crontab at its default settings.

Is there an option where the agents can see their archived call logs on the agent web interface?

[williamconley]

You would do better to check that by logging in as an agent and looking at the page in question to see if there is an "acrhived" button available rather than taking anyone's word for it (other than Matt, of course ). But I don't think so.