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.
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.
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 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.