topic Re: Need help with dyntrace query in DQL

Need help with Dynatrace query

ramchandgadde — Mon, 14 Jul 2025 09:53:46 GMT

I am struggling to extract Process, Process_Type and Status from below Dynatrace query. Could you please help.

data record(content="[INFO][WORKDAY][DYNATRACE] 2025-07-11 17:00:10.696 Integration_Activity_API_response {'Report_Entry': [{'Status': 'Completed', 'Messages_group': [{'Message_Text': 'Input file missing', 'Severity': 'Warning'}], 'Submitted_by_User': 'ABC', 'Messages': 'Input file missing', 'Process_Type': 'Integration', 'Process': 'Inbound', 'Created_Date_and_Time': '2025-07-11T09:56:00-07:00', 'Number_of_Errors': '0', 'Submitted_by_Person': 'Julie Ceccacci', 'Number_of_Warnings': '1', 'workdayID': 'ec2f2365ec4b100206365e8c61600000', 'Actual_Start_Date_and_Time': '2025-07-11T09:56:00-07:00', 'Processing_Time__hh_mm_ss_': '00:00:34'}]}")
| filter contains(content, "Integration_Activity_API_response")

Re: Need help with dyntrace query

Emm4nuel — Fri, 11 Jul 2025 20:56:36 GMT

You need to parse the content, add this to your query:

| parse content, """LD 'Status\': \'' WORD:Status LD 'Process_Type\': \'' WORD:Process_Type LD 'Process\': \'' WORD:Process"""

Your final query:

data record(content="[INFO][WORKDAY][DYNATRACE] 2025-07-11 17:00:10.696 Integration_Activity_API_response {'Report_Entry': [{'Status': 'Completed', 'Messages_group': [{'Message_Text': 'Input file missing', 'Severity': 'Warning'}], 'Submitted_by_User': 'ABC', 'Messages': 'Input file missing', 'Process_Type': 'Integration', 'Process': 'Inbound', 'Created_Date_and_Time': '2025-07-11T09:56:00-07:00', 'Number_of_Errors': '0', 'Submitted_by_Person': 'Julie Ceccacci', 'Number_of_Warnings': '1', 'workdayID': 'ec2f2365ec4b100206365e8c61600000', 'Actual_Start_Date_and_Time': '2025-07-11T09:56:00-07:00', 'Processing_Time__hh_mm_ss_': '00:00:34'}]}") | filter contains(content, "Integration_Activity_API_response") | parse content, """LD 'Status\': \'' WORD:Status LD 'Process_Type\': \'' WORD:Process_Type LD 'Process\': \'' WORD:Process"""

Review the screenshot I attached, now your fields are parsed:

Re: Need help with dyntrace query

ramchandgadde — Fri, 11 Jul 2025 22:55:58 GMT

thank you so much.