10 Replies Latest reply on Jan 21, 2013 11:58 AM by jdbrp

    Question on SWQL commands

    jdbrp

      Hi all. I have a basic question about how to extract text from a field in a query. Does SWQL support something similar to the MID command or SELECT SUBSTRING start posistion, length? I'm not a SQL person so forgive me if the lingo is incorrect.

       

      I'm using NPM 10.4 and have connected to the server with the SDK 1.5. I'm using the SWQL Studio. Below is my query. Dont laugh, its my first one ever.

       

      SELECT C.NODE.DNS,C.NODE.IP,C.NODE.NodeDescription,SerialNumber

      FROM Orion.NodesCustomProperties C

      WHERE C.NODE.DNS LIKE '%NSD%'

      ORDER BY C.NODE.DNS

      I'm trying to extract some text from NodeDescription without pulling all of it.

       

      Thanks for any help.

       

      J