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.
@cwjohnson3rd this is a pretty good example I've used in the past with a good amount of success.
https://thwack.solarwinds.com/t5/SAM-Discussions/SAM-PagerDuty-integration-issues-with-volume-names/m-p/314843
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:
https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions
That looks like it might work... I just need to learn SWQL by Friday
