NQE example similar to using grep and awk

Hi Ron,

I’m not sure if this is exactly what you’re looking for: But this will give you the output of:
Hostname ---- Interface ----- Description

I narrowed it down to just Cisco/IOS-XE with the “wheres” but you can adjust.

pattern = ```
interface {IntName:string} 
    description {desc: ((string)*)}
```;

foreach device in network.devices
	 where device.platform.vendor == Vendor.CISCO
	 let outputs = device.outputs
foreach command in outputs.commands
	where command.commandType == CommandType.CONFIG
	let parsed = parseConfigBlocks(OS.IOS_XE , command.response)
foreach match in blockMatches(parsed, pattern)



select {Hostname:device.name , Intf:match.data.IntName, Desc:match.data.desc}

Thanks all!

@RonAvila String manipulation requires a little special handling, We will be improving this in future releases. But here is one example.


 

test = """
interface Ethernet1/1
 description “to site x interface gi0/0”;
!
interface Ethernet1/2
 description “to site y interface gi0/1”:
!
""";

trimLast(s) = prefix(s, length(s)-1);
trimFirstLast(s) =  max(foreach x in [0] let p = prefix(s, length(s)-2) select suffix(p, length(p)-1));

pattern = ```
interface {IntName:string} 
 description {s: (string*)}
```;

stringParse =  `to site {site: string} interface {int: string}`;


foreach x in [0]
let blocks = parseConfigBlocks(OS.UNKNOWN, test)
foreach match in blockMatches(blocks, pattern)
let newString = trimFirstLast(join(" ", match.data.s))
let site = patternMatch(newString, stringParse)
select {FromInterface: match.data.IntName, ToSite: site.site, ToInterface: site.int, }