How can I query Collections, workflows, ADUsers and User groups from MongoDB ?

Question

Hi,

I am looking to prepare a workflow by connecting to Mongo DB and pull the information which we have in the Alteryx gallery for Collections, workflows, ADUsers and User groups.

How can we pull this information?

I am able to build the workflow to pull in the information for CollectionName, WorkflowName and ADUsers available, but I am not able to get the UserGroups associated with those collections.

Attached is the workflow I prepared to get the information I am looking for. Only thing I need here is to pull the UserGroups associated with those collections.

Collections.PNG

Collection-Workflows_Info_latest.yxmd

jrgo · Accepted Answer

That information is included in the MongoDB collection (table) you're reading from. Documentation says that data structure is similar to what you'd find within the "Users" column, but I believe it won't include all the details you may be looking for.

You may have to add another MongoDB Input and pull in "userGroups" and join that to what you pulled from the "collections" table.

You should also take a look at getting this information from the Server API service. There's also a tool you can download/install from the Marketplace to help design a workflow to interact with the API.

oyes2704 · Accepted Answer

Hi @Aparanjith_DSG ,

there's great MongoDB schema documentation here: https://help.alteryx.com/current/en/server/configure/mongodb-management/mongodb-schema-reference/alteryxgallery-mongodb-schema.html

Collections tale will have field:

* UserGroups: (Array) Array containing info on the user groups the collection is shared with. The data structure is the same as Users

Then you should look into the UserGroups table for the references.

Best,

Oly