IP address in NEP without Object ID.jpg
IPDATA_CLEANUP_SCRIPT_20251128.sql
Azerconnect
[LS-801] AZRC | IPs without Object ID need to remove from NEP Created: 28/Nov/25 Updated: 28/Jan/26 Due: 02/Dec/25 Resolved: 28/Jan/26 |
|
| Status: | Closed |
| Project: | L3 Support |
| Component/s: | NEP |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Normal |
| Reporter: | Aurobinda Panda | Assignee: | Aurobinda Panda |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | service_routing | ||
| Remaining Estimate: | 0 minutes | ||
| Time Spent: | 4 hours, 45 minutes | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
IP address in NEP without Object ID.jpg
IPDATA_CLEANUP_SCRIPT_20251128.sql
|
| Customer: |
Azerconnect
|
| Planned Start: | |
| Planned End: | |
| Complexity: | Medium |
| Severity: | Critical |
| Product: | NEP |
| REQUESTER: | INTERNAL |
| Actual Start: | |
| Date of Baselining: |
| Description |
|
It is found that there are IPs in NEP IP data where IP address is available without Object ID or the IP is not assigned to any Object ID. So need a cleanup script to remove those IP addresses from NEP IP data. |
| Comments |
| Comment by Mustapha Al-Hage [ 28/Nov/25 ] |
|
Dear @Aurobinda Panda, The requested script to delete all ip addresses without object id is attached to this email. Please note that after applying the script, a restart to NEP is required. Regards, |
| Comment by Aurobinda Panda [ 10/Dec/25 ] |
|
Dear Mustapha, as checked in test server the IPs without Object ID where status is not "used by network" is removed post script run. |