See if these resources help:
1) The Alteryx Server Usage Report can be downloaded from the Licensing Portal
2) How can I query Collections, workflows, ADUsers and User groups from MongoDB ?
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-can-I-query-Collections-wo...
3) Extracting From Mongo & Building a Custom Gallery Usage Report
Community > Groups & Events > Inspire Presentations > Extracting From Mongo & Building a Custom Gallery Usage Report
08-29-2021
https://community.alteryx.com/t5/Inspire-Presentations/Extracting-From-Mongo-amp-Building-a-Custom-G...
4) Go to help > Sample Workflows > Use Scripting and Automation Tools > Build a Macro > Identify tools and macros used in a workflow
5) Check out Community > Blogs > Engine Works Blog > Auto Documentation
The story of the community-driven initiative to create an app that documents the contents of an Alteryx workflow
https://community.alteryx.com/t5/Engine-Works-Blog/Auto-Documentation/ba-p/344528
6) WAM (Workflow Admin Manager) from Capitalize Consulting (requires additional license)
https://capitalizeconsulting.com/workflow-admin-manager/
Hi @ArnabB
As well as @ChrisTX's exhaustive list you can also look into the server API. It does require curator access but any of the mongoDB options require privileged access as well. There's also a Macro pack that wraps a lot the details to make the API a little easier to use.
Dan