Hi,
Using DB variables it is possible to do something like what you're after. Although I haven't thought of a way to compute the interface range command yet you can write a script that loops through all access interfaces and applies commands to them.
First you'd need to edit the "CLITemplateDbVariablesQuery.properties" file in "/opt/CSCOlumos/conf/ifm/template/inventoryTagsInTemplate". Always make a backup of this file before editing!
To create a DB variable that selects access ports you could insert something like this at the end of the file:
accessPorts=select vlan.name from VLANSwitchportSettings vlan where (vlan.desiredVlanMode != '5' and vlan.operationalVlanMode != '5') AND vlan.name not like 'Port-%' AND vlan.owningEntityId =
I use VI to edit the file but if you're not comfortable with that you could transfer the file to your workstation and use whatever editor you feel like.
You can modify the 'where' criteria as you see fit, from what I've seen 5 is where 'switchport mode trunk' has been applied. You could also match on '2' for desiredVlanMode which appears to be fixed access. This example also excludes all port-channels, obviously you might not want that as you could have a port-channel in access mode.
Then in your CLI template you could add a DB variable called accessPorts (set the default value to accessPorts so it references your query). Example template code:
#foreach($int in $accessPorts)
interface $int
! do something
#end
As previously mentioned, you could also use the compliance policies to achieve this, the steps would be something like:
1) Match on 'interface'
2) Match on 'switchport mode access'
3) Match on 'your command'. Set a violates fix action on this that inserts 'your command'
And then run the profile, its not strictly speaking what the compliance feature is for but it should work.
Dave
