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

Question on SWQL commands

jdbrp Jan 10, 2013 4:37 PM

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.

Re: Question on SWQL commands

derhally Jan 10, 2013 4:51 PM (in response to jdbrp)

We currently do not support a command such as SUBSTRING, but it is a reasonable request.
Like (0)

Actions
- Re: Question on SWQL commands
  
  jdbrp Jan 11, 2013 7:33 AM (in response to derhally)
  
  Is there any other command or combination of commands that could perform the task? Basically, there might be a way to extract just a certain portion of the text in a field with SWQL but I'm not familiar enough with database's or sql type commands to know if there is.
  
  Like (0)
  
  Actions
  - Re: Question on SWQL commands
    
    derhally Jan 11, 2013 8:13 AM (in response to jdbrp)
    
    Unfortunately there isn't. Is it an option to do post processing on the column after you get the results?
    
    Like (0)
    
    Actions
    - Re: Question on SWQL commands
      
      jdbrp Jan 14, 2013 7:23 AM (in response to derhally)
      
      I suppose. All I'm trying to do is get the operating system version from a Netapp without all the extra text that the mib provides. Below is what is pulled by Solarwinds by default.
      
      NetApp Release 8.0.0.P04 Thu Sep 25 11:12:00 PDT 2011
      
      I just want to extract the 8.0.0.P04 without the rest of the text.
      
      Like (0)
      
      Actions
      - Re: Question on SWQL commands
        
        tdanner Jan 14, 2013 10:49 AM (in response to jdbrp)
        
        I would just use the string manipulation facilities in whatever language you are planning to write this script in.
        
        Like (0)
        
        Actions
        
        Re: Question on SWQL commands
        
        jdbrp Jan 14, 2013 2:53 PM (in response to tdanner)
        
        Thats the thing. I want to use SolarWinds's Custom Query and right it in SWQL.
        
        Like (0)
        
        Actions
        
        Re: Question on SWQL commands
        
        tdanner Jan 14, 2013 3:40 PM (in response to jdbrp)
        
        I don't think I understand what you want to do. SWQL Studio is a GUI tool. If all you want to do is have a human read the value, just read the value. Computing the substring only matters if you want to do further processing on it.
        
        Like (0)
        
        Actions
        
        Re: Question on SWQL commands
        
        jdbrp Jan 16, 2013 12:19 PM (in response to tdanner)
        
        I think you answered it higher in the post. You mentioned it was not possible using SWQL to extract only a portion of a field versus the entire field. However, you mentioned something about post processing after the data was retrieved. Since we are talking basically about ascii text, how would you post process that data once its pulled into the database?
        
        Thanks
        
        Like (0)
        
        Actions
        
        Re: Question on SWQL commands
        
        tdanner Jan 16, 2013 12:31 PM (in response to jdbrp)
        
        It depends on what database you are putting the data into. For SQL Server, you can use the built in String Functions (Transact-SQL). Other databases will have something similar.
        1 of 1 people found this helpful
        
        Like (0)
        
        Actions
        
        Re: Question on SWQL commands
        
        jdbrp Jan 21, 2013 11:58 AM (in response to tdanner)
        
        Ok. Thanks for the help and information!
        
        Like (0)
        
        Actions

Go to original post