topic Re: Extract data of MSISDN with multiple IMSI in DQL

Extract data of MSISDN with multiple IMSI

kumarv14 — Fri, 19 Dec 2025 14:02:38 GMT

Hello all ,

i am new for DQL so i am trying to extract data of MSISDN against the IMSI where i have multiple IMSI , so is there any way so that query take IMSI and extract the MSISDN against those IMSI in one go .

output -:

MDN

8634####

Re: Extract data of MSISDN with multiple IMSI

Julius_Loman — Fri, 19 Dec 2025 14:21:14 GMT

Can you please elaborate more on that and provide a sample of the log record?

Re: Extract data of MSISDN with multiple IMSI

kumarv14 — Fri, 19 Dec 2025 14:28:20 GMT

i am getting msisdn with this query but i have multiple imsi so wants to get msisdn in one go is it possible ? PFA the snap .

Re: Extract data of MSISDN with multiple IMSI

Julius_Loman — Fri, 19 Dec 2025 14:33:29 GMT

I'm still not sure what you need and, most importantly, how the source data looks like.

Maybe you need to summarize with collectDistinct ?

Re: Extract data of MSISDN with multiple IMSI

kumarv14 — Fri, 19 Dec 2025 14:56:12 GMT

basically simple thing on behalf of IMSI i am trying to extract MDN , but i have multiple IMSI so how can i check MDN details , it extracted by manual process but when we have IMSI in 1K range then not possible to get MDN against the IMSI.

Logs format -:

Here numericMDN(real numeric MSISDN) due to some compliance i can not upload real logs . logs are pipe separated .

Re: Extract data of MSISDN with multiple IMSI

krzysztof_hoja — Mon, 22 Dec 2025 13:22:33 GMT

to filter by multiple values you can use in() function, like:

|filter in(IMSI, {"1800189", "1800188", "1800187"})

If you want to know which DEG_MDN belong to which IMSI, just leave both fields in output:

|fields DEG_MDN, IMSI

https://docs.dynatrace.com/docs/discover-dynatrace/platform/grail/dynatrace-query-language/functions/general-functions#in

Wants to get unique IMSI against the specific API

kumarv14 — Thu, 15 Jan 2026 12:15:37 GMT

Hello All,

Happy new year , hope you all are doing well . i wants to get result of unique IMSI against the specific API i have this query and getting some result so can you suggest me if any other option to get best results.

note -- IMSI is a field here ,that one i wants to get distinct count for the same.

2695384

Re: Extract data of MSISDN with multiple IMSI

kumarv14 — Thu, 15 Jan 2026 12:57:50 GMT

Hello All,

note -- IMSI is a field here ,that one i wants to get distinct count for the same.

2695384

Re: Extract data of MSISDN with multiple IMSI

kumarv14 — Thu, 15 Jan 2026 12:58:31 GMT

Hello All,

note -- IMSI is a field here ,that one i wants to get distinct count for the same.

2695384