• XSS.stack #1 – первый литературный журнал от юзеров форума

CSV T-Mobile

nightly

root@usss-int:~#
Premium
Регистрация
03.10.2019
Сообщения
376
Реакции
413
Легкий слив.
Код:
DEVICE_ID,IMEI
163238379,35642005335660
83357158,35642005333894
116341912,35188106543568
183976461,35990204248797
106702215,35302405500895
77761218,35801105424958
149204128,35188106764074
45129556,35588005385529
174524974,35891705039385

Скрытый контент для зарегистрированных пользователей.

У вас должно быть более 10 сообщений для просмотра скрытого контента.


Код:
-- MySQL dump 10.13  Distrib 5.5.62, for Linux (x86_64)
--
-- Host: ****************    Database: ********************
-- ------------------------------------------------------
-- Server version    5.7.17-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

Скрытый контент для зарегистрированных пользователей.

У вас должно быть более 10 сообщений для просмотра скрытого контента.


Screenshot from 2022-05-08 18-21-13.png


Код:
[GLOBAL]
AWS_Account_Name = tmocloud
AWS_Region =  us-east-1
ElasticSearchURL = prd-opr-sgc-elb-975759774.us-east-1.elb.amazonaws.com
ElasticSearchIndexToPost = asgc-all
ESIndexNameForAuditReport=asgc-audit
ProxyUserName = kibanaadmin
ProxyUserPass = kibana@123
[notifications]
virginia = arn:aws:sns:us-east-1:704890862880:admin-dl
oregon = arn:aws:sns:us-west-2:704890862880:admin-dl

[R19.DELETE_EBS.SEC_DELETE_EBS_VOLUME]
Flag = -1
duration = 48

[R3.NOTIFY.SEC_IAM_ADMIN_CREATION_NOTIFY]
admin = admin

[R18.DELETE_EC2.SEC_DELETE_EC2]
Flag = -1
duration = 48

[R21.DELETE_SG.SEC_DELETE_SECURITY_GROUP]
Flag = -1
duration = 48

[R6.NOTIFY_GROUP.SEC_PASSWORD_POLICY]
max_pwd_age = 90
min_pwd_length=15
pwd_reuse_prevention = 5
action = NOTIFY|COMPLETE
Flag = 1

[W7.WATCH_SG_CIDR.SEC_SECURITY_GROUP_GT_24]
cidr_count = 24
action = WATCH
Flag = -1

[R4_R5.NOTIFY_DELETE_USER_ON_NO_LOGIN.SEC_USER_NOT_LOGGED_IN]
duration_min_days = 60
duration_max_days = 90
action1 = NOTIFY|COMPLETE
action2 = NOTIFY|COMPLETE
Flag = -1


[R8_R9.NOTIFY_DELETE_ACCESS_KEY_NOT_ROTATED.SEC_RENEW_ACCESS_KEY]
duration1 = 30
duration2 = 90
action1 = NOTIFY|COMPLETE
action2 = NOTIFY|COMPLETE
Flag = -1
source_email_id = Sreeprasad.Kunjappan@T-Mobile.com

[R20.NOTIFY_GRP.SEC_SG_WITHOUT_NAMING_STANDARD]
name_std = ^(SG)-*
action = NOTIFY|COMPLETE
Flag = -1

[R15.NOTIFY_GRP.SEC_EC2_NO_NAMING_CONVENTION_FILTER]
name_std = ^(PRD|DEV|TST|SIT|UAT|PPD|PQA|COM|DMZ|TMP|PST|AUX|DRP|STG|REG|AUT|PPR)-(OPS|CIS|CIP|GRA|ODM|MYA|MPC|B2B|IAM|TXT|MID|RBL|SAP|SPK|OPS|CIS|CIP|GRA)-id(WEB|WES)-1[a-z]
action = NOTIFY|COMPLETE
Flag = -1

[R24.NOTIFY_GRP.SEC_SG_WITH_PORTS]
port = 2500
action = NOTIFY|COMPLETE
Flag = -1

[R16.NOTIFY_DELETE_EC2.SEC_EC2_NOTAG_INSTANCES_FILTER]
Flag = -1

[R17.NOTIFY_DELETE_EBS.SEC_EBS_VOLUMES_NOTAG_FILTER]
Flag = -1

[R10_R25.NOTIFY_DELETE.SEC_SG_WITH_ANYWHERE_SUBNET]
Flag = -1

