This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Question on SWQL commands

jdbrp over 11 years ago

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.

Top Replies

tdanner over 11 years ago in reply to jdbrp +1

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.

0 derhally over 11 years ago

We currently do not support a command such as SUBSTRING, but it is a reasonable request.
Cancel
Vote Up 0 Vote Down

Cancel
0 jdbrp over 11 years ago in reply 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.
Cancel
Vote Up 0 Vote Down

Cancel
0 derhally over 11 years ago in reply to jdbrp

Unfortunately there isn't. Is it an option to do post processing on the column after you get the results?
Cancel
Vote Up 0 Vote Down

Cancel
0 jdbrp over 11 years ago in reply 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.
Cancel
Vote Up 0 Vote Down

Cancel
0 tdanner over 11 years ago in reply to jdbrp

I would just use the string manipulation facilities in whatever language you are planning to write this script in.
Cancel
Vote Up 0 Vote Down

Cancel
0 jdbrp over 11 years ago in reply to tdanner

Thats the thing. I want to use SolarWinds's Custom Query and right it in SWQL.
Cancel
Vote Up 0 Vote Down

Cancel
0 tdanner over 11 years ago in reply 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.
Cancel
Vote Up 0 Vote Down

Cancel
0 jdbrp over 11 years ago in reply 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
Cancel
Vote Up 0 Vote Down

Cancel
0 tdanner over 11 years ago in reply 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.
Cancel
Vote Up +1 Vote Down

Cancel
0 jdbrp over 11 years ago in reply to tdanner

Ok. Thanks for the help and information!
Cancel
Vote Up 0 Vote Down

Cancel