kevcor

Comments

  • When I search for Exchange in the reports, all I get is the following * Mobile Devices * Users By Mailbox Quota * Users By Mailbox Size * Users By Messages Sent This Week None of these are close to what I want to report on so I can't modify them to fit my need. Am I trying to do something unusual? It seems to me being able…
  • We have SAM. Please forgive my ignorance (I'm trying to get some training setup) but I need to be able to generate a report that shows the health of Exchange for the last month to turn in to management. When I go to Applications then Exchange, I don't see a way to create a report. When I go to Settings then Manage Reports,…
  • Thanks, that was the final piece to this puzzle!
  • Through trial and error I was able to find one that worked right before you replied. Thanks again!
  • The SQL for "Application Availability - Last Month" is DECLARE @utcOffset int DECLARE @actualMonths int SET @utcOffset = datediff(minute, getdate(), getutcdate()) SET @actualMonths = datediff(month, 0, getdate()) SELECT max(ast.[TimeStamp]) as [Month], n.Caption, a.Name AS ApplicationName, sum(ast.PercentAvailability *…
  • I found the report "Application Availability - Last Month" which reports all software including exchange and is over 100 pages long. It's an advanced SQL report for Report Writer. Is there an easy way to edit this report to show only Exchange? Or is there a web-based report that I can use for Exchange availability?
  • Thanks for that. Your day and time filters look similar to mine so that makes me feel better that I'm doing something right. I think I've discovered the root of my problem though. I believe after one month, hourly availability data is no longer available which is why I've been getting results that start one month prior to…
  • That helps. Thanks! But I'm still not quite getting what I need. Following the document you referenced, I was able to filter by business days but business hours is not working right. When I select Time of Day is greater than or equal to 6:00 and less than or equal to 17:59, I don't get any data. (Convert(Char,DateTime,108)…
  • That works, thanks! In the alert email I'm having trouble getting the node name to show up. When the email is received, it has the variable string text instead of the variable value. I would like it to show the node name because that's the name of the web site. Is it because I'm alerting on a Component and not a Node?