[R6_R7.UPDATE_POLICY.SEC_PASSWORD_POLICY]
Flag = 1


[R30.STOPPED_INSTANCES_LIST_SNAP_DELETE]
Flag = -1
snapshot_after_days = 20
contact_tag = Contact
from_email = kamal.kumar20@t-mobile.com
delete_snapshot_threshold = 30



[R31.DELETE_EC2.SEC_EC2_KEY_STANDARD]
source_email_id = Sreeprasad.Kunjappan@T-Mobile.com
duration = 15
Flag = -1


Код:
{"event_id":"46ac20f4-2ea1-11eb-f51f-34769a263734","envelope_id":"46abd2d0-2ea1-11eb-f51f-34769a263734","schema_version":"1.4.7","envelope_timestamp":"2020-11-24T22:06:16.901+0000","received_timestamp":"2020-11-24T22:06:17.523+0000","device_surrogate":"subscriber.t1t59rXgdyAddgxkMgYOx_nMNWT1LXCJx2D6zKWGrts=","event_device_data":{"clientName":"com.tmobile.TMOAccess","deviceOs":"iOS","networkImsi":"310260248767725","advertisingId":"00000000-0000-0000-0000-000000000000","cnfFingerprint":"226cymrqZNt3lzVj+eYTmAVU6Kp71T6jeL2oEbDBn48=","deviceOsVersion":"14.2","imsi":"310260248767725","clientVersion":"4.29.0","ban":"952077625","ipv4":"192.168.101.186","postSequenceNumber":"3","oem":"Apple","networkMsisdn":"7737442398","oemId":"iPhone12,5","model":"iPhone12,5","msisdn":"7737442398","osLanguage":"English","deviceType":"subscriber","tmoid":"U-58a77bf3-91b5-419a-a6d0-6cd2d65e0423","numberOfLines":"7","envelope_id_source":"TC","accountType":"SY","accessToken":"02.USR.HNF81wMz2N6k2Xu24","idtMsisdn":"7737442398","envelope_timestamp_source":"TC"},"event_data":{"client_event_id":"38804914-027e-4e1c-9bcd-494e07751371","software_info":{"controller_id":"com.tmobile.TMOAccess.CardViewManager","client_version":"4.29.0@DEBUG","component_version":"4.29.0@DEBUG","analytics_sdk_version":"7.4.0@DEBUG","analytics_sdk_id":"com.tmobile.TMOAnalytics","component_id":"com.tmobile.TMOAccess","client_name":"com.tmobile.TMOAccess"},"component_id":"com.tmobile.TMOAccess.CardViewManager","page_identity":{"page_id":"/group/Account","page_uuid":"43c1aa66-f1e6-4455-896d-ac0e9fa926e9","page_type":"Native","fetch_uuid":"96cfd298-7423-45ea-94f1-ce9b8ddd39ba"},"session_info":{"activation_uuid":"6d85f798-ae54-4759-8e38-ec4213edff33","launch_uuid":"78abc6e8-8446-4446-945f-f43e5bdd3da8"},"do_not_sell_flag":false,"analytics_sdk":{"component_version":"7.4.0@DEBUG","component_id":"com.tmobile.TMOAnalytics"},"timestamp":"2020-11-24T22:06:09.643Z"},"timestamp":"2020-11-24T22:06:09.643+0000","event_type":"analytics.lifecycle.page_fetch_start","client_version":"4.29.0"}
{"event_id":"46ac20f5-2ea1-11eb-f51f-34769a263734","envelope_id":"46abd2d0-2ea1-11eb-f51f-34769a263734","schema_version":"1.4.7","envelope_timestamp":"2020-11-24T22:06:16.901+0000","received_timestamp":"2020-11-24T22:06:17.523+0000","device_surrogate":"subscriber.t1t59rXgdyAddgxkMgYOx_nMNWT1LXCJx2D6zKWGrts=","event_device_data":{"clientName":"com.tmobile.TMOAccess","deviceOs":"iOS","networkImsi":"310260248767725","advertisingId":"00000000-0000-0000-0000-000000000000","cnfFingerprint":"226cymrqZNt3lzVj+eYTmAVU6Kp71T6jeL2oEbDBn48=","deviceOsVersion":"14.2","imsi":"310260248767725","clientVersion":"4.29.0","ban":"952077625","ipv4":"192.168.101.186","postSequenceNumber":"3","oem":"Apple","networkMsisdn":"7737442398","oemId":"iPhone12,5","model":"iPhone12,5","msisdn":"7737442398","osLanguage":"English","deviceType":"subscriber","tmoid":"U-58a77bf3-91b5-419a-a6d0-6cd2d65e0423","numberOfLines":"7","envelope_id_source":"TC","accountType":"SY","accessToken":"02.USR.HNF81wMz2N6k2Xu24","idtMsisdn":"7737442398","envelope_timestamp_source":"TC"},"event_data":{"client_event_id":"b0f7af79-d88c-4e15-84cb-b53973728ff4","software_info":{"controller_id":"com.tmobile.TMOAccess.WebViewController","client_version":"4.29.0@DEBUG","component_version":"4.29.0@DEBUG","analytics_sdk_version":"7.4.0@DEBUG","analytics_sdk_id":"com.tmobile.TMOAnalytics","component_id":"com.tmobile.TMOAccess","client_name":"com.tmobile.TMOAccess"},"component_id":"com.tmobile.TMOAccess.WebViewController","page_identity":{"webview_url":"https://my.t-mobile.com/billandpay","page_id":"tmoapp-web://https://my.t-mobile.com/billandpay","page_uuid":"00e659cf-03df-4b7e-a4d5-c8fa6ffc554a","page_type":"Webview","fetch_uuid":"91715b6a-804f-43d5-8182-8efd002fdb77"},"session_info":{"activation_uuid":"6d85f798-ae54-4759-8e38-ec4213edff33","launch_uuid":"78abc6e8-8446-4446-945f-f43e5bdd3da8"},"do_not_sell_flag":false,"analytics_sdk":{"component_version":"7.4.0@DEBUG","component_id":"com.tmobile.TMOAnalytics"},"timestamp":"2020-11-24T22:06:09.670Z"},"timestamp":"2020-11-24T22:06:09.670+0000","event_type":"analytics.lifecycle.page_fetch_start","client_version":"4.29.0"}
{"event_id":"46ac4806-2ea1-11eb-f51f-34769a263734","envelope_id":"46abd2d0-2ea1-11eb-f51f-34769a263734","schema_version":"1.4.7","envelope_timestamp":"2020-11-24T22:06:16.901+0000","received_timestamp":"2020-11-24T22:06:17.524+0000","device_surrogate":"subscriber.t1t59rXgdyAddgxkMgYOx_nMNWT1LXCJx2D6zKWGrts=","event_device_data":{"clientName":"com.tmobile.TMOAccess","deviceOs":"iOS","networkImsi":"310260248767725","advertisingId":"00000000-0000-0000-0000-000000000000","cnfFingerprint":"226cymrqZNt3lzVj+eYTmAVU6Kp71T6jeL2oEbDBn48=","deviceOsVersion":"14.2","imsi":"310260248767725","clientVersion":"4.29.0","ban":"952077625","ipv4":"192.168.101.186","postSequenceNumber":"3","oem":"Apple","networkMsisdn":"7737442398","oemId":"iPhone12,5","model":"iPhone12,5","msisdn":"7737442398","osLanguage":"English","deviceType":"subscriber","tmoid":"U-58a77bf3-91b5-419a-a6d0-6cd2d65e0423","numberOfLines":"7","envelope_id_source":"TC","accountType":"SY","accessToken":"02.USR.HNF81wMz2N6k2Xu24","idtMsisdn":"7737442398","envelope_timestamp_source":"TC"},"event_data":{"client_event_id":"00cb9a95-98a2-469f-85c1-6ddef06367c2","software_info":{"controller_id":"com.tmobile.TMOAccess.WebViewController","client_version":"4.29.0@DEBUG","component_version":"4.29.0@DEBUG","analytics_sdk_version":"7.4.0@DEBUG","analytics_sdk_id":"com.tmobile.TMOAnalytics","component_id":"com.tmobile.TMOAccess","client_name":"com.tmobile.TMOAccess"},"component_id":"com.tmobile.TMOAccess.WebViewController","page_identity":{"webview_url":"https://my.t-mobile.com/purchase/shop","page_id":"https://my.t-mobile.com/purchase/shop","page_uuid":"482a30be-723b-4d5b-846c-c9a935ebb72a","page_type":"Webview","fetch_uuid":"c34f140d-3846-409f-88e7-94656c1632ac"},"session_info":{"activation_uuid":"6d85f798-ae54-4759-8e38-ec4213edff33","launch_uuid":"78abc6e8-8446-4446-945f-f43e5bdd3da8"},"do_not_sell_flag":false,"analytics_sdk":{"component_version":"7.4.0@DEBUG","component_id":"com.tmobile.TMOAnalytics"},"timestamp":"2020-11-24T22:06:09.676Z"},"timestamp":"2020-11-24T22:06:09.676+0000","event_type":"analytics.lifecycle.page_fetch_start","client_version":"4.29.0"}
{"event_id":"46ac4807-2ea1-11eb-f51f-34769a263734","envelope_id":"46abd2d0-2ea1-11eb-f51f-34769a263734","schema_version":"1.4.7","envelope_timestamp":"2020-11-24T22:06:16.901+0000","received_timestamp":"2020-11-24T22:06:17.524+0000","device_surrogate":"subscriber.t1t59rXgdyAddgxkMgYOx_nMNWT1LXCJx2D6zKWGrts=","event_device_data":{"clientName":"com.tmobile.TMOAccess","deviceOs":"iOS","networkImsi":"310260248767725","advertisingId":"00000000-0000-0000-0000-000000000000","cnfFingerprint":"226cymrqZNt3lzVj+eYTmAVU6Kp71T6jeL2oEbDBn48=","deviceOsVersion":"14.2","imsi":"310260248767725","clientVersion":"4.29.0","ban":"952077625","ipv4":"192.168.101.186","postSequenceNumber":"3","oem":"Apple","networkMsisdn":"7737442398","oemId":"iPhone12,5","model":"iPhone12,5","msisdn":"7737442398","osLanguage":"English","deviceType":"subscriber","tmoid":"U-58a77bf3-91b5-419a-a6d0-6cd2d65e0423","numberOfLines":"7","envelope_id_source":"TC","accountType":"SY","accessToken":"02.USR.HNF81wMz2N6k2Xu24","idtMsisdn":"7737442398","envelope_timestamp_source":"TC"},"event_data":{"client_event_id":"2ed1a49d-1c56-4820-8379-61666e14627d","software_info":{"controller_id":"com.tmobile.TMOAccess.CardViewManager","client_version":"4.29.0@DEBUG","component_version":"4.29.0@DEBUG","analytics_sdk_version":"7.4.0@DEBUG","analytics_sdk_id":"com.tmobile.TMOAnalytics","component_id":"com.tmobile.TMOAccess","client_name":"com.tmobile.TMOAccess"},"component_id":"com.tmobile.TMOAccess.CardViewManager","page_identity":{"page_id":"/group/More","page_uuid":"cbf1d07b-5616-4dce-9b04-0eb0950eb983","page_type":"Native","fetch_uuid":"5b23c2a7-9fe2-4f7c-b7df-1cb1cb1c0057"},"session_info":{"activation_uuid":"6d85f798-ae54-4759-8e38-ec4213edff33","launch_uuid":"78abc6e8-8446-4446-945f-f43e5bdd3da8"},"do_not_sell_flag":false,"analytics_sdk":{"component_version":"7.4.0@DEBUG","component_id":"com.tmobile.TMOAnalytics"},"timestamp":"2020-11-24T22:06:09.680Z"},"timestamp":"2020-11-24T22:06:09.680+0000","event_type":"analytics.lifecycle.page_fetch_start","client_version":"4.29.0"}


