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.
Solved! Go to Solution.
@cwjohnson3rd this is a pretty good example I've used in the past with a good amount of success.
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.
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 \\
Well, SWQL has REPLACE. You could insert a SWQL variable and use the function to properly format your output:
That looks like it might work... I just need to learn SWQL by Friday😊
@cwjohnson3rd this is a pretty good example I've used in the past with a good amount of success.
Thank you very much.... you're a life saver.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.