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

    SWQL Script for a Custom Report

    gtalewar

      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,

       

      thanks

      Ghanaya