topic Re: extract data in Log Analytics

Extract data from XML log

marusla — Wed, 17 Dec 2025 13:53:29 GMT

I have an XML log that have a some line that starts with error. I want a extract that data, I don't know how to do it? i think maybe extract each in different columns but if some log have 2 and other 5 error line?

Re: extract data

dannemca — Thu, 18 Sep 2025 19:35:12 GMT

I believe the best option would be to parse the XML and then extracting the data you need for filtering.

https://docs.dynatrace.com/docs/discover-dynatrace/platform/grail/dynatrace-pattern-language/dpl-xml

Could you provide some dummy example of the data so we can provide you some DQL example?

Re: extract data

marusla — Thu, 18 Sep 2025 19:54:33 GMT

this is the data, i want to capture all the data that start with Error.Mensaje.Web

en System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage()
en System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke()
en Error.Mensaje.Web.InformacionService.IInformacionService.Consulta(String mid)
en Error.Mensaje.Web.Code.General.Comercio.compra en C:\Github\Code\General\ComercioCode.cs:línea 2561
en Error.Mensaje.Web.Controllers.General.InformacionController.ConsultarInformacionComercio(String mid) en Github\Code\General\ComercioCode.cs:línea 125

Re: extract data

marusla — Thu, 18 Sep 2025 21:31:30 GMT

sorry its a stack trace records

Re: extract data

dannemca — Fri, 19 Sep 2025 19:51:45 GMT

Could you paste the full content from one line of your current dql query? This does not look like a XML.

We will need to take a look at the full content in order to suggest a DQL you can try.