Un-Blobbing MongoDB results OutputLog

Question

So I am connecting to our Alteryx MongoDB (2023.2 patch 3) via odbc connection and I am wanting to access the outputlog for the jobs, However the log is stored as a Blob in "Binary format" and I am wondering if there is an easy way to extract the logs, all of the settings in the Blob convert tool haven't been working for me.

dv735 · Answer

Thank you for response and copy of macro. Unfortunately, I get errors in the first two steps of the macro.

patrick_digan · Answer

@venza @Kmaclean @dv735  I'm attaching the Service Data Parser macro here that still works on 23.2 for fields like the OutputLog in the ASResults table

ServiceDataParser.yxmc

venza · Answer

Hello,

There is no Alteryx Server Usage Report for the 2023.2.X version listed on the download site, where can we find it ?