Best answers and resolutions to the most common questions on Data Management for AR System and BMC Helix ITSM

Q: What are the Best Practices for Archiving data in ITSM and Innovation Suite?
A: See Remedy - AR System Server - Archiving Best Practices and configurations

Q: How would I troubleshoot issues with Archiving data in which the data is not being properly transferred to the Archive forms?
A:  See Troubleshooting the Archive Process

Q: Where can I find detailed information on setting up Archiving and Archive policies?
A: See Remedy IT Service Management Suite 20.02 Administering Archive 

Q: My DBA wants to know how to identify the underlying database tables for the AR System forms so that he can monitor their size and perform maintenance.  What information can I provide?
A: This should provide enough information for the DBA to identify the underlying tables: Understanding the relationship between forms and database tables 

Q:  Do you have a video that shows how to setup archiving?
A:  Yes, see Connect with BMC Helix ITSM - Getting Started with Archiving Webinar

Q: Is there a utility or script that I can run (or have DBA run) to check the to make sure all my data tables are in sync?
A:  BMC provides a Community-supported utility that will validate all your form data tables and check for inconsistencies and orphans, here: Helix ITSM Support: Data Integrity Checker Tool 

Q: My ARSystem Database is growing very large and I need  to understand how the data is being used.   Do you have a tool that can help me see how much data each of my forms is using?
A:  Yes, use the AR System Schema Overview Console, a Community-supported tool for this purpose. Find details how to install it and use it here: Helix ITSM Support: AR System Schema Overview Console 

Q:  Are there common archiving policies used by BMC customers that I can adopt and adjust vs creating my own?
A:  Yes, there is a deployment package with policies recommended by BMC customers, you can find it on Community attached to this blog: Helix ITSM Support: Managing System Data

Background: BMC Customer Support analyzes case trends to identify topics that are trending with customers, the resources we share most often to assist them, and how we can improve them.  This Best FAQ article provides links to the resources shares resources most recommended by BMC Customer Support on the topic.
Current as of ARSystem 20.02.02,  Innovation Suite 21.x,  July 14, 2022