1 Reply Latest reply on Nov 12, 2014 9:46 PM by zackm

    SWQL report writer all cisco devices

    elton

      Hello,

       

      I am trying to use the SWQL as my selection method for a custom table. I have been going through documentation and once I came across the 1.9 SDK I have made much more progress. My question is how can I write an SWQL query that gives me all cisco devices? This is quite simple with dynamic query builder, however I then want to be able to filter the data based on work hours (eg. 8-5 Monday-Friday) so the dynamic query builder isn't the solution for me.

       

      For example I can do

      SELECT z.Caption

      FROM Orion.Nodes z

      WHERE z.Vendor='Cisco'

       

      This just gives me captions though of all cisco devices. I want something like SELECT *. Any help is greatly appreciated. Thank you!