Код:
"NTID","Job Title","User Login","Hire Date","Term Date","Email Address","Cost Center","First Name","Last Name"
"HAlzeer","TPRi - Retail Store Manager","C30491950","2016-08-26","","Hussam.Alzeer@T-Mobile.com","4396","Hussam","Alzeer"
"CSeaman1","TPRi - Mobile Expert","C30199346","2016-08-26","","Cutter.Seaman1@T-Mobile.com","1439","Cutter","Seaman"
"LCherry2","TPR - Mobile Expert","C30039167","2016-08-26","","Loren.Cherry2@T-Mobile.com","2344","Loren","Cherry"
"NOrozco6","TPRi - Retail Store Manager","C30184511","2016-08-26","","Najely.Orozcochavez6@T-Mobile.com","585D","Najely","Orozco chavez"
...
"AThurma2","TPRi - Mobile Associate","C56644370","2019-12-11","2020-03-10","Arianna.Thurman2@T-Mobile.com","4267","Arianna","Thurman"
"KNguyen101","TPRi - Mobile Expert","C56322347","2019-12-12","2020-03-11","Kevin.Nguyen101@T-Mobile.com","1107","Kevin","Nguyen"
"JRed14","TPRi - Mobile Expert","C68238633","2019-12-12","2020-03-11","Justin.Red14@T-Mobile.com","756D","Justin","Red"
"JRogers130","TPRi - Mobile Expert","C84939014","2019-12-12","2020-03-11","justice[.]Rogers130@T-Mobile.com","1011","Justice","Rogers"
У вас должно быть более 10 сообщений для просмотра скрытого контента.

