how to get the number of executions in Automic ? Evidently there's a metric script that is used to measure "compliance" against the license

[Ankur sharma]

how to get the number of executions in Automic ? Evidently there's a metric script that is used to measure "compliance" against the license

-------------------------------------------

[Juergen Lechner]

Hi,

try

SELECT 
   SUBSTR(lah_date, 1, 2) AS execution_year,
   SUBSTR(lah_date, 3, 2) AS execution_month,
   SUM(lah_count1) AS total_count1,
   SUM(lah_count2) AS total_count2
FROM 
   lah
WHERE 
   lah_name = 'aggregate_number_of_executions' AND
   lah_system = ' '
GROUP BY 
   execution_year, execution_month
ORDER BY 
   execution_year, execution_month;

Regards,
Juergen

------------------------------
Juergen Lechner
Managing Consultant
setis GmbH
Germany
------------------------------