4 Replies Latest reply on Sep 27, 2017 3:34 PM by snaven

    Trying to get a swiss query to run and its failing.  What am I doing wrong?

    snaven

      Trying to get a swiss query to run and it does not like my where clause.  Running it from the http://solarwindsServerName/orion/admin/swis.aspx web console.

       

      SELECT HostName, ExpirationDate, Manufacturer, Model, OSArchitecture,  SerialNumber, WarrantyStatus

      FROM Orion.AssetInventory.NodeWarrantyAlert

      WHERE Manufacturer<>VMware,Inc

       

      also tried:

       

      WHERE Manufacturer<>"VMware,Inc"

      WHERE Manufacturer <> "VMware,Inc"

      WHERE Manufacturer="VMware,Inc"

      WHERE Manufacturer = "VMware,Inc"

       

      What am I doing wrong?