topic RE: Extract previous day's queue data using AutomateC in Digital Exchange https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59516#M1855 Perfect !! Thanks bro<BR /><BR />All set to schedule my batch jobs <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />Thank you<BR /><BR />------------------------------<BR />Varun Puthan Veetil<BR />Technical Lead<BR />nbn<BR />Australia/Sydney<BR />------------------------------<BR /> Tue, 17 Nov 2020 08:13:00 GMT VarunPuthan_Vee 2020-11-17T08:13:00Z Extract previous day's queue data using AutomateC https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59512#M1851 Hi Experts,<BR /><BR />I am looking for an option to extract blueprism queue data for the previous day using AutomateC (which currently is being performed manually via control Room). I have gone through some of the online posts to try and understand the command syntax.&nbsp;<BR /><BR />Would someone please help me figure out the command for it in automateC with last 24 hours filter added.<BR /><BR />Tried (No luck)<BR />automatec.exe /sso /exportqueue "QueueName"<BR />No queue filter specified: exporting all queue items without filtering<BR />No queue specified: /exportqueue must be accompanied by /queuename<BR /><BR />Tried (No luck)<BR />automatec.exe /sso /exportqueue /queuename "QueueName"<BR />Bad command line arguments: argument missing for parameter '/exportqueue'.<BR /><BR />TIA<BR /><BR />------------------------------<BR />Varun<BR />------------------------------ Tue, 17 Nov 2020 00:58:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59512#M1851 VarunPuthan_Vee 2020-11-17T00:58:00Z RE: Extract previous day's queue data using AutomateC https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59513#M1852 Try this:<BR />.\Automatec.exe /sso /queuename '<STRONG>queue-name</STRONG>'&nbsp; /exportqueue '<STRONG>C:\Test vdi\report.csv</STRONG>'<BR /><BR />------------------------------<BR />PASHUPATI NATH MISHRA<BR />------------------------------<BR /> Tue, 17 Nov 2020 06:46:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59513#M1852 PASHUPATI_NATHM 2020-11-17T06:46:00Z RE: Extract previous day's queue data using AutomateC https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59514#M1853 Thanks mate. Tired it on a small queue and it works like a charm.<BR /><BR />Any idea how can we add filters, lets say only export last 24 hours of data ?<BR /><BR />Many Thanks<BR /><BR />------------------------------<BR />Varun Puthan Veetil<BR />Technical Lead<BR />nbn<BR />Australia/Sydney<BR />------------------------------<BR /> Tue, 17 Nov 2020 07:50:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59514#M1853 VarunPuthan_Vee 2020-11-17T07:50:00Z RE: Extract previous day's queue data using AutomateC https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59515#M1854 Great <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />1st create a filter in Blueprism queue management. for example apply filter on "Created"&nbsp; to last 24 hours.<BR />save that filter with any name(i.e: <STRONG>appliedFilterName</STRONG>).<BR /><BR />2nd: use this cli command:<BR /><SPAN>.\Automatec.exe /sso /queuename '</SPAN><STRONG>queue-name</STRONG><SPAN>'&nbsp; /queuefilter <STRONG>appliedFilterName</STRONG> &nbsp;/exportqueue '</SPAN><STRONG>C:\Test vdi\report.csv</STRONG><SPAN>'<BR /><BR /><BR /></SPAN>So you can create as many filters in BluePrism application and use that in cli string.<BR /><BR /><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />------------------------------<BR />PASHUPATI NATH MISHRA<BR />------------------------------<BR /> Tue, 17 Nov 2020 07:59:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59515#M1854 PASHUPATI_NATHM 2020-11-17T07:59:00Z RE: Extract previous day's queue data using AutomateC https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59516#M1855 Perfect !! Thanks bro<BR /><BR />All set to schedule my batch jobs <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />Thank you<BR /><BR />------------------------------<BR />Varun Puthan Veetil<BR />Technical Lead<BR />nbn<BR />Australia/Sydney<BR />------------------------------<BR /> Tue, 17 Nov 2020 08:13:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59516#M1855 VarunPuthan_Vee 2020-11-17T08:13:00Z RE: Extract previous day's queue data using AutomateC https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59517#M1856 Awesome <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />------------------------------<BR />PASHUPATI NATH MISHRA<BR />------------------------------<BR /> Tue, 17 Nov 2020 08:16:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Extract-previous-day-s-queue-data-using-AutomateC/m-p/59517#M1856 PASHUPATI_NATHM 2020-11-17T08:16:00Z