[LS-646] Site DB Report Required for reference Attributes Created: 15/Sep/25  Updated: 09/Oct/25  Due: 17/Sep/25  Resolved: 22/Sep/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: 6 hours, 30 minutes Time Spent: 6 hours, 30 minutes
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Attachments: File 20250917_SITE_DB_REPORT_VIEW.sql     JPEG File Error in Site DB Output.jpg     PNG File Screenshot 2025-09-18 083352.png     Microsoft Word Site DB.docx    
Issue Links:
Relates
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
LS-647 Site DB Report Required for reference... Technical task Cancelled Khaled Khalil  
LS-660 Site DB Report Required for reference... Technical task Cancelled Khaled Khalil  
LS-661 Site DB Report Required for reference... Technical task Cancelled Khaled Khalil  
Customer:
OMAN-Tel
Planned Start:
Planned End:
Complexity: Medium
Severity: Major
Product: NEP
REQUESTER: EXTERNAL
Actual Start:
Date of Baselining:

 Description   

It is required to prepare a report for the attributes mentioned in the document for Sites.

The attributes are need to be in the same sequence as mentioned in the table.

The reference Reports in NEP are Sites Report & Additional Information report for Site.

Attribute Details are available in document attached.

 Comments   
Comment by Marwan Kanaan [ 17/Sep/25 ]

Dear @Aurobinda Panda,

The view is finished please share and verify. 
View attached.

Best Regards,
Marwan Kanaan I Software Developer

Comment by Aurobinda Panda [ 18/Sep/25 ]

Hi Marwan,
The Output is not correct. The column names are not matching for few attributes.

Site ID data is also not matching.
Please check and confirm.

Comment by Marwan Kanaan [ 18/Sep/25 ]

Dear @Aurobinda Panda,

Kindly know that the script is fixed.
Please apply and verify.

ss

Best Regards,

Marwan Kanaan I Software Developer

Comment by Abir Messaikeh [ 22/Sep/25 ]

Bug fixed , file sent to Agile Ops team for validation

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