Working with Data Archival and Data Retrieval

this section covers the following topics about data archival data archival is the process of transferring data from primary storage to secondary storage for long term retention data retrieval involves accessing and retrieving the archived data as needed based on specific requirements the data archival feature enhances system performance and ensures compliance with record retention policies by removing outdated records from your production database this data is then securely relocated to secondary storage hosted within the same cloud landscape data archival is only available for cloud deployments ivanti recommends storing no more than 24 months of inactive data in production audit tables are not supported for data archival only records that can be deleted from the application are eligible for data archival considerations before archiving data before initiating the data archiving process, ivanti recommends taking the following factors into account irreversible archiving once the data is archived, it cannot be restored to its original form retrieval can only be done through the designated retrieval page related records when you archive a parent record, all related records are archived as well, irrespective of their current state for instance, archiving a service request record will also archive associated child data, including journals, tasks, events, and more data privacy before archiving data, ensure that sensitive or personally identifiable information (pii) is either securely deleted or anonymized to align with your organization's privacy regulations retention policy archived data is stored in secondary storage from the moment of archiving onwards and will adhere to ivanti's data retention policy enabling data archival to enable data archival from the configuration console, click build > extend > data archive and retrieve to view the data archive and retrieve workspace click enable data archiving toggle button to enable data archival excluding records from archival if a record qualifies for archival, you can exclude it by following these steps select one or more incidents choose more > data archive select exclude from archival when prompted, click yes to confirm the selected records are excluded from archival to revert this action select reset exclude from archival to include the record(s) in the archival process again viewing records based on archival status you can use the saved search feature to view records based on their archival eligibility or exclusion status to filter records, follow these steps click all active incidents select all saved search in the search panel, enter exclude choose one of the following options record excluded from archival – displays records manually excluded from the archival process record not excluded from archival – displays records still eligible for archival unlike other packages, which are imported by default during the out of the box (ootb) setup or upgrade process, the ci metadata package requires a manual import you can access the ci metadata package here https //marketplace ivanti com/xchange/64b5b48e2ee9d6e08c3e6724 viewing general information about data archival to view general information from the configuration console, click build > extend > data archive and retrieve to view the data archive and retrieve workspace click general information the general information about data archival page displays the number of archived records, total parent records archived, and total child records archived configuring archive policy use the configure archive policy page to perform the following actions set the archival period individually for a specific business object (bo) define the status for a business object choose from predefined status options available out of the box (ootb), or create custom statuses tailored to your business needs additionally, you can enable or disable individual archival policies for instance, if you only want to archive incidents, you can turn off other bos and activate specific archival policies default high level policies are provided, but you can customize archival policies based on your specific requirements use to enable or disable policies, and click to save your archival settings currently, the following business objects support data archival change ci incident service request problem purchase order knowledge hr case to configure an archive policy from the configuration console, click build > extend > data archive and retrieve to open the data archive and retrieve workspace click configure archive policy the configure archive policy page appears set the archival period, status , or enable or disable the archival policy for business objects based on your requirement click to save the archival settings retrieving archived data the data retrieval tab allows you to easily access and retrieve your archived data it provides a convenient way to search for specific files or information within the archive and retrieve them as needed to retrieve archived data from the configuration console, click build > extend > data archive and retrieve the data archive and retrieve page appears click retrieve archived data select the business object from the select bo to retrieve drop down list under search context , select the search criteria the following search options are supported keyword executes a search based on the search keyword in business object you can either search field that have full text search enabled or fields which are key columns (e g incident number, sr number) object creation data range executes a search based on the date range click search the archived data is displayed based on the search criteria after the system loads the results, you can view the attachment details for each record the system displays attachments for both parent records and their corresponding child records viewing data archival history the data archival history tab displays the summary of all the actions taken on your data during the archival process to view the data archival history from the configuration console, click build > extend > data archive and retrieve the data archive and retrieve page appears click data archival history the data archival history page displays the summarized status of the archival job this page displays the following information column description archive message id specifies the archive message unique id archive bo specifies the business object for which the archive was run archive status specifies the archive status remark specifies the comments added while archiving the business object created by specifies the user role who initiated the archival archive from date specifies the starting date time period from which data is to be archived archive to date specifies the ending date time period up to which data is to be archived created date time specifies the date and time when the archival job is created viewing data purge history the data purge history tab displays a log of the deleted activities performed on your data, and provides a summary of when and what data was purged to view data purge history from the configuration console, click build > extend > data archive and retrieve the data archive and retrieve page appears click data purge history the purge history page displays the purged archived business objects this page displays the following information column description archive message id specifies the archive message unique id business object name specifies the business object name purge status specifies the purge status remark specifies the comments added while purging the archived business object purge data query path specifies the azure blob storage path of a purge query for an already archived data set the archival record batch count is 100 completed date time specifies the date and time when the archived business object was purged exporting archived data the retrieve archived data page supports exporting archived data in standard readable formats the data columns shown in the report are customizable and can support with advanced filtering and search capabilities main table population data is populated based on the search criteria selected in the business object (bo) drop down each row contains both a parent and child table, presenting information in a hierarchical structure where dependent records are nested beneath each parent record customized column display for both the parent and child tables, select the required fields using the choose column display button export functionality table data can be exported using the export to xls/ json/ csv options user can export a maximum of 10 records exporting the data grid filters is only applicable for data within the grid supported export options include exporting selected rows to json format to export selected rows in json format go to configuration console and click build > extend > data archive and retrieve on the data archive and retrieve page, select retrieve archived data select a business object from the select bo to retrieve drop down list specify your search criteria under search context the following search options are supported keyword executes a search based on the search keyword in business object you can search fields that have full text search enabled object creation data range executes a search based on the date range click search to display archived data based on the selected criteria the column chooser feature is not applicable for export to json select the rows to export and click apply selection \[optional] use the simple search and advanced search filter options to refine your search criteria a to perform a simple search click select the records from the list that is displayed or enter the keywords to search the record a list of records are displayed based on the search criteria b to perform advanced search click a list of operators such as contains, does not contain, starts with, ends with, equals, and does not equal are displayed c select the operator and enter a value the search records based on the operator selected are displayed search results matching the selected operator are displayed for instance, selecting the ends with operator for the incident id column with a value of 22 will retrieve incidents ending with 22 click and select the export selected rows to json option the json file is downloaded in your system exporting selected rows to xls format to export selected rows in xls format go to configuration console and click build > extend > data archive and retrieve on the data archive and retrieve page, select retrieve archived data select a business object from the select bo to retrieve drop down list specify your search criteria under search context the following search options are supported keyword executes a search based on the search keyword in business object you can either search field that have full text search enabled or fields which are key columns (example incident number, sr number) object creation data range executes a search based on the date range click search to display archived data based on the selected criteria \[optional] click choose display columns the column chooser shows all the related bos which are in relationship with the parent bo selected in tabbed format to customize the columns to be chosen, navigate to each tab and add/remove the columns you wish to display/hide in the export by default, the first 10 columns for each bo are exported to the xls provided that the data is present a maximum of 10 columns can be chosen for each bo clear the related bo names from the respective tabs which should be excluded from export (except parent bo which will be exported by default ) select the rows to export and click apply selection \[optional] use the simple search and advanced search filter options to refine your search criteria a to perform a simple search click select the records from the list that is displayed or enter the keywords to search the record a list of records are displayed based on the search criteria b to perform advanced search click a list of operators such as contains, does not contain, starts with, ends with, equals, and does not equal are displayed c select the operator and enter a value the search records based on the operator selected are displayed search results matching the selected operator are displayed for instance, selecting the contains operator for the category column with a value of account will retrieve incidents that contain account click and select the export selected rows to xls option the xls file is downloaded in your system exporting selected rows to csv (raw) format to export selected rows in csv (raw) format go to configuration console and click build > extend > data archive and retrieve on the data archive and retrieve page, select retrieve archived data select a business object from the select bo to retrieve drop down list specify your search criteria under search context the following search options are supported keyword executes a search based on the search keyword in business object you can either search field that have full text search enabled or fields which are key columns (example incident number, sr number) object creation data range executes a search based on the date range click search to display archived data based on the selected criteria the column chooser feature is not applicable for export to csv select the rows to export and click apply selection \[optional] use the simple search and advanced search filter options to refine your search criteria a to perform a simple search click select the records from the list that is displayed or enter the keywords to search the record a list of records are displayed based on the search criteria b to perform advanced search click a list of operators such as contains, does not contain, starts with, ends with, equals, and does not equal are displayed c select the operator and enter a value the search records based on the operator selected are displayed search results matching the selected operator are displayed for instance, selecting the closed by operator for the closed by column with a value of "jsmith" will retrieve incidents that were closed by "jsmith" click and select the export selected rows to csv (raw) option the csv file is downloaded in your system