Hi, I'm doubtless being super stupid here, but I've spent a while searching and I can't find the answer, so I'm giving up and asking the clever people.
(Also, apologies if this is in the wrong place, I figured since it's SAM specific it should go in here?)
I have the "All Applications Tree" SAM resource showing on our main dashboard as it doesn't take up much space and it's a nice to have green blob of reassurance, however as soon as one app is unmanaged, it changes the state of the whole group to unmanaged. I'd like it to ignore unmanaged apps, so it would show as green if everything is green apart from unmanaged apps which by definition they don't need to worry about?
I tried this in the "Filter Applications (SWQL) box: UnManaged<>1
But it just gives "Server error: Error: A query to the SolarWinds Information Service failed."
So... Can I do it? Am I using the wrong resource or just being really dense, or is it a sql/swql thing? and I just need to add a judicious x or . or something?
Solved! Go to Solution.
Try using Status <> 9 in the same place.
There should also be filter examples in there where it should show the usage of the Filter (SQL) text box.
Status <> 9 doesn't fail with an error but it still shows the group in question overall status as unmanaged exactly as before.
Edit: Actually, that does make a difference, It removes/ignores one of the 3 devices in the list, which is unmanaged. It doesn't hide the 2 devices that are up but the application is unmanaged. So I guess I need an AppStatus <> 9 equivalent?
there are a couple of samples but it's SWQL and there's not much depth...
(thank you tho!)
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.