Provide reporting for Alerts view
In our environment where my division handles systems and storage and other IT divisions handle applications like SharePoint and SQL Server, it would be extraordinarily helpful to be able to run a report of all the alerts that are generated so we can send them on to application administrators and/or management. It would also be beneficial to have a way to schedule the report and have it emailed.
Try the search queries here http://blogs.msdn.com/b/dmuscett/archive/2014/10/19/advisor-searches-collection.aspx in the ‘Configuration Assessment (Legacy)’ section. There are a few around Alerts and here’s a new one for what you just asked
Type=ConfigurationAlert Workload:“SQL Server”
You can save it as a ‘Saved Seach’ http://blogs.technet.com/b/momteam/archive/2014/07/25/system-center-advisor-limited-preview-saved-searches-cloud-attach-status-and-usage-and-more.aspx , use it in your dashboard http://blogs.technet.com/b/momteam/archive/2014/10/16/custom-dashboard-in-advisor.aspx
and Export to Excel http://blogs.technet.com/b/momteam/archive/2014/08/29/check-it-out-export-advisor-search-results-to-excel.aspx
Check these other ideas for Scheduling and emailing http://feedback.azure.com/forums/267889-azure-operational-insights/suggestions/6519198-run-saved-search-on-a-schedule-raise-alert-and-or
We are also working on a new format of Assessment which doesn’t produce “Alerts” in their current shape, but a much more effective (we think) presentation – please check out the announcement of the first pack targeting SQL Server http://blogs.technet.com/b/momteam/archive/2014/10/23/new-sql-server-assessment-intelligence-pack-in-advisor.aspx
There is one idea tracking ‘Active Directory’ one, next in line http://feedback.azure.com/forums/267889-azure-operational-insights/suggestions/6519282-please-provide-an-active-directory-intelligence-pa
I am closing this idea with all the info and pointers above – but let us know if you disagree.