0 Replies Latest reply on Oct 30, 2014 12:48 PM by blodwick

    WHERE condition examples

    blodwick

      Everything I have seen on thwack regarding example queries have been pretty plain vanilla, so I thought I would provide a couple WHERE clauses I have found to be fairly helpful. Please feel free to add.

       

      SELECT ServiceTag FROM Orion.HardwareHealth.HardwareInfo WHERE NodeID = 238 OR NodeID = 239

      SELECT NodeID,SysName,Vendor,MachineType,IOSImage,IOSVersion,IP FROM Orion.Nodes WHERE Vendor LIKE '%Cisco%'