MongoDB Input usageReport Types/Tool names

Question

Hi all,

I am hoping to make use of the MongoDB usageReports collection to do some reporting on Alteryx Designer usage. The incoming data contains a "Type" column which determines the type of usage data being presented. I have found a description of these types on the AlteryxGallery MongoDB Schema page, but when I make the query myself, I receive types 17 and 19 which are not listed on this page. Is anyone aware of what these types represent?

My second question is regarding the data for individual tool usage - I am trying to report on the frequency of tool/tool palette usage, but some of the JSON values being returned are not clear as to what tool they are referencing. They are:

AlteryxBasePluginsGui.DbFileInput.DbFileInput
AlteryxBasePluginsGui.DbFileOutput.DbFileOutput

AlteryxGuiToolkit.GenericTool.GenericTool
AlteryxGuiToolkit.HtmlBox.HtmlBox
AlteryxGuiToolkit.Questions.Tab.Tab

Could anyone tell me which tools these represent?

Any help is much arppreciated.

GGodfrey · Answer

If anyone is interested, I have been informed by Alteryx support that the page detailing the MongoDB schema for the usageReports collection is out of date:

The correct list of possible Type values for this collection is as follows:

marcusblackhill · Answer

Thanks for sharing your finds @GGodfrey !

GGodfrey · Answer

I have logged a support call regarding my 1st question and am waiting to receive a response. I will be sure to update here with any new findings.

As for my 2nd question, I managed to find a resource within the Alteryx Server usage report macro that has a mapping from the tool name within the MongoDB logs (i.e. AlteryxBasePluginsGui.DbFileInput.DbFileInput) to the tool palette the tool is contained in. I have gone through this list and included some missing tools (new tools, CReW macros etc.), amended the tool palette field mapping (there were several incorrect values), and created a Tool Name field where possible which I have verified by placing specific tools and then checking the log files to confirm the name held within MongoDB. For anyone interested, here is the Excel file I have created with these mappings.

MongoDB_ToolName_Mappings.xlsx