TechColumnist Storage Information Blog

1Aug/070

SMS Site Status

This is a "dashboard" report that shows the current SMS site status.

SELECT TOP (100) PERCENT SiteCode, CASE Status WHEN 0 THEN 'OK' WHEN 1 THEN 'Warning' WHEN 2 THEN 'Critical' ELSE 'False' END AS [Level], Updated
FROM dbo.v_SummarizerSiteStatus
ORDER BY Status DESC, SiteCode

SMS Status Example

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • Technorati
  • Twitter

Enjoy this article?

Consider subscribing to our rss feed!

About Tom Lasswell

about myself.
Tagged as: , Leave a comment

This website uses IntenseDebate comments, but they are not currently loaded because either your browser doesn't support JavaScript, or they didn't load fast enough.

Comments (0) Trackbacks (0)

No comments yet.


Leave a comment


No trackbacks yet.

« VMware / MS VM / Real / Total Count # of updates per month »

Tags

blog cacti camera cluster ConfigMgr Datacenter datadomain dfs finances fun gx home iphone isy netapp network opsmgr phone photos reporting san SCOM script sms2003 sql srm toy uptimedevices vmware work xbmc

Personal

  • Me on LinkedIn
  • Twitter

Vendor

Recent Posts

Archives