1. On the logical disk space, it shows in KB. How would you get it to show in GB?
We recommend selecting MB as the units you want to see. By just changing it to megabytes, it will automatically change to gigabytes or any other unit as required. Keep in mind that this is true for just about any counter. In most cases, it helps to see what the original counter is capturing the data in.
2. Does the SQL widget run every time the page refreshes?
Yes. Every time the page refreshes, it will reload all the data in V8. This can be helpful and painful at the same time. On the one hand, it is generally a good thing to refresh all of the data, since it may change. This way you know you are getting the latest data as the page refreshes. On the other hand, this can be a reason why your dashboard may be a bit slow, because it runs all the PowerShell and SQL scripts to pull the data for the dashboards. If the scripts take a long time to pull the data, it will slow down the rate at which the dashboard is shown.
3. Can we do alerts based on SQL queries?
This is currently not available in V8. You can create a script that changes the state of the widget. You have to set it up within SCOM ODP monitor template.
4. If a server has pending updates or is in a pending reboot state, is there a way to build and show that?
Yes, it’s possible via PowerShell script/SQL query. You can create a script showing properties values of an object. We don’t specifically have one available, but we have seen it with a couple of our customers. If you’re interested, please contact email@example.com, and we’d be more than happy to work with you on it!