-
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.
-
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.
-
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?
-
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.
-
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.
-
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.
-
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.
-
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
-
Re: Question on SWQL commands
tdanner Jan 16, 2013 12:31 PM (in response to jdbrp)1 of 1 people found this helpfulIt 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.
-
Re: Question on SWQL commands
jdbrp Jan 21, 2013 11:58 AM (in response to tdanner)Ok. Thanks for the help and information!
-
-
-
-
-
-
-
-
-