This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Report on Incorrect Route

We have a backup and secondary connection. I would like a report of which sites are using the secondary connection as their default route. I was able to get an alert using this, but that was chatty and never recovered properly. I didn't spend too much time trying to fix the alert since, in my case, a report would make more sense. I have attached what the alert trigger looked like. The issue I am having with the report is I there is not an option to limit the report by Row Label. I think I will need to do an Advanced DataBase Query, but I currently know very little about SQL or SWQL (though I am trying to fix that). Thanks in advance for any help.

Capture.JPG