...
- Login to dcae-mongodb container and execute following commands to check if PM data was saved in DB:
- mongo
- use datalake
- db.unauthenticatedperformancemeasurements.find({})
to load sample data:
Code Block title mongodb sample data 1 linenumbers true collapse true db.unauthenticatedperformancemeasurements.insert({ "event": { "commonEventHeader": { "domain": "perf3gpp", "eventId": "dfe43a5c-0868-4275-b1c9-e45945b6a38c", "eventName": "perf3gpp_CORERnNode-cucpserver2Slicing_pmMeasResult", "lastEpochMicrosec": 1610689590387, "priority": "Normal", "reportingEntityName": "", "sequence": 1, "sourceName": "oteNB5309cucpserver2", "startEpochMicrosec": 1610689590387, "version": 4, "vesEventListenerVersion": "7.1", "timeZoneOffset": "UTC+05:00" }, "perf3gppFields": { "perf3gppFieldsVersion": "1.0", "measDataCollection": { "granularityPeriod": 900, "measuredEntityUserName": "", "measuredEntityDn": "cucpserver2", "measuredEntitySoftwareVersion": "r0.1", "measInfoList": [ { "measInfoId": { "sMeasTypesList": "SLICE" }, "measTypes": { "sMeasTypesList": [ "PDUSessionEstSR.01-B989BD" ] }, "measValuesList": [ { "suspectFlag": false, "measResults": [ { "p": 1, "sValue": "166" } ] } ] } ] } } } })
Code Block title mongodb sample data 2 linenumbers true collapse true db.unauthenticatedperformancemeasurements.insert({ "event": { "commonEventHeader": { "domain": "perf3gpp", "eventId": "df069b2e4ad683e3-099340d0-4aca47f5-9e5e8ba0-60a11c6e3399a8da51ff1ab5", "eventName": "perf3gpp_CORERnNode-cucpserver2Slicing_pmMeasResult", "lastEpochMicrosec": 1606743157915, "priority": "Normal", "reportingEntityName": "", "sequence": 1, "sourceName": "oteNB5309cucpserver2", "startEpochMicrosec": 1606743157914, "version": 4, "vesEventListenerVersion": "7.1", "timeZoneOffset": "UTC+05:00" }, "perf3gppFields": { "perf3gppFieldsVersion": "1.0", "measDataCollection": { "granularityPeriod": 900, "measuredEntityUserName": "", "measuredEntityDn": "cucpserver2", "measuredEntitySoftwareVersion": "r0.1", "measInfoList": [ { "measInfoId": { "sMeasTypesList": "SLICE" }, "measTypes": { "sMeasTypesList": [ "PDUSessionEstSR.01-B989BD" ] }, "measValuesList": [ { "suspectFlag": false, "measResults": [ { "p": 1, "sValue": "188" } ] } ] } ] } } } })
Code Block title mongodb sample data 3 linenumbers true collapse true db.unauthenticatedperformancemeasurements.insert({ "event": { "commonEventHeader": { "domain": "perf3gpp", "eventId": "df069b2e5105bf0e-0993f157-4aca455f-9e5eb1eb-60a11c6e3399d686ddf39aa9", "eventName": "perf3gpp_CORERnNode-cucpserver2Slicing_pmMeasResult", "lastEpochMicrosec": 1606753197538, "priority": "Normal", "reportingEntityName": "", "sequence": 1, "sourceName": "oteNB5309cucpserver2", "startEpochMicrosec": 1606753197537, "version": 4, "vesEventListenerVersion": "7.1", "timeZoneOffset": "UTC+05:00" }, "perf3gppFields": { "perf3gppFieldsVersion": "1.0", "measDataCollection": { "granularityPeriod": 900, "measuredEntityUserName": "", "measuredEntityDn": "cucpserver2", "measuredEntitySoftwareVersion": "r0.1", "measInfoList": [ { "measInfoId": { "sMeasTypesList": "SLICE" }, "measTypes": { "sMeasTypesList": [ "PDUSessionEstSR.01-B989BD" ] }, "measValuesList": [ { "suspectFlag": false, "measResults": [ { "p": 1, "sValue": "61" } ] } ] } ] } } } })
Code Block title mongodb sample data 4 linenumbers true collapse true db.unauthenticatedperformancemeasurements.insert({ "event": { "commonEventHeader": { "domain": "perf3gpp", "eventId": "24cf31f7-3def-43c1-85d8-4ad8041c5e08", "eventName": "perf3gpp_RnNode-Slicing_pmMeasResult", "lastEpochMicrosec": 1610689590387, "priority": "Normal", "reportingEntityName": "", "sequence": 1, "sourceName": "cucpserver1", "startEpochMicrosec": 1610689590387, "version": 4.0, "vesEventListenerVersion": "7.1", "timeZoneOffset": "UTC+05:30" }, "perf3gppFields": { "perf3gppFieldsVersion": "1.0", "measDataCollection": { "granularityPeriod": 900, "measuredEntityUserName": "", "measuredEntityDn": "cucpserver1", "measuredEntitySoftwareVersion": "r0.1", "measInfoList": [{ "measInfoId": { "sMeasTypesList": "SLICE" }, "measTypes": { "sMeasTypesList": ["PDUSessionEstSR.01-497651"] }, "measValuesList": [{ "suspectFlag": false, "measResults": [{ "p": 1, "sValue": "228" }] }] }] } } } })
Code Block title mongodb sample data 5 linenumbers true collapse true db.unauthenticatedperformancemeasurements.insert({ "event": { "commonEventHeader": { "domain": "perf3gpp", "eventId": "22ad0df1-958b-4136-9053-57c3967a6207", "eventName": "perf3gpp_RnNode-Slicing_pmMeasResult", "lastEpochMicrosec": 1606743157915, "priority": "Normal", "reportingEntityName": "", "sequence": 1, "sourceName": "cucpserver1", "startEpochMicrosec": 1606743157914, "version": 4.0, "vesEventListenerVersion": "7.1", "timeZoneOffset": "UTC+05:30" }, "perf3gppFields": { "perf3gppFieldsVersion": "1.0", "measDataCollection": { "granularityPeriod": 900, "measuredEntityUserName": "", "measuredEntityDn": "cucpserver1", "measuredEntitySoftwareVersion": "r0.1", "measInfoList": [{ "measInfoId": { "sMeasTypesList": "SLICE" }, "measTypes": { "sMeasTypesList": ["PDUSessionEstSR.01-497651"] }, "measValuesList": [{ "suspectFlag": false, "measResults": [{ "p": 1, "sValue": "137" }] }] }] } } } })
Code Block title mongodb sample data 6 linenumbers true collapse true db.unauthenticatedperformancemeasurements.insert({ "event": { "commonEventHeader": { "domain": "perf3gpp", "eventId": "c01bf72b-d4a3-42d6-a0bb-3d96bdacc503", "eventName": "perf3gpp_RnNode-Slicing_pmMeasResult", "lastEpochMicrosec": 1606753197538, "priority": "Normal", "reportingEntityName": "", "sequence": 1, "sourceName": "cucpserver1", "startEpochMicrosec": 1606753197537, "version": 4.0, "vesEventListenerVersion": "7.1", "timeZoneOffset": "UTC+05:30" }, "perf3gppFields": { "perf3gppFieldsVersion": "1.0", "measDataCollection": { "granularityPeriod": 900, "measuredEntityUserName": "", "measuredEntityDn": "cucpserver1", "measuredEntitySoftwareVersion": "r0.1", "measInfoList": [{ "measInfoId": { "sMeasTypesList": "SLICE" }, "measTypes": { "sMeasTypesList": ["PDUSessionEstSR.01-497651"] }, "measValuesList": [{ "suspectFlag": false, "measResults": [{ "p": 1, "sValue": "199" }] }] }] } } } })
4. Datalake Extraction Service(DES):
...