Код:
Personnel Number,First Name,Last Name,Job Title,Work Location ID,Hire Date,Term Date,Email Address,NTID
"000392233","Robert","Michelman","S-President 1Million Project","","05/07/2020","31/12/9999","Doug.Michelman@1millionproject.org","wd325430"
"100031667","Edwin","Rivas","Mobile Expert, Bilingual","4SEM","25/06/2020","31/12/9999","Edwin.Rivas@sprint.com","wa106313"
"000304058","Christine","Powell","B2B_BO Program Manager","","02/07/2020","31/12/9999","Christine.Powell@1millionproject.org","ch304058"
...
"100031832","Alyssa","Cruz","Mobile Expert","1SOT","25/06/2020","31/12/9999","Alyssa.Cruz@sprint.com","pi250786"
"000251844","Pinalkumari","Tailor","S-MGR TELECOM DSGN ENGRNG","","25/06/2020","31/12/9999","Pinalkumari.Tailor@sprint.com","pi251844"
"100033774","Brianna","Waters","S-ADV TECH SUPT SPEC TIC","","25/06/2020","31/12/9999","Brianna.Waters@sprint.com","pi735362"
"100033034","Benny","Diaz","Mobile Expert","1SLI","25/06/2020","31/12/9999","Benny.Diaz@sprint.com","pi776746"
"100033002","Monica","Alvarado","Mobile Expert, Bilingual","4SBU","25/06/2020","31/12/9999","Monica.Alvarado@sprint.com","pj333350"
У вас должно быть более 10 сообщений для просмотра скрытого контента.

