[LS-386] Update on INVENTORYREPORTVIEW Created: 16/May/25  Updated: 21/May/25  Due: 19/May/25  Resolved: 21/May/25

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

Type: CR Priority: Urgent
Reporter: Hassan Abdine Assignee: Abir Messaikeh
Resolution: Fixed Votes: 0
Labels: None
Σ Remaining Estimate: 0 minutes Remaining Estimate: 0 minutes
Σ Time Spent: 2 days Time Spent: 2 days
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Attachments: Zip Archive 20250519_UPDATE_INVENTORYREPORTVIEW.zip    
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
LS-399 Update on INVENTORYREPORTVIEW Design ... Technical task Open Bug Khaled Khalil  
LS-400 Update on INVENTORYREPORTVIEW : Testing Technical task Open Bug Khaled Khalil  
Customer:
Zain KSA 3.X
Planned Start:
Planned End:
Complexity: Medium
Actual Start:
Date of Baselining:

 Description   

Update the database view to consider the below:

  • ACTUAL_SITE: this column is the site name; it has to be deduced from the additional info Actual Site of the parent NE. if no additional info, keep using the site name. (Confirm the exact name of additional info with support or AI team)
  • DUMPS_SERIAL_NUMBER:
  • The view shall contain in addition to Cabinet, Shelf, Board:
    • Transceivers (Node interface having transceivers)
    • Radio antennas

 Comments   
Comment by Anonymous [ 19/May/25 ]

Please find attached a zip folder containing a script to update "INVENTORYREPORTVIEW" as required
You should replace “PUT REQUIRED VERSION NAME HERE” with the appropriate version name.

Comment by Anonymous [ 21/May/25 ]

Applied on PROD

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