I have a report that is sent to management on a daily basis that shows any devices that are down at the beginning of the day. The scheduled report works fine. Management wants to see the # of nodes down, in the email subject line. I know that this can be done with a short sql or swql query but I do not know how. Any assistance is greatly appreciated.