Код:
ani,startTime,caller_msisdn,caller_tasks,xfrCode,callEnding
cdad262cd921bd6cf69c11626986c4eaf8559de46810b3efce78281b5c6a8c38,2019-07-15 8:48:41.441,cdad262cd921bd6cf69c11626986c4eaf8559de46810b3efce78281b5c6a8c38,""D11,20190715,84855,,X,0.00,0,0"",F,transfered
2e7955cbb09ff97e946786d103e9a22b51d3c760492af575c370ebbb5358b911,2019-07-15 8:54:40.866,2e7955cbb09ff97e946786d103e9a22b51d3c760492af575c370ebbb5358b911,""D2,20190715,85504,,X,0.00,0,0"",N,other
63d4caa9b0c767c19f5046db51019d88a0ac2674d4c5c758f4d334ebd588f1a9,2019-07-15 8:52:40.464,fb329000228cc5a24c264c57139de8bf854fc86fc18bf1c04ab61a2b5cb4b921,NULL,F,transfered



MYA App
Пароли, сертификаты, доступы и их прочая информация (1/4)
У вас должно быть более 28 сообщений для просмотра скрытого контента.


Обращение для T-Mobile:
- Списки вызовов за 2020-03-20-2021-10-26 (IMEI,CALLER_ID*phone*,CALL_DATE...) - кто, кому, когда
- "Hoop's" (так называют внутри компании) за 2020-03-20-2021-10-26 (IMEI,ID*phone*,LAT,LONG,DATE...) - кто, где, когда находился
- Prod utilits, dumps, keystores
- Живой доступ в AWS

Предлагаю публичную сделку. Либо вы либо кто-то кто переведет первым 2.5 ВТС на: bc1qut3haxrvwwawdlx4klyhkwppyrkddvrzf6pv28 получит user;pass от сервера где примерно 2 ТВ данных и активный AWS.
Так-же потом дополню тему другими данными.
 
