{"id":10519,"date":"2025-09-23T23:06:22","date_gmt":"2025-09-23T21:06:22","guid":{"rendered":"https:\/\/b417hp-c.myrdbx.io\/?page_id=10519"},"modified":"2025-10-14T11:39:49","modified_gmt":"2025-10-14T09:39:49","slug":"aggiornamento-dellambiente-automic","status":"publish","type":"page","link":"https:\/\/dani020.supserv.cozmoslabs.com\/it\/products\/automic-automation\/implementation-updates\/automic-environment-update\/","title":{"rendered":"Richiedete un preventivo per il vostro aggiornamento ambientale Automic"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"10519\" class=\"elementor elementor-10519\">\n\t\t\t\t<div class=\"elementor-element elementor-element-51a23fbb e-flex e-con-boxed e-con e-parent\" data-id=\"51a23fbb\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-57516c7e e-con-full container-content-header e-flex e-con e-child\" data-id=\"57516c7e\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-7d2cbf7d e-con-full e-flex e-con e-child\" data-id=\"7d2cbf7d\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3882b49b elementor-widget elementor-widget-text-editor\" data-id=\"3882b49b\" 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<strong>Automic<br>Update Request<\/strong>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f0f9a62 elementor-widget elementor-widget-text-editor\" data-id=\"4f0f9a62\" 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>We\u2019re here to help stay up to date.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1f37c369 e-con-full container-hide-mobile e-flex e-con e-child\" data-id=\"1f37c369\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5065df36 elementor-widget__width-initial elementor-widget elementor-widget-image\" data-id=\"5065df36\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dani020.supserv.cozmoslabs.com\/wp-content\/uploads\/2025\/05\/dots-triangle-red-v2_neu-v4.svg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\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-5795ca64 e-flex e-con-boxed e-con e-parent\" data-id=\"5795ca64\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3bf027e4 e-con-full e-flex e-con e-child\" data-id=\"3bf027e4\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4b804605 elementor-widget elementor-widget-shortcode\" data-id=\"4b804605\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\">[rank_math_breadcrumb]<\/div>\n\t\t\t\t\t\t<\/div>\n\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-011c189 e-flex e-con-boxed e-con e-parent\" data-id=\"011c189\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-1f14df0 e-con-full e-flex e-con e-child\" data-id=\"1f14df0\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9694bfc elementor-widget elementor-widget-text-editor\" data-id=\"9694bfc\" 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<section lang=\"en\">\n  <h3>Request Your Automic Environment Update<\/h3>\n  <p><strong>Please use this form to request an update for your Automic environment.<\/strong> Providing accurate details will help us process your request efficiently and ensure the update runs smoothly.<\/p>\n  <p>Updates may include the latest fixes, performance improvements, and new features that enhance overall system stability and reliability. The information you provide also forms the basis for further conversations with our team and allows us to act as quickly as possible.<\/p>\n\n  <h4>Why Accurate Information Matters<\/h4>\n  <p>To avoid delays, make sure that all required information is entered correctly in the form. The more complete the details, the faster we can prepare and implement the update for your Automic system.<\/p>\n\n  <h4>Next Steps After Submission<\/h4>\n  <p>Once the form is submitted, our team will review your request carefully and contact you regarding the next steps. You will receive guidance on timelines, planned improvements, and any additional requirements.<\/p>\n\n  <h5>Support for Completing the Form<\/h5>\n  <p>If you need SQL statements to determine the number of executions in your environment, please download the appropriate script below. Using these statements will help you provide the correct figures and ensure your request is processed without interruptions.<\/p>\n<\/section>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a33e17f elementor-widget elementor-widget-text-editor\" data-id=\"a33e17f\" 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<!doctype html>\n<html lang=\"en\">\n<head>\n  <meta charset=\"utf-8\">\n  <title>Download SQL as TXT<\/title>\n<\/head>\n<body>\n\n  <button onclick=\"downloadSQL('postgresql')\">PostgreSQL<\/button>\n  <button onclick=\"downloadSQL('oracle')\">Oracle<\/button>\n  <button onclick=\"downloadSQL('mssql')\">MS SQL Server<\/button>\n  <button onclick=\"downloadSQL('db2')\">DB2<\/button>\n\n  <script>\n    const sqlSnippets = {\n      postgresql: `-- POSTGRESQL\nwith bounds as (\n  select\n    date_trunc('month', current_date)::date                         as first_curr_month,\n    (date_trunc('month', current_date) - interval '6 months')::date as first_window_start\n)\nselect\n  m.month_start as month,\n  count(*)      as runs\nfrom (\n  select\n    date_trunc('month', ah_timestamp1)::date as month_start\n  from dbo.ah\n  where ah_timestamp1 is not null\n    and ah_client <> 0\n    and ah_otype in ('SCRI','EVNT','!EVNT','JSCH','JOBS','JOBF','JOBP','CALL','JOBG','C_PERIOD','REPORT')\n) m\ncross join bounds b\nwhere m.month_start >= b.first_window_start\n  and m.month_start <  b.first_curr_month\ngroup by m.month_start\norder by m.month_start;`,\n\n      oracle: `-- ORACLE\nWITH bounds AS (\n  SELECT\n    TRUNC(SYSDATE, 'MM')                 AS first_curr_month,\n    ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -6) AS first_window_start\n  FROM dual\n)\nSELECT\n  month_start AS month,\n  COUNT(*)    AS runs\nFROM (\n  SELECT TRUNC(AH_TimeStamp1, 'MM') AS month_start\n  FROM AH\n  WHERE AH_TimeStamp1 IS NOT NULL\n    AND AH_Client <> 0\n    AND AH_OTYPE IN ('SCRI','EVNT','!EVNT','JSCH','JOBS','JOBF',\n                     'JOBP','CALL','JOBG','C_PERIOD','REPORT')\n) m, bounds b\nWHERE m.month_start >= b.first_window_start\n  AND m.month_start <  b.first_curr_month\nGROUP BY month_start\nORDER BY month_start;`,\n\n      mssql: `-- MSSQL\nWITH bounds AS (\n  SELECT\n    CAST(DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1) AS date)                   AS first_curr_month,\n    CAST(DATEADD(MONTH, -6, DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1)) AS date) AS first_window_start\n),\nmonthly AS (\n  SELECT\n    DATEFROMPARTS(YEAR(AH_TimeStamp1), MONTH(AH_TimeStamp1), 1) AS month_start\n  FROM AH\n  WHERE AH_TimeStamp1 IS NOT NULL\n    AND AH_Client <> 0\n    AND AH_OTYPE IN ('SCRI','EVNT','!EVNT','JSCH','JOBS','JOBF',\n                     'JOBP','CALL','JOBG','C_PERIOD','REPORT')\n)\nSELECT\n  m.month_start AS month,\n  COUNT(*)      AS runs\nFROM monthly m\nCROSS JOIN bounds b\nWHERE m.month_start >= b.first_window_start\n  AND m.month_start <  b.first_curr_month\nGROUP BY m.month_start\nORDER BY m.month_start;`,\n\n      db2: `-- DB2\nWITH params AS (\n  SELECT\n    DATE(LEFT(CHAR(current_date, ISO), 7) || '-01')                 AS first_curr_month,\n    ADD_MONTHS(DATE(LEFT(CHAR(current_date, ISO), 7) || '-01'), -6) AS first_window_start\n  FROM sysibm.sysdummy1\n),\nmonthly AS (\n  SELECT\n    DATE(LEFT(CHAR(AH_TimeStamp1, ISO), 7) || '-01') AS month_start\n  FROM AH\n  WHERE AH_TimeStamp1 IS NOT NULL\n    AND AH_Client <> 0\n    AND AH_OTYPE IN ('SCRI','EVNT','!EVNT','JSCH','JOBS','JOBF',\n                     'JOBP','CALL','JOBG','C_PERIOD','REPORT')\n)\nSELECT\n  m.month_start AS month,\n  COUNT(*)      AS runs\nFROM monthly m\nCROSS JOIN params p\nWHERE m.month_start >= p.first_window_start\n  AND m.month_start <  p.first_curr_month\nGROUP BY m.month_start\nORDER BY m.month_start;`\n    };\n\n    function downloadSQL(dbType) {\n      const sql = sqlSnippets[dbType];\n      const blob = new Blob([sql], { type: \"text\/plain\" });\n      const link = document.createElement(\"a\");\n      link.href = URL.createObjectURL(blob);\n      link.download = `${dbType}-show-sql.txt`;\n      link.click();\n      URL.revokeObjectURL(link.href);\n    }\n  <\/script>\n\n<\/body>\n<\/html>\n\t\t\t\t\t\t\t\t<\/div>\n\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-f686979 e-flex e-con-boxed e-con e-parent\" data-id=\"f686979\" 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-8d1adef elementor-widget elementor-widget-shortcode\" data-id=\"8d1adef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\">[fluentform id=\"14\"]<\/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\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>AutomicUpdate Request We\u2019re here to help stay up to date. [rank_math_breadcrumb] Request Your Automic Environment Update Please use this form [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":3075,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"full-width-container","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":"disabled","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":""},"class_list":["post-10519","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/dani020.supserv.cozmoslabs.com\/it\/wp-json\/wp\/v2\/pages\/10519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dani020.supserv.cozmoslabs.com\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dani020.supserv.cozmoslabs.com\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dani020.supserv.cozmoslabs.com\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dani020.supserv.cozmoslabs.com\/it\/wp-json\/wp\/v2\/comments?post=10519"}],"version-history":[{"count":34,"href":"https:\/\/dani020.supserv.cozmoslabs.com\/it\/wp-json\/wp\/v2\/pages\/10519\/revisions"}],"predecessor-version":[{"id":11441,"href":"https:\/\/dani020.supserv.cozmoslabs.com\/it\/wp-json\/wp\/v2\/pages\/10519\/revisions\/11441"}],"up":[{"embeddable":true,"href":"https:\/\/dani020.supserv.cozmoslabs.com\/it\/wp-json\/wp\/v2\/pages\/3075"}],"wp:attachment":[{"href":"https:\/\/dani020.supserv.cozmoslabs.com\/it\/wp-json\/wp\/v2\/media?parent=10519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}