Assistance with multiple lines into a list of variables

[travisjohnsonga]

I'm having difficulty with a show license summary template for cisco. It's close, but not quite, and this is my first template so any help is appreciated.

The CLI output is

Smart Licensing is ENABLED

Registration:
  Status: REGISTERED
  Smart Account: My Company
  Virtual Account: myVa
  Export-Controlled Functionality: ALLOWED
  Last Renewal Attempt: None
  Next Renewal Attempt: Feb 19 19:29:14 2024 CDT

License Authorization:
  Status: OUT OF COMPLIANCE
  Last Communication Attempt: SUCCEEDED
  Next Communication Attempt: Aug 24 07:29:17 2023 CDT

License Usage:
  License                 Entitlement tag               Count Status
  -----------------------------------------------------------------------------
  C9500 Network Advantage (C9500 Network Advantage)         2 AUTHORIZED 
  C9500 48Y4C DNA Adva... (C9500 48Y4C DNA Advantage)       2 OUT OF COMPLIANCE 

My template is

Value Filldown SMART_LICENSE_STATE (.*) 
Value Filldown REG_STATUS (\S+)
Value Filldown VIRTUAL_ACCOUNT (.*)
Value LICENSE_AUTH_STATUS (.*)
Value Filldown LAST_COMM_STATUS (.*)
Value LICENSE_TYPE (.*)
Value LICENSE_COUNT (\d+)
Value LICENSE_STATUS (.*)
Value LICENSE_TAG (.*)

Start
  ^Smart Licensing is ${SMART_LICENSE_STATE} 
  ^\s+Status:\s+${REG_STATUS}$$
  ^\s+Virtual\s+Account:\s+${VIRTUAL_ACCOUNT}
  ^\s+Status:\s+${LICENSE_AUTH_STATUS}$$
  ^.*\s+Last Communication Attempt:\s+${LAST_COMM_STATUS}$$
  ^\s-+ -> Continue
  ^\s+${LICENSE_TYPE}.*\(${LICENSE_TAG}\).*${LICENSE_COUNT}\s+${LICENSE_STATUS} -> Record

The output though, outputs a 3rd item for some reason.

[
	{
		"LAST_COMM_STATUS": "SUCCEEDED",
		"LICENSE_AUTH_STATUS": "OUT OF COMPLIANCE",
		"LICENSE_COUNT": "2",
		"LICENSE_STATUS": "AUTHORIZED ",
		"LICENSE_TAG": "C9500 Network Advantage",
		"LICENSE_TYPE": "C9500 Network Advantage ",
		"REG_STATUS": "REGISTERED",
		"SMART_LICENSE_STATE": "ENABLED",
		"VIRTUAL_ACCOUNT": "myVa"
	},
	{
		"LAST_COMM_STATUS": "SUCCEEDED",
		"LICENSE_AUTH_STATUS": "",
		"LICENSE_COUNT": "2",
		"LICENSE_STATUS": "OUT OF COMPLIANCE ",
		"LICENSE_TAG": "C9500 48Y4C DNA Advantage",
		"LICENSE_TYPE": "C9500 48Y4C DNA Adva... ",
		"REG_STATUS": "REGISTERED",
		"SMART_LICENSE_STATE": "ENABLED",
		"VIRTUAL_ACCOUNT": "myVa"
	},
	{
		"LAST_COMM_STATUS": "SUCCEEDED",
		"LICENSE_AUTH_STATUS": "",
		"LICENSE_COUNT": "",
		"LICENSE_STATUS": "",
		"LICENSE_TAG": "",
		"LICENSE_TYPE": "",
		"REG_STATUS": "REGISTERED",
		"SMART_LICENSE_STATE": "ENABLED",
		"VIRTUAL_ACCOUNT": "myVa"
	}
]

I've tried a few different things, like using a list for LICENSE to create an array, but I get illegal or duplicate variable.

[jorlandobr]

I think that your 3rd item is due the -> Record at the last line of your template. Each time you do a record a new state is created with new variables.

Anyway, I modified a little your template and I think now it captures all that you need. I added other variables for testing and "why not?"

HTH

Modified template:

Value SMART_LICENSE_STATE (.*) 
Value REG_STATUS (\S+)
Value SMART_ACCT (.*)
Value VIRTUAL_ACCOUNT (.*)
Value EXPORT_CTL (.*)
Value RENEW_LAST (.*)
Value RENEW_NEXT (.*)
Value LICENSE_AUTH_STATUS (.*)
Value LAST_COMM_STATUS (.*)
Value NEXT_COMM_STATUS (.*)
Value List LICENSE_TYPE (.*)
Value List LICENSE_COUNT (\d+)
Value List LICENSE_STATUS (.*)
Value List LICENSE_TAG (.*)

Start
  ^Smart Licensing is ${SMART_LICENSE_STATE} 
  ^\s+Status:\s+${REG_STATUS}$$
  ^\s+Smart\s+Account:\s+${SMART_ACCT}$$
  ^\s+Virtual\s+Account:\s+${VIRTUAL_ACCOUNT}
  ^\s+Export-Controlled\s+Functionality:\s+${EXPORT_CTL}
  ^\s+Last\s+Renewal\s+Attempt:\s+${RENEW_LAST}
  ^\s+Next\s+Renewal\s+Attempt:\s+${RENEW_NEXT}
  ^\s+Status:\s+${LICENSE_AUTH_STATUS}$$
  ^.*\s+Last Communication Attempt:\s+${LAST_COMM_STATUS}$$
  ^.*\s+Next Communication Attempt:\s+${NEXT_COMM_STATUS}$$
  ^\s-+ -> Continue
  ^\s+${LICENSE_TYPE}.*\(${LICENSE_TAG}\).*${LICENSE_COUNT}\s+${LICENSE_STATUS}

Output:

[
	{
		"EXPORT_CTL": "ALLOWED",
		"LAST_COMM_STATUS": "SUCCEEDED",
		"LICENSE_AUTH_STATUS": "OUT OF COMPLIANCE",
		"LICENSE_COUNT": [
			"2",
			"2"
		],
		"LICENSE_STATUS": [
			"AUTHORIZED ",
			"OUT OF COMPLIANCE "
		],
		"LICENSE_TAG": [
			"C9500 Network Advantage",
			"C9500 48Y4C DNA Advantage"
		],
		"LICENSE_TYPE": [
			"C9500 Network Advantage ",
			"C9500 48Y4C DNA Adva... "
		],
		"NEXT_COMM_STATUS": "Aug 24 07:29:17 2023 CDT",
		"REG_STATUS": "REGISTERED",
		"RENEW_LAST": "None",
		"RENEW_NEXT": "Feb 19 19:29:14 2024 CDT",
		"SMART_ACCT": "My Company",
		"SMART_LICENSE_STATE": "ENABLED",
		"VIRTUAL_ACCOUNT": "myVa"
	}
]