Auditing on Alerts from the Data Warehouse
<!--[if lt IE 9]>
<![endif]-->
Comments
Anonymous
January 01, 2003
PingBack from http://www.systemcenterforum.org/powershell-tip-auditing-alerts-from-the-command-shell-in-operations-manager-2007/Anonymous
January 01, 2003
You can upload the reports I post for the opsDB if you create a data source... and then create a folder to upload them to: http://blogs.technet.com/kevinholman/archive/2008/06/27/creating-a-new-data-source-for-reporting-against-the-operational-database.aspx To import you simply upload the file to a folder. I document how to create reports from scratch - using a SQL query in a basic example here: http://blogs.technet.com/kevinholman/archive/2008/09/03/using-opsmgr-to-see-which-servers-have-not-been-logged-on-to-via-rdp.aspxAnonymous
January 01, 2003
If you can explain that again in English - I will do my best. :-)Anonymous
October 02, 2008
This looks very good Kevin, I have been looking for a report like this, how do i import into opsmgr?Anonymous
October 03, 2008
Thanks for the information, Have you ever tried to map the alert to which management pack raised the alert?Anonymous
July 31, 2009
This is good may i know how can i get a open alerts pending for closing with respective of operations group instead of users. Please help me on this query.Anonymous
July 31, 2009
I want to find the open alerts based on the operator groups. i.e we have operators group and users are assigned in the groups. the alerts are assigned to users now i want to find the count of assigned alerts based on operators group instead of users as given above. please let me know if you are not clear i can give example.Anonymous
July 31, 2009
operator group we have
AV opgroup1 - user1,user-2,user-3 AD opgroup2 - user1,user-4,user-2 EX opgroup3 - user7,user-5,user-3 SQL opgroup4- user6. I need the report as shown below if we have 25 alerts where alerts are assigned user1 - 2 AV alerts , 2 AD alerts. user2 - 5 EX alerts, 1 AV alerts user3 - 2 EX alerts, 2 AV alerts. user7 - 2 EX alerts, user6 - 6 SQL alerts, user4 - 3 AD alerts, user5 - 2 EX alerts, reports should be as below. ---------- ------ ------- AV opgroup1 | 5 AD opgroup2 | 5 EX opgroup3 | 6 SQL opgroup4 | 6
Anonymous
August 03, 2009
Hi Kevin, Hope you understand my requirement. In detail the alerts raised and assigned/ closed based on the operator group we need a count instead of alerts closed by each individual operator as your first script above. Please let me know if you need more details for the request. Thanks in advance.Anonymous
August 11, 2009
can come one help me out on this.Anonymous
August 25, 2009
can some one help me to find the relation between alerts table and operators group ?Anonymous
September 24, 2014
The comment has been removed