Queues - Bot run stats

[A_Learner]

Hi,
While using data table, I log into a text file named stats how many rows were successful or threw Business exception etc. How to capture stats using Orchestrator queues? Can you provide an example please? Thanks

[vrdabberu (Varunraj)]

HI @A_Learner

Please check the below thread:

When to use activities of queue

@Qi_Wu Queue is a best practice where you can get the information when you are using UnAttended Bots and know their information If you have more data to process, then if your client ask to separate the Failed and Successful report then you can easily get that report from the orchestrator You can store in Excel also, but you need to build your own logic, which will takes more time than Queue implement Mark as solution if this helps Thanks

How to get data from orchestrator queue

@sruthesanju Please check the flow…I guess you missed incrementing or the condition might be wrong [image] [image] in the assign after for loop - counter = counter + qulsitems.count In Get queue items [image] cheers

Regards

[mkankatala (Mahesh Kankatala)]

Hi @A_Learner

Could you be more specific, give me the more information then only we are able to give a solution for this query.

[A_Learner]

Using queues, how do I capture transaction status for example how many are succesful, how many got into Business Exception, how many system exceptions, what is the bot run time etc.

Thank you,

[vrdabberu (Varunraj)]

Hi @A_Learner

You can use Get Queue Items acitivity. The output is IEnumerable(System.String). Use the output of Get Queue Items in For Each and you can currentItem.Status which will give status of current transaction item. In the body of For each give the Else If condition and then give the counter so that the count of Succesful, Business,System can be occured.

In the coditions you can give as

currentItem.Status.ToString.Contains("Succesful")

For getting Bot run time,
In the starting of the flow i.e at Init State assign StartTime= Now and and End process assign EndTime= Now.
Use the below syntax in assign:
timeDiff= EndTime-StartTime
timeDiff is of DataType System.TimeSpan
you can print the timeDiff variable in Log message by below way:

"Total time taken by the process: "+timeDiff.ToString("hh\:mm\:ss")