Viewing AppID in Desktop Designer?

Question

If I understand what's happening correctly an app doesn't get an AppID until it is published to Server, and you can see it when going to the Gallery and viewing that workflow's page and the AppID is displayed in the URL. I understand if you save a revision back up to Server it changes the AppID. The AppID is not immutable for a single workflow on Server as the revisions accumulate.

If you open an app from Gallery on Desktop Designer by opening from Self Service, is there any way to see what the AppID that Server currently has assigned to that app?

I searched Google and didn't find any docos or forum posts answering this question other than look in the URL on Gallery.

We've had a bad habit or accidents of allowing asset names to be duplicated, and now our company is working on an automated migration of a particular data source in all of our workflows. Our Aleryx operations group wants us to do a cleanup marking which workflows are duplicates, and which need an automated migration versus being retired. So that's the end goal - to help us use our report of asset names and AppIDs so we can be confident we are looking at the same app as we open them on Gallery and in Designer, to review the workflow and make decisions.

Thanks.

ColinG · Answer

Unfortunately our Server Administration Team doesn't provide configuration information or allow access to any Server infrastruture resources. Our whole environment is pretty locked down. If it isn't visible in Designer or on the Gallery page we can't collect that info. They do an extract to Tableau of some information from the Server MongoDB that I can download to Excel. But part of the problem is aligning the list of duplicative asset names on that list, with their changing AppIDs as we continue our normal operation, to look those specific apps up in Gallery and Designer and review which of the multiple revisions (that exist as independent workflows but identically named on Server) to determine what we want to keep or discard. It's like trying to play whack a mole.

Yoshiro_Fujimori · Answer

Hi @ColinG ,

You may want to look into Mongo DB {Database:AlteryxGallery, Collection:appInfos}.

https://help.alteryx.com/20223/en/server/configure/mongodb-management/mongodb-schema-reference/alteryxgallery-mongodb-schema.html#idp112144

(make sure you see the page for your Server version.)

It keeps the history of all workflow revisions etc.

If a workflow is revised frequently, the output may have many columns, and you need to check the DateCreated to get your desired version.

You can access to the Server MongoDB with MongoDB Input Tool.

https://help.alteryx.com/current/en/designer/tools/connectors/mongodb-input-tool.html#idp368462

I hope this helps.