MongoDB issue - AS_Queue not matching AppInfos

Question

Hi,

I'm connecting to AppInfos (DB: AlteryxGallery) using the MongoDB connect tool and can see a column named 'TotalRunCount' which shows the 'Count of all runs across all workflow versions.' as per MongoDB schema (https://help.alteryx.com/current/server/alteryxgallery-mongodb-schema).

For one of my workfllows on the server,  the 'TotalRunCount'  is 40 based AppInfos. and this is back up based on what the front end of server shows.

I want to drilldown into the 40 to see who these people were that ran the workflow on server. I thought this would be possible using AS_Queue collection in MongoDB (DB: AlteryxService) but for some reason, AS_Queue displays just 10 records for this workflow indicating 'runs'.

Am I missing something here?

Thanks,
Kris

jamielaird · Answer

Glad you got to the bottom of this @kmedici . I definitely learned a bit about the MongoDB tables in the process!

kmedici · Answer

@jamielaird, I thought I'd let you know that as part of the roll out of our organisations Alteryx Server, the MongoDB wasn't fully implemented until June 2020. Therefore any 'runs' prior to this date would not be in there, we're considering this as one of the main reasons for the difference. As more recent workflows seem to match in AppInfos vs. Alteryx Sever front end. Thanks.

jamielaird · Answer

That does seem strange. I think the next best step is to raise a ticket with Alteryx Technical Support and they should be able to have someone take a deeper look into this. If you can provide screenshots and extracts of the logs in your request I’m sure that will help them diagnose the issue.