topic Re: How to extract field from source path? in Dashboards & Visualizations

How to extract field from source path?

Mrig342 — Fri, 09 Jun 2023 12:36:12 GMT

Hi All,

I want to extract few fields available in the source path. For e.g. the source path is:

/apps/stats/domain/miccep3_mic_ce_sit/4.1/tra/domain/miccep3_mic_ce_sit/application/logs/Host_MediationServices_STE4_0-1-HOST_MediationServices_4_Host_MediationServices_CSAWC.log

Here I want to capture below 3 details:

1. From "/apps/stats/domain/miccep3_mic_ce_sit" part --- Need to capture "miccep3_mic_ce_sit" as "Domain_Name"

2. Need to capture "/apps/stats/domain/miccep3_mic_ce_sit/4.1/tra/domain/miccep3_mic_ce_sit/application/" part of the source path as "Application_Path"

3. After /logs directory in the path I want to capture the part "Host_MediationServices_STE4_0-1" as "Application_Name"

Please help create a query to capture the above fields from the source path.

Your kind help is highly appreciated.

Thank You..!!

Re: Need to extract field from source path

gcusello — Fri, 09 Jun 2023 06:02:36 GMT

Hi @Mrig342,

answering to your questions:

| rex field=source "^\/\w+\/\w+\/\w+\/(?<Domain_Name>\w+)

that you can test at https://regex101.com/r/l7KjrG/1

| rex field=source "^(?<Application>.+application)\/"

that you can test at https://regex101.com/r/l7KjrG/2

| rex field=source "^.*logs\/(?<Application_Name>.*)-HOST"

that you can test at https://regex101.com/r/l7KjrG/3

this is the hardest because there are chars (like - that are special chars so I cannot take using \w, this regex runs if there's always the word "HOST" in your path.

Ciao.

Giuseppe

Re: How to extract field from source path?

Mrig342 — Mon, 12 Jun 2023 07:39:48 GMT

Hi @gcusello ,

Thank you for your inputs.. The above queries helped me getting my expected field values.

Your kind help is highly appreciated.

Thank you very much..!!