https://community.blueprism.com/t5/Product-Forum/Querying-DecipherServerDB-for-Batch-Status/m-p/74533#M27138 James<BR /><BR />Many thanks for taking the time to look into this for me.&nbsp; It is much appreciated.<BR /><BR />------------------------------<BR />Howard Blake<BR />RPA Development Lead<BR />Sopra Steria<BR />Europe/London<BR />------------------------------<BR /> Wed, 26 May 2021 10:25:00 GMT HowardBlake 2021-05-26T10:25:00Z https://community.blueprism.com/t5/Product-Forum/Querying-DecipherServerDB-for-Batch-Status/m-p/74531#M27136 Is there a sql query that can be used to directly query the DecipherServerDB to return the status of a given Batch ID (as shown in the attachment?&nbsp; I would like to monitor statuses other than just '<SPAN>Capture performed - ready for Verify' which is returned via Decipher VBO - Has Batches To Verify action<BR /><BR />I have taken a look at the tables in DecipherServerDB but could not find a suitable table that returns the Batch Status.</SPAN><BR /><BR />------------------------------<BR />Howard Blake<BR />RPA Development Lead<BR />Sopra Steria<BR />Europe/London<BR />------------------------------<BR /> Tue, 25 May 2021 14:08:00 GMT https://community.blueprism.com/t5/Product-Forum/Querying-DecipherServerDB-for-Batch-Status/m-p/74531#M27136 HowardBlake 2021-05-25T14:08:00Z https://community.blueprism.com/t5/Product-Forum/Querying-DecipherServerDB-for-Batch-Status/m-p/74532#M27137 I've done some experimentation and found that the Status in the image you've shown likely corresponds to the Batch.Flags column.<BR /><BR />From what I can tell:<BR />In OCR, flag=1<BR />Classify performed - ready for ClassVerify, flag=419<BR />In Class Training..., flag=262147<BR />In Data Capture, flag=427<BR />Capture performed - ready for Verify, flag=443<BR /><BR />This is by no means a complete list of the flags, so you would need to doublecheck the flag columns against what you see in the Admin Panel, Batches page.&nbsp;<BR /><BR />Please double check if this gives the correct result on your end, as I've only arrived at this based on actually pushing documents into Decipher, refreshing the Batches page in the Admin Panel, and monitoring the database to see what data has changed. There's also no guarantee that the flags will remain the same for future versions of Decipher.<BR /><BR /><BR /><BR />------------------------------<BR />James Man<BR />Professional Services<BR />Blue Prism<BR />Asia/Hong_Kong<BR />------------------------------<BR /> Wed, 26 May 2021 03:27:00 GMT https://community.blueprism.com/t5/Product-Forum/Querying-DecipherServerDB-for-Batch-Status/m-p/74532#M27137 james.man 2021-05-26T03:27:00Z https://community.blueprism.com/t5/Product-Forum/Querying-DecipherServerDB-for-Batch-Status/m-p/74533#M27138 James<BR /><BR />Many thanks for taking the time to look into this for me.&nbsp; It is much appreciated.<BR /><BR />------------------------------<BR />Howard Blake<BR />RPA Development Lead<BR />Sopra Steria<BR />Europe/London<BR />------------------------------<BR /> Wed, 26 May 2021 10:25:00 GMT https://community.blueprism.com/t5/Product-Forum/Querying-DecipherServerDB-for-Batch-Status/m-p/74533#M27138 HowardBlake 2021-05-26T10:25:00Z