[LS-751] Adding EMS Details to NE DB View Created: 27/Oct/25  Updated: 12/Nov/25  Due: 31/Oct/25  Resolved: 12/Nov/25

Status: Closed
Project: L3 Support
Component/s: NEP
Affects Version/s: None
Fix Version/s: None

Type: CR Priority: Normal
Reporter: Aurobinda Panda Assignee: Aurobinda Panda
Resolution: Fixed Votes: 0
Labels: MS_OT
Σ Remaining Estimate: 0 minutes Remaining Estimate: 0 minutes
Σ Time Spent: 7 hours, 30 minutes Time Spent: 7 hours, 30 minutes
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Attachments: File 20250901_NE_ELEMENT_VIEW.sql     JPEG File EMS Details.jpg     Microsoft Excel EMS Details.xlsx     File EMS_CONNECTIONS_INSERTS.sql     JPEG File NE DB View file.jpg    
Issue Links:
Blocks
blocks LS-536 OT | Network Element DB view file pre... Closed
Relates
relates to LS-536 OT | Network Element DB view file pre... Closed
multi-level hierarchy [GANTT]
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
LS-770 Adding EMS Details to NE DB View : Te... Technical task Cancelled Khaled Khalil  
LS-769 Adding EMS Details to NE DB View Desi... Technical task Cancelled Khaled Khalil  
LS-752 Adding EMS Details to NE DB View Requ... Technical task Cancelled Khaled Khalil  
Customer:
OMAN-Tel
Planned Start:
Planned End:
Complexity: Medium
Severity: Major
REQUESTER: EXTERNAL
Actual Start:
Date of Baselining:

 Description   

Dear Khaled Khalil,

Please assign a resource to check for below requirement.

It is required to add the EMS details to NE DB view. Currently the NE DB view file shared with customer is not having any EMS details.

I have attached a sheet where the NODE_TYPE, NE_TYPE, VENDOR details along with the EMS_NAME.



 Comments   
Comment by Marwan Kanaan [ 04/Nov/25 ]

Dear @Aurobinda Panda,

Kindly find the updated script attached.

Please note that the queries in EMS_CONNECTIONS_INSERTS should be executed first before running the main query.

Best Regards,
Marwan Kanaan I Software Developer

Comment by Aurobinda Panda [ 12/Nov/25 ]

Thank you @marwan.

I am closing the ticket.

Generated at Fri Apr 17 10:33:59 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.