SQL query for Recurring tasks and number of executions per recurring task

[James Ebaynor]

Hi Forum folks,

     Does anyone have a sample query for Recurring tasks and number of executions per recurring task?

     Or anything close that I can tweak and play with? I can adjust it to SQL or PostGres or Oracle if needed.

Thanks in advance.

[BEN BAEZ]

The need for a query like this has just come up here as well. Did you figure this out? or If anyone has something they are willing to share it would be much appreciated.  Thanks

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

[Peter Grundler]

Hi James,

you can use this query as the basis:

select AH_Client, AH_Name, APD.*
 from APD
 inner join AH on (APD_AH_Idnr = AH_Idnr)
 where AH_Client = 1
 order by AH_TimeStamp4 desc;

regards,
Peter

------------------------------
Automic Certified Professional/Expert & Broadcom Knight
------------------------------