As an admin how to check workflow status runs successfully or not in Alteryx server

[Piyali417]

as an admin how to check workflow status runs successfully or not in Alteryx server not gallery?

which collection we should use, and which column will give that info - from mongo db database

[gawa]

@Piyali417 

Under Alteryx Service database, you can check AS_Queue or AS_Results.They typically have enough information.

For detail, check the schema of mongo db in official help site.

Please note that schema changes across version of Alteryx Server, so please refer to the corresponding site of version you use. 

https://help.alteryx.com/20232/en/server/configure/mongodb-management/mongodb-schema-reference/alter...

[Piyali417]

@gawa  I checked with "As_result" collection - not giving workflow status,

"As_Queue" - collection giving you status column but this field not giving appropriate result.

For example, I publish the any workflow to the gallery, and I did some mistake knowingly whether it can be uploaded to the gallery noted that in the gallery it is showing but it comes with exclamation sign with "Completed with error" , but in the server its showing completed in the status column it should be showing like "Error"