Message Tool In Server - Pull for Usage Report

reagantw

I'm using the Message tool inside a chained app to log the number of total pages being read in within a directory. I've published the chained app and it is being utilized currently.

On Designer I can see that the messages are being exported to the Output Window. If I wanted to see these messages and query them from our Server Mongo DB, what database and collection would I pull from (AlteryxGallery, AlteryxService, etc.)?

jrgo

The message log is captured in DB "AlteryxService", collection "AS_Results". The log is in the "__ServiceData" field which as you'll notice, is a binary value. If you download the Alteryx Server Usage Report app, the macros contained within it does show how convert it back to text. Note that this app has been deprecated, but I think is still available to download from the license/download portal. Last "Alteryx Server" version it was available to download with was 2022.1.

Alternatively, you can enable engine logging in the Alteryx Server Settings util by specifying a logging path. This will write out a text file that includes the message log for every job the server executes. Not as elegant of a solution, but will get you your message logs.