I would like to know if there is a way to get like a report of all the scheduled workflows and if it is possible to know at what time as well. I tried to use the "Workflows in waiting state" schema but I realize that workflows that uses an "external signal" are also coming and I dont want them on the report.
I have similar type of requirement very recently. Two attribute can help you. Go to xtk:workflow and apply filter on column Status (@state) = 'Started' and in output you can have workflow internal name, label and Next processing (@nextProcessingDate) to check the desired result. Please note you will get the workflow name where you are running this query as well, because this workflow will be in started, hence you can exclude this wf.