Can the Dynatrace Workflow run a DQL query and export the output to a PDF or Excel file, then email the report as an attachment?

[Akhil-Jayendran]

Hello Team ,

Currently, we’ve tested a basic workflow that runs a DQL query and sends an email. However, we’re looking to find out if there’s a feature within Dynatrace Workflows that allows sending the query results as a formatted report, preferably attached as an Excel or CSV file. Has anyone already experimented with this?

Thank you!

[Kenny_Gillette]

I was wondering same thing.  You could send a link Via Workflow to dql dashboard then user could download result.  I have set that up.

[Akhil-Jayendran]

Hi @Kenny_Gillette ,

Thank you for this. This is one of the options we currently have, but I was wondering if we can also attach files to emails, as some existing tools already support this feature.

[StrangerThing]

I would love to do something similar but with a pdf of a dashboard.

[Julius_Loman]

Very good idea, in general, this is of course possible, by developing a custom workflow action ( see https://developer.dynatrace.com/develop/workflows/create-custom-action/ ), but it needs some JavaScript  / React developer knowledge.

[Akhil-Jayendran]

Hi @Julius_Loman ,
I also strongly believe this can be achieved using JavaScript or React. Since my Java skills are quite poor, my hope is that if someone here has already developed a similar solution, I could ask for their help or request them to share the code. 😅