How to get status report from queues

Help Orchestrator
, , , , ,
1

Hi everyone,

I want to download the status report from orchestrator of my queues which are processed today either success or failed. I want to do this with studio activities. I want to get the status report my queues into Excel and i want to send an email. How to get the queue report into Excel. Can anyone help me on this.

2

@Learner007

Please check this detailed explanation .If there are further questions please do feel free to ask here…In get queue items you have filter on addition and processing. Time can use them to filter as you need

Cheers

1 Like
3

Thanks @Anil_G will check this. If i have any doubts will get back to you.

1 Like
4

@Anil_G is there any option to write all data into Excel without looping the queue output in for each. If i have large data means it will take time right.

5

@Learner007

If you need a consolidated report not the individual items then you can use this api…which gives computed results

<OrchestratorURL>/swagger/index.html#/QueueProcessingRecords/QueueProcessingRecords_RetrieveLastDaysProcessingRecordsByDaysnoAndQueuedefinitionid

But if you need the details like status …exception details… output data and specific content then you need to use loop…one way you can try is to use orchestrator api again to get the info …which gets data in chunks of 1000 and get queue items gets items in chunks of 100…

But in both the ways use of for loop is needed…and if running from studio it might take much time…but you would see a high computation time difference when running from orchestrator on the bot

Apart from that you can as well try using json converted to convert the data to datatable…but again …you need to convert each separately and then club the data together on sheet again to make it complete…this is not much preferred as you are looking for daily report and this would make the design little complex

Or final option is you can use this api again which ahs less customization in terms of columns

<orchestratorurl>/swagger/index.html#/QueueDefinitions/QueueDefinitions_ReportsById

Cheers

6

Ok thanks @Anil_G i will try both what ever feasible i will use that.

1 Like
7

@Learner007

Added one more in the above list the reports api

Cheers

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.