Код:
"callSessions": [{
            "OEMSV": {
                "androidVersion": "9",
                "buildName": "PKQ1.181105.001",
                "customVersion": "G710TM20f",
                "radioVersion": "MPSS.AT.4.0.c2.9-00061-SDM845_GEN_PACK-1.198357.15.211944.2",
                "SV": "09"
            },
            "callId": "6B74777A32DE6E95",
            "callNumber": "+14252464306",
            "clientVersion": "0.2.0",
            "deviceIntents": {
                "callSettingData": [{
                    "eventInfo": {
                        "cellInfo": {
                            "cellId": "21665794",
                            "ECIO": "",
                            "LAC": "11334",
                            "networkBand": "",
                            "networkType": "",
                            "RSCP": "",
                            "RSRP": "",
                            "RSRQ": "",
                            "RSSI": "",
                            "SINR": "",
                            "SNR": ""
                        },
                        "location": {
                            "altitude": 76.0999984741211,
                            "altitudePrecision": 0.0,
                            "latitude": 47.5799085,
                            "locationAge": 22054,
                            "longitude": -122.1294,
                            "precision": 26.851
                        }
                    },
                    "eventTimestamp": "2020-02-17T17:00:13.056-0800",
                    "oemTimestamp": "2020-02-17T17:00:13.036-0800",
                    "volteStatus": "REGISTERED",
                    "WFCPreference": "WIFIPREFERRED",
                    "WFCStatus": "WIFI_OFF"
                }],
                "detailedCallStateData": [{
                    "callCode": "NA",
                    "callState": "INCOMING",
                    "eventInfo": {
                        "cellInfo": {
                            "cellId": "21665794",
                            "ECIO": "NA",
                            "LAC": "11334",
                            "networkBand": "66,2",
                            "networkType": "LTE",
                            "RSCP": "NA",
                            "RSRP": "-105",
                            "RSRQ": "-15",
                            "RSSI": "-71",
                            "SINR": "16",
                            "SNR": "NA"
                        },
                        "location": {
                            "altitude": 76.0999984741211,
                            "altitudePrecision": 0.0,
                            "latitude": 47.5799085,
                            "locationAge": 22081,
                            "longitude": -122.1294,
                            "precision": 26.851
                        }
                    },
                    "eventTimestamp": "2020-02-17T17:00:13.084-0800",
                    "oemTimestamp": "2020-02-17T17:00:13.036-0800"
                }, {
                    "callCode": "NA",
                    "callState": "ESTABLISHED",
                    "eventInfo": {
                        "cellInfo": {
                            "cellId": "21665794",
                            "ECIO": "NA",
                            "LAC": "11334",
                            "networkBand": "66,2",
                            "networkType": "LTE",
                            "RSCP": "NA",
                            "RSRP": "-105",
                            "RSRQ": "-15",
                            "RSSI": "-71",
                            "SINR": "16",
                            "SNR": "NA"
                        },
                        "location": {
                            "altitude": 76.0999984741211,
                            "altitudePrecision": 0.0,
                            "latitude": 47.5799085,
                            "locationAge": 22815,
                            "longitude": -122.1294,
                            "precision": 26.851
                        }
                    },
                    "eventTimestamp": "2020-02-17T17:00:13.933-0800",
                    "oemTimestamp": "2020-02-17T17:00:13.925-0800"
                }, {
                    "callCode": "NA",
                    "callState": "CONNECTED",
                    "eventInfo": {
                        "cellInfo": {
                            "cellId": "21665794",
                            "ECIO": "NA",
                            "LAC": "11334",
                            "networkBand": "66,2",
                            "networkType": "LTE",
                            "RSCP": "NA",
                            "RSRP": "-107",
                            "RSRQ": "-15",
                            "RSSI": "-71",
                            "SINR": "12",
                            "SNR": "NA"
                        },
                        "location": {
                            "altitude": 76.0999984741211,
                            "altitudePrecision": 0.0,
                            "latitude": 47.5799085,
                            "locationAge": 26256,
                            "longitude": -122.1294,
                            "precision": 26.851
                        }
                    },
                    "eventTimestamp": "2020-02-17T17:00:17.382-0800",
                    "oemTimestamp": "2020-02-17T17:00:17.363-0800"
                }, {
                    "callCode": "NA",
                    "callState": "DISCONNECTING",
                    "eventInfo": {
                        "cellInfo": {
                            "cellId": "21665794",
                            "ECIO": "NA",
                            "LAC": "11334",
                            "networkBand": "66,2",
                            "networkType": "LTE",
                            "RSCP": "NA",
                            "RSRP": "-104",
                            "RSRQ": "-12",
                            "RSSI": "-75",
                            "SINR": "18",
                            "SNR": "NA"
                        },
                        "location": {
                            "altitude": 76.0999984741211,
                            "altitudePrecision": 0.0,
                            "latitude": 47.5799085,
                            "locationAge": 63183,
                            "longitude": -122.1294,
                            "precision": 26.851
                        }
                    },
                    "eventTimestamp": "2020-02-17T17:00:54.281-0800",
                    "oemTimestamp": "2020-02-17T17:00:54.257-0800"
                }, {
                    "callCode": "16",
                    "callState": "ENDED",
                    "eventInfo": {
                        "cellInfo": {
                            "cellId": "21665794",
                            "ECIO": "NA",
                            "LAC": "11334",
                            "networkBand": "66,2",
                            "networkType": "LTE",
                            "RSCP": "NA",
                            "RSRP": "-104",
                            "RSRQ": "-12",
                            "RSSI": "-75",
                            "SINR": "18",
                            "SNR": "NA"
                        },
                        "location": {
                            "altitude": 76.0999984741211,
                            "altitudePrecision": 0.0,
                            "latitude": 47.5799085,
                            "locationAge": 63224,
                            "longitude": -122.1294,
                            "precision": 26.851
                        }
                    },
                    "eventTimestamp": "2020-02-17T17:00:54.324-0800",
                    "oemTimestamp": "2020-02-17T17:00:54.318-0800"
                }],
                "imsSignallingData": [{
                    "eventInfo": {
                        "cellInfo": {
                            "cellId": "21665794",
                            "ECIO": "NA",
                            "LAC": "11334",
                            "networkBand": "66,2",
                            "networkType": "LTE",
                            "RSCP": "NA",
                            "RSRP": "-105",
                            "RSRQ": "-15",
                            "RSSI": "-71",
                            "SINR": "16",
                            "SNR": "NA"
                        },
                        "location": {
                            "altitude": 76.0999984741211,
                            "altitudePrecision": 0.0,
                            "latitude": 47.5799085,
                            "locationAge": 22018,
                            "longitude": -122.1294,
                            "precision": 26.851
                        }
                    },
                    "eventTimestamp": "2020-02-17T17:00:13.115-0800",
                    "oemTimestamp": "2020-02-17T17:00:13.071-0800",
                    "SIPCallId": "FA163E832BB1-76b1-21026700-14544f1-5e4b371a-81a64",
                    "SIPCseq": "CSeq: 1 INVITE",
                    "SIPLine1": "INVITE sip:310260909340690@[2607:fc20:411d:f96e:bd0a:96d4:4c7f:cdb5]:39246 SIP/2.0",
                    "SIPOrigin": "RECEIVED",
                    "SIPReason": "NA",
                    "SIPSDP": ";\"a=sendrecv\";\"c=IN IP6 fd00:976a:14fb:64::7\";\"a=rtpmap:127 EVS/16000\";\"a=rtpmap:97 AMR-WB/16000/1\";\"a=rtpmap:98 AMR-WB/16000/1\";\"a=rtpmap:100 AMR/8000/1\";\"a=rtpmap:101 AMR/8000/1\";\"a=rtpmap:0 PCMU/8000\";\"a=rtpmap:99 telephone-event/16000\";\"a=rtpmap:102 telephone-event/8000\";"
                }

Код:
Columns: ['sum_volte_drops', 'sum_volte_calls', 'sum_wifi_drops', 'sum_wifi_calls', 'sum_w2l_epdg_ho_start', 'sum_w2l_epdg_ho_success', 'sum_w2l_epdg_ho_fail', 'sum_l2w_epdg_ho_start', 'sum_l2w_epdg_ho_success', 'sum_l2w_epdg_ho_fail', 'sum_w2l_drops', 'sum_w2l_calls', 'sum_w2l_drop_rsrp_total', 'sum_w2l_drop_signal_count', 'sum_ww_drop_rssi_total', 'sum_ww_drop_signal_count', 'sum_w2l_drop_due_to_epdg', 'sum_w_epdg_rssi_total', 'sum_w_epdg_signal_count', 'sum_l2w_drop_due_to_epdg', 'sum_l_epdg_rsrp_total', 'sum_l_epdg_signal_count', 'sum_l2w_drop_rssi_total', 'sum_l2w_drop_signal_count', 'sum_ll_drop_rsrp_total', 'sum_ll_drop_signal_count', 'sum_w_rssi_start_total', 'sum_w_rssi_start_signal_count', 'sum_l_rsrp_start_total', 'sum_l_rsrp_start_signal_count', 'sum_w_epdg_rsrp_total', 'model', 'sv', 'msisdn', 'imei', 'wfc_preference']
=-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-=
First row:
sum_volte_drops: 0
sum_volte_calls: 2
sum_wifi_drops: 0
sum_wifi_calls: 0
sum_w2l_epdg_ho_start: 0
sum_w2l_epdg_ho_success: 0
sum_w2l_epdg_ho_fail: 0
sum_l2w_epdg_ho_start: 0
sum_l2w_epdg_ho_success: 0
sum_l2w_epdg_ho_fail: 0
sum_w2l_drops: 0
sum_w2l_calls: 0
sum_w2l_drop_rsrp_total: 0.0
sum_w2l_drop_signal_count: 0
sum_ww_drop_rssi_total: 0.0
sum_ww_drop_signal_count: 0
sum_w2l_drop_due_to_epdg: 0
sum_w_epdg_rssi_total: 0.0
sum_w_epdg_signal_count: 0
sum_l2w_drop_due_to_epdg: 0
sum_l_epdg_rsrp_total: 0.0
sum_l_epdg_signal_count: 0
sum_l2w_drop_rssi_total: 0.0
sum_l2w_drop_signal_count: 0
sum_ll_drop_rsrp_total: 0.0
sum_ll_drop_signal_count: 0
sum_w_rssi_start_total: 0.0
sum_w_rssi_start_signal_count: 0
sum_l_rsrp_start_total: -224.0
sum_l_rsrp_start_signal_count: 2
sum_w_epdg_rsrp_total: 0.0
model: b'unknown'
sv: b'68'
msisdn: b'16468860956'
imei: b'35330909165537'
wfc_preference: b'CELLULAREPREFERRED'
=-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-=
Last row:
sum_volte_drops: 0
sum_volte_calls: 2
sum_wifi_drops: 0
sum_wifi_calls: 0
sum_w2l_epdg_ho_start: 0
sum_w2l_epdg_ho_success: 0
sum_w2l_epdg_ho_fail: 0
sum_l2w_epdg_ho_start: 0
sum_l2w_epdg_ho_success: 0
sum_l2w_epdg_ho_fail: 0
sum_w2l_drops: 0
sum_w2l_calls: 0
sum_w2l_drop_rsrp_total: 0.0
sum_w2l_drop_signal_count: 0
sum_ww_drop_rssi_total: 0.0
sum_ww_drop_signal_count: 0
sum_w2l_drop_due_to_epdg: 0
sum_w_epdg_rssi_total: 0.0
sum_w_epdg_signal_count: 0
sum_l2w_drop_due_to_epdg: 0
sum_l_epdg_rsrp_total: 0.0
sum_l_epdg_signal_count: 0
sum_l2w_drop_rssi_total: 0.0
sum_l2w_drop_signal_count: 0
sum_ll_drop_rsrp_total: 0.0
sum_ll_drop_signal_count: 0
sum_w_rssi_start_total: 0.0
sum_w_rssi_start_signal_count: 0
sum_l_rsrp_start_total: -214.0
sum_l_rsrp_start_signal_count: 2
sum_w_epdg_rsrp_total: 0.0
model: b'Galaxy S7'
sv: b'35'
msisdn: b'6196232520'
imei: b'35975507732530'
wfc_preference: b'WIFIPREFFERED'

Код:
2016-10-08T12:22:31.955+0000,35489007817043,41.8291817/-71.4409753/20.0
2016-10-04T14:28:42.005+0000,35775107252832,42.2331066/-72.0100191/99.0
2016-10-07T17:58:20.918+0000,35971506048960,34.1724795/-118.3155558/34.459
2016-10-07T06:14:45.728+0000,35826907060225,40.4039679/-104.6709441/20.321
2016-10-08T14:00:09.979+0000,35489007817043,41.8253111/-71.4416246/1200.0
2016-10-08T14:23:48.546+0000,35489007817043,41.8253111/-71.4416246/1200.0
2016-10-08T15:03:01.964+0000,35489007817043,41.8203202/-71.4405114/1399.999
2016-10-08T15:34:04.026+0000,35489007817043,41.8292866/-71.4409289/20.0
2016-10-04T00:15:34.689+0000,35872006067801,47.4276381/-122.2895799/78.0
2016-10-08T16:22:52.548+0000,35489007817043,41.8291817/-71.4409753/20.0



У вас должно быть более 50 сообщений для просмотра скрытого контента.


 


Напишите ответ...
  • Вставить:
Прикрепить файлы
Верх