cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Variables...

Jump to solution

Does anyone have a query that will give me a volume description but drops the \ on the drive letter. I am sending a JSON and the \ in the drive description is causing it to fail. Please let me know if I make no sense... Thanks. 

0 Kudos
1 Solution
6 Replies
Level 12

Are you generating the JSON from code? If so, you could replace the '\' in the drive variable with '\\' in order to escape it before constructing the JSON.

 

No, I am using the selectable variable in the JSON text area... so when it pulls the variable from the SW database it has the slash already there.

cwjohnson3rd_0-1605446167156.png

What I was hoping for was a SQL/SWSQL query that did the same thing as the Volume description but is able to filter out the \ or exclude it by \\

0 Kudos

Well, SWQL has REPLACE. You could insert a SWQL variable and use the function to properly format your output:

 

https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions 

That looks like it might work... I just need to learn SWQL by Friday😊

0 Kudos

Thank you very much.... you're a life saver. 

0 Kudos