{"id":17007,"date":"2026-06-09T11:36:09","date_gmt":"2026-06-09T09:36:09","guid":{"rendered":"https:\/\/tricise.com\/?p=17007"},"modified":"2026-06-09T11:36:10","modified_gmt":"2026-06-09T09:36:10","slug":"manutenzione-del-database-automic-rest-api-v26","status":"publish","type":"post","link":"https:\/\/tricise.com\/it\/automic-database-maintenance-rest-api-v26\/","title":{"rendered":"Tricise Automic V26 Enablement Series: Manutenzione del database AE tramite API REST"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"17007\" class=\"elementor elementor-17007\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-59c68ea e-flex e-con-boxed e-con e-parent\" data-id=\"59c68ea\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-10978cc elementor-widget elementor-widget-text-editor\" data-id=\"10978cc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<!-- ============================================================\n     BLOG POST BODY \u2014 PART 1 (PRE-VIDEO)\n     Paste this into WordPress ABOVE the embedded walkthrough video.\n     No <h1> (WordPress provides it), no inline CSS, body starts at <h3>.\n     ============================================================ -->\n\n<p>Database housekeeping is the task every Automic administrator knows they should run regularly and quietly keeps postponing &mdash; until execution data, old reports and system messages have bloated the AE database. For years, <strong>Automic database maintenance<\/strong> meant reaching for the local AE DB utilities or going to the database directly, which is exactly why it slid down the to-do list. In Automic V26 that friction is gone: you can archive, reorganize, delete and clean up operational data straight from the AWI Administration perspective and the AE REST API. This article is part of our Automic V26 enablement series, and it focuses on the REST API path &mdash; the walkthrough video below shows the same operations end to end.<\/p>\n\n<h3>What changed in Automic database maintenance in V26<\/h3>\n\n<p>In earlier releases, archiving, reorganizing and unloading the AE database was handled by the standalone AE DB utilities or by working against the database directly. Automic V26 brings these activities under governed, API-driven control: the same maintenance tasks are now exposed through the AE REST API and the AWI Administration perspective, so you no longer need local utility binaries or direct database credentials to run them.<\/p>\n\n<p>Throughout, the data you are managing is what Automic calls <em>operational data<\/em>: system messages, execution data (formerly called statistics), reports and comments. Across the board, the AE REST API covers five operations: archive operational data, create revision reports, reorganize operational data, delete operational data, and empty the Recycle Bin.<\/p>\n\n<p>The practical payoff is governance. Routing maintenance through the AE REST API means every archive, reorganization and deletion is an auditable, repeatable call rather than an ad hoc utility run on someone&#8217;s workstation &mdash; and it can be granted through a single privilege instead of database-level access. For regulated Automic estates, that traceability matters as much as the freed-up database space.<\/p>\n\n<h3>Privileges and configuration to set up first<\/h3>\n\n<p>Before you run any Automic database maintenance through the REST API, two things need to be in place: the right user privileges and the variables that control each operation.<\/p>\n\n<ul>\n  <li><strong>Privileges.<\/strong> The <code>DB_MAINTENANCE<\/code> privilege starts the archiving, reorganization and deletion processes. To download archive packages and revision reports you also need <code>ACCESS_METRICS_ENDPOINT<\/code>, and to read or empty the Recycle Bin you need <code>RECYCLE_BIN<\/code>.<\/li>\n  <li><strong>Configuration variables in Client 0.<\/strong> Archiving parameters live in <code>UC_UTILITY_ARCHIVE<\/code>, reorganization parameters in <code>UC_UTILITY_REORG<\/code>, and deletion parameters in <code>UC_UTILITY_DB_UNLOAD<\/code>. For revision reports, object logging (<code>OBJECT_AUDIT<\/code>) must be enabled in <code>UC_CLIENT_SETTINGS<\/code>.<\/li>\n  <li><strong>Output location.<\/strong> The archive or report package is written automatically to the directory you define in the Automation Engine INI file for on-premises systems, or in the <code>values.yaml<\/code> file for AAKE (containerized) environments. From there you transfer it wherever you need it.<\/li>\n<\/ul>\n\n<p>With the privileges granted and the variables configured once, every subsequent run is a single API call. The walkthrough below shows these operations in the AWI and via the AE REST API &mdash; follow along, then use the reference calls in the second half of this guide.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ac1e01f e-flex e-con-boxed e-con e-parent\" data-id=\"ac1e01f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-71a792c elementor-widget elementor-widget-video\" data-id=\"71a792c\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/U7NsYAJ4uSI&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5367721 e-flex e-con-boxed e-con e-parent\" data-id=\"5367721\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-31bf136 elementor-widget elementor-widget-text-editor\" data-id=\"31bf136\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><!-- ============================================================<br \/>\n     BLOG POST BODY \u2014 PART 2 (POST-VIDEO)<br \/>\n     Paste this into WordPress BELOW the embedded walkthrough video.<br \/>\n     No <\/p>\n<h1>, no inline CSS, headings continue at <\/p>\n<h3>\/<\/p>\n<h4>.<br \/>\n     FAQ uses native <\/p>\n<details>\/<\/p>\n<summary> accordions (expand on click, no CSS\/JS).<br \/>\n     ============================================================ --><\/p>\n<h3>The maintenance operations via the AE REST API<\/h3>\n<p>Each operation is triggered in Client 0 and can target a single client (<code>target_client=100<\/code>) or every client (<code>target_client=ALL<\/code>) \u2014 you cannot select an arbitrary subset. Most processes return a <code>run_id<\/code> that you use to fetch the resulting package.<\/p>\n<h4>Archiving operational data<\/h4>\n<p>Archiving collects system messages, execution data, reports and comments into a downloadable ZIP. You trigger it with a POST, then download the package with the returned run ID:<\/p>\n<pre><code>POST \/ae\/api\/v1\/0\/system\/clients\/archive?target_client=100\n  \u2192 { \"run_id\": 1007001 }\n\nGET  \/ae\/api\/v1\/0\/system\/clients\/archive\/1007001\n  \u2192 (downloads the archive package)<\/code><\/pre>\n<p>With a REST client such as Postman, use the <em>Send and Download<\/em> option; with cURL, add <code>-o<\/code> to write the file to disk. The same endpoint called with the reset method clears the archive flag.<\/p>\n<h4>Creating revision reports<\/h4>\n<p>Revision reports give you a chronological, audit-ready record of changes in a client \u2014 created objects, deletions, transports, user logons and more \u2014 which is what keeps a regulated environment compliant. You can scope a report by date range and by change type:<\/p>\n<pre><code>POST \/ae\/api\/v1\/0\/system\/clients\/revisionreport?target_client=ALL\n{\n  \"from\":  \"2026-01-01T00:00:00Z\",\n  \"to\":    \"2026-03-31T00:00:00Z\",\n  \"types\": [\"CREATE\", \"DELETE\", \"OBJ_MOD\", \"USER\", \"TRNSPRT\"]\n}<\/code><\/pre>\n<p>If <code>types<\/code> is omitted, all change categories are included. The report is downloaded with its <code>run_id<\/code>, exactly like an archive package.<\/p>\n<h4>Reorganizing operational data<\/h4>\n<p>Reorganize operational data marks aging records for deletion without removing them yet. The retention logic combines two settings: a <em>reorganize older than<\/em> threshold in days and a <em>keep last<\/em> count. For example, with <em>reorganize older than<\/em> set to 30 and <em>keep last<\/em> set to 5, the process keeps everything from the last 30 days plus the five most recent older records per object.<\/p>\n<pre><code>POST \/ae\/api\/v1\/0\/system\/clients\/reorg?target_client=ALL<\/code><\/pre>\n<h4>Deleting operational data<\/h4>\n<p>Once records are marked, deleting operational data removes them permanently from the AE database. It is a single trigger per client or for all clients:<\/p>\n<pre><code>POST \/ae\/api\/v1\/0\/system\/clients\/deletedata?target_client=ALL<\/code><\/pre>\n<h4>Emptying the Recycle Bin<\/h4>\n<p>Deleted objects move to the Recycle Bin rather than disappearing immediately. From Client 0 you can list a client&#8217;s bin contents and then empty it:<\/p>\n<pre><code>GET    \/ae\/api\/v1\/0\/recyclebin?target_client=100\nDELETE \/ae\/api\/v1\/0\/recyclebin?target_client=ALL<\/code><\/pre>\n<p>Objects that still hold unarchived operational data are not deleted; they are returned in the response under <code>failedObjects<\/code>. The rule of thumb is simple: archive first, then empty.<\/p>\n<h4>Resetting archive and reorganization flags<\/h4>\n<p>If you need to re-run a cycle \u2014 for example, to archive records that were already flagged \u2014 the archive and reorganization endpoints accept a reset method that clears the corresponding flag. This lets you correct a mistimed run without touching the database, keeping the whole maintenance cycle inside the AE REST API.<\/p>\n<p><!-- ==========================================================<br \/>\n     IMAGE PLACEHOLDER 1 \u2014 \"Database Maintenance in the AWI Administration perspective\" (OPTIONAL)<br \/>\n     Recommended: screenshot of the AWI Administration perspective showing the<br \/>\n     archive \/ reorganize \/ delete actions for a selected client.<br \/>\n     Format: PNG, 16:9, max 1200px wide, < 200 KB Alt text suggestion: \"Automic database maintenance actions in the V26 AWI Administration perspective\" Caption suggestion: \"The same archive, reorganize and delete actions are available in AWI and via the AE REST API.\" (Adding one body image lifts RankMath media test 14.3 toward 100%; the embedded video already satisfies the pass threshold.) ========================================================== --><\/p>\n<h3>Make Automic database maintenance a scheduled job, not a chore<\/h3>\n<p>Because every operation is now a plain REST call, the natural next step is to stop running them by hand. Wrap the archive \u2192 reorganize \u2192 delete sequence in a scheduled Automic workflow so the AE database is maintained on a predictable cadence \u2014 and include Client 0, which accumulates server and agent logs and is easy to forget. If you would rather call the endpoints from a script, the new <a href=\"https:\/\/tricise.com\/automic-v26-python-integration\/\"><strong>Automic V26 Python integration<\/strong><\/a> lets you invoke them from a native Python job alongside your existing automation logic. Reliable Automic database maintenance is one of the least glamorous but most load-bearing parts of running V26 well.<\/p>\n<p>A sensible pattern is to reorganize on a regular schedule, archive before deletion, and sweep the Recycle Bin once archiving has confirmed nothing is left unarchived. Tuning the retention thresholds to your data volume is where most of the value sits \u2014 aggressive enough to keep the database lean, conservative enough to satisfy your audit window.<\/p>\n<p>This guide is part of our Automic V26 enablement series. If SAP is central to your landscape, the companion piece on <a href=\"https:\/\/tricise.com\/tricise-automic-v26-enablement-series-sap-agent\/\"><strong>SAP Agent Multiple System Support<\/strong><\/a> covers another V26 change worth reviewing before you upgrade. For the official specification, see Broadcom&#8217;s <a href=\"https:\/\/automation.broadcom.com\/blog\/automic-v26-establishing-intelligent-control-plane-enterprise-ai\" target=\"_blank\" rel=\"noopener\"><strong>Automic V26 release overview<\/strong><\/a> and the <a href=\"https:\/\/docs.automic.com\/documentation\/webhelp\/english\/AKE\/26.0\/DOCU\/26.0\/Automic%20Automation%20Guides\/Content\/REST_API\/AE_REST_API_Using_Database_Maintenance.htm\" target=\"_blank\" rel=\"noopener\"><strong>26.0 AE REST API database maintenance documentation<\/strong><\/a>.<\/p>\n<h3>Frequently asked questions<\/h3>\n<details>\n<summary><strong>Which privileges do I need for Automic database maintenance via the REST API?<\/strong><\/summary>\n<p>You need the DB_MAINTENANCE privilege to start archiving, reorganization and deletion. To download archive packages and revision reports you also need ACCESS_METRICS_ENDPOINT, and to read or empty the Recycle Bin you need the RECYCLE_BIN privilege.<\/p>\n<\/details>\n<details>\n<summary><strong>Does this work on-premises as well as in containerized AAKE environments?<\/strong><\/summary>\n<p>Yes. The operations are identical; only the output location differs. On-premises you set the package directory in the Automation Engine INI file, and in AAKE (container) environments you set it in the values.yaml file.<\/p>\n<\/details>\n<details>\n<summary><strong>What does Automic count as operational data?<\/strong><\/summary>\n<p>Operational data means system messages, execution data (formerly called statistics), reports and comments. These are the records that accumulate during daily operation and that maintenance is designed to archive, reorganize and remove.<\/p>\n<\/details>\n<details>\n<summary><strong>Can I run maintenance for all clients at once?<\/strong><\/summary>\n<p>Yes. From Client 0 you can target a single client with target_client=100 or every client with target_client=ALL. You cannot select an arbitrary subset of clients in a single call.<\/p>\n<\/details>\n<details>\n<summary><strong>How do I download an archive package or a revision report?<\/strong><\/summary>\n<p>Use the run_id returned when you trigger the process in a follow-up GET request. In Postman, use the Send and Download option; with cURL, add the -o flag to write the file to disk.<\/p>\n<\/details>\n<details>\n<summary><strong>What is the difference between reorganizing and deleting?<\/strong><\/summary>\n<p>Reorganizing marks aging operational data for deletion based on your retention settings but leaves it in the database. Deleting then removes the marked records permanently. Running reorganize first and delete second keeps you in control of what actually leaves the database.<\/p>\n<\/details>\n<details>\n<summary><strong>Where is the archive or report package stored?<\/strong><\/summary>\n<p>When you trigger the process, a background job collects the data into a ZIP file and writes it to the directory defined in the Automation Engine INI file (on-premises) or the values.yaml file (AAKE). You then download or transfer it from there.<\/p>\n<\/details>\n<h3><br><\/h3><h3>Plan your V26 maintenance setup<\/h3>\n<p>Moving database maintenance to the REST API is a small change with an outsized payoff in audit-readiness and database health \u2014 but it is worth getting the privileges, retention thresholds and schedule right for your specific landscape. If you would like a second pair of eyes on your V26 setup, <a href=\"https:\/\/tricise.com\/products\/automic-automation\/implementation-updates\/automic-environment-update\/\"><strong>book a free consultation with the Tricise Automic team<\/strong><\/a>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Manutenzione del database Automic nella versione 26: archiviazione, riorganizzazione ed eliminazione dei dati operativi tramite l&#x27;API REST AE \u2014 con esempi.<\/p>","protected":false},"author":59,"featured_media":17021,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[152],"tags":[327,329,312,328,330],"class_list":["post-17007","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-automic-automation","tag-ae-rest-api","tag-automation-engine","tag-automic-v26","tag-database-maintenance","tag-operational-data"],"acf":[],"meta_box":[],"_links":{"self":[{"href":"https:\/\/tricise.com\/it\/wp-json\/wp\/v2\/posts\/17007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tricise.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tricise.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tricise.com\/it\/wp-json\/wp\/v2\/users\/59"}],"replies":[{"embeddable":true,"href":"https:\/\/tricise.com\/it\/wp-json\/wp\/v2\/comments?post=17007"}],"version-history":[{"count":0,"href":"https:\/\/tricise.com\/it\/wp-json\/wp\/v2\/posts\/17007\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tricise.com\/it\/wp-json\/wp\/v2\/media\/17021"}],"wp:attachment":[{"href":"https:\/\/tricise.com\/it\/wp-json\/wp\/v2\/media?parent=17007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tricise.com\/it\/wp-json\/wp\/v2\/categories?post=17007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tricise.com\/it\/wp-json\/wp\/v2\/tags?post=17007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}