Hi,
I basically am trying to do a report which will let me have number of Active ports, inactive ports, port counts and I have go this far using thread below:
https://thwack.solarwinds.com/thread/51785
However I also want to add a column for number of ports in Vlan 666 on those devices. I would be grateful if anyone can help with this as I have little to no experience with SQL
Thanks in advance 
Zee
