Extract data of MSISDN with multiple IMSI

[kumarv21]

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 .

fetch logs,scanLimitGBytes:-1
| filter dt.system.bucket=="engineering" and index == "AB"
| filter Market == "NA"
|filter IMSI=="1800189"
|filter isNotNull(MDN) and MDN != 0
|fields DEG_MDN

output -:

MDN

8634####

[Julius_Loman]

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

[kumarv21]

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 .

[Julius_Loman]

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

Maybe you need to summarize with collectDistinct ?

[kumarv21]

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 .

Date |HTTPS|OUT|0|DEG_MDN| IMSI |someAPIName|SessionID| DEG_MDN=numericMDN