Details
-
Type:
CR
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Component/s: NEP
-
Labels:None Labels
-
Customer:OMAN-Tel
-
Product:NEP
Description
We need to create a new DB view for IP Core routers with model NE40 only and active status with attached structure
source of info is custom NE report and Site report ( i attached Custom NE Report extracted a while ago for reference)
Attachments
Open Bug
Activity
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2025-09-12 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2025-09-12 24:00 (milestone: set planned end date to due date) |
| Attachment | Custom NE Report 2025.csv [ 117021 ] | |
| Attachment | IP_Core_Infovista_view_Structure.xlsx [ 117022 ] |
| Assignee | Khaled Khalil [ kkhalil ] | Mustapha Al-Hage [ malhage ] |
| Assignee | Mustapha Al-Hage [ malhage ] | Marwan Kanaan [ mkanaan ] |
| Status | Opened [ 1 ] | Pending Requirements [ 10300 ] |
| Status | Pending Requirements [ 10300 ] | Pending Design Session [ 10112 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Khaled Khalil [ kkhalil ] |
| Status | Pending Design Session [ 10112 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Assignee | Khaled Khalil [ kkhalil ] | Marwan Kanaan [ mkanaan ] |
-
- Time Spent:
- 2 hours
-
finished the view
| Attachment | 20250917_IP_CORE_INFOVISTA_VIEW.sql [ 117807 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 3 hours [ 10800 ] | |
| Worklog Id | 277832 [ 277832 ] |
| Baseline Start | 2025-09-12 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2025-09-12 24:00 (set baseline based of initial work logging) |
| Time Spent | 3 hours [ 10800 ] | 6 hours [ 21600 ] |
| Worklog Id | 277833 [ 277833 ] |
| Worklog Id | 277832 [ 277832 ] |
| Remaining Estimate | 0 minutes [ 0 ] | 1 hour [ 3600 ] |
| Time Spent | 6 hours [ 21600 ] | 5 hours [ 18000 ] |
| Worklog Id | 277832 [ 277832 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Abir Messaikeh [ amessaikeh ] |
| Remaining Estimate | 1 hour [ 3600 ] | 0 minutes [ 0 ] |
| Time Spent | 5 hours [ 18000 ] | 6 hours [ 21600 ] |
| Worklog Id | 278168 [ 278168 ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
CSV generated by script has been sent to Azrin for confirmation of automation
Show
Abir Messaikeh
added a comment - CSV generated by script has been sent to Azrin for confirmation of automation
| Status | QA In Progress [ 10015 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] |
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
10d 20h 46m | 1 | Khaled Khalil | 16/Sep/25 11:19 AM | |||||
|
1m 34s | 1 | Khaled Khalil | 16/Sep/25 11:21 AM | |||||
|
8s | 1 | Khaled Khalil | 16/Sep/25 11:21 AM | |||||
|
9s | 1 | Khaled Khalil | 16/Sep/25 11:21 AM | |||||
|
22h 4m | 1 | Marwan Kanaan | 17/Sep/25 9:25 AM | |||||
|
4h 14m | 1 | Khaled Khalil | 17/Sep/25 1:40 PM | |||||
|
11d 23h 46m | 1 | Abir Messaikeh | 29/Sep/25 1:27 PM | |||||
|
44d 20h 53m | 1 | Abir Messaikeh | 13/Nov/25 9:20 AM |
|
Links Hierarchy |
 Documentation
|
Dear @Abir Messaikeh,
Second view is finished please share and verify.
View attached.
Best Regards,
Marwan Kanaan I Software Developer