Thanks alot this worked perfectly but i have one issue you can see in my output the script is skipping the first result for System Capabilities: and IP:
awk '
{sub ("\r+$", _)
}
/spawn/ {sub (/^.*@/, _)
IP = $0
NENM = DESC = ""
}
/NE name:/ {NENM = $4
}
/System Capabilities: / {sub (/^System Capabilities: /, _)
SYCP = $0
}
/System Name: / {sub (/^System Name: /, _)
SYNM = $0
}
/Local Intf: / {sub (/^Local Intf: /, _)
LCINF = $0
}
/IP: / {sub (/^IP: /, _)
MGIP = $2
}
/Port id: / {sub (/^Port id: /, _)
RMPR = $0
}
/Chassis id: / {sub (/^Chassis id: /, _)
CHID = $0
}
/System Desc/ {getline
sub ("\r+$", _)
print NENM, IP, SYCP, LCINF, MGIP, SYNM, RMPR, CHID, $0awk '
{sub ("\r+$", _)
}
/spawn/ {sub (/^.*@/, _)
IP = $0
NENM = DESC = ""
}
/NE name:/ {NENM = $4
}
/System Capabilities: / {sub (/^System Capabilities: /, _)
SYCP = $0
}
/System Name: / {sub (/^System Name: /, _)
SYNM = $0
}
/Local Intf: / {sub (/^Local Intf: /, _)
LCINF = $0
}
/IP: / {sub (/^IP: /, _)
MGIP = $2
}
/Port id: / {sub (/^Port id: /, _)
RMPR = $0
}
/Chassis id: / {sub (/^Chassis id: /, _)
CHID = $0
}
/System Desc/ {getline
sub ("\r+$", _)
print NENM, IP, SYCP, LCINF, MGIP, SYNM, RMPR, CHID, $0
Output
AA2M3A.SNFN,172.17.168.226, ,Gi0/2/1,ER_3898_1_FON,GigabitEthernet 22/255/1,80b5.7543.cbcb,Huawei RTN 980
AA2M3A.SNFN,172.17.168.226,B,Gi0/2/0 ,129.9.118.189,ER_3898_1_FON,GigabitEthernet 17/255/1,80b5.7543.cbcb,Huawei RTN 980
AB4M7a.SNFN,172.17.167.229,B,Te0/7/6 ,129.9.118.189,ABH4.UPE.HCX16.01,GigabitEthernet14/1/8 ,0425.c58f.31cb,Huawei Versatile Routing Platform Software