3 Replies Latest reply on Nov 1, 2019 5:18 PM by mesverrum

    SWQL Script for a Custom Report


      Hi All,


      I'm looking to create a custom report with the following criteria >



      Number of switches per site 


      Number of access switch ports per site 


      Number of free access switch ports per site (admin down) 


      Names of switches with less than 5 ports available


      there's no standard report that will allow me to do this and creating a custom table does not reveal the number of switches or interfaces as a numerical value, it simply lists all the switches and down interfaces.


      Does anyone have or know how to create a SWQL script to create a table for this or point me in the right direction,


      would appreciate any help,