Auditing on Alerts from the Data Warehouse

System Center Forum - Powershell Tip: Auditing Alerts from the Command Shell in Operations Manager 2007

Thu, 21 Aug 2008 06:55:07 GMT

PingBack from http://www.systemcenterforum.org/powershell-tip-auditing-alerts-from-the-command-shell-in-operations-manager-2007/

re: Auditing on Alerts from the Data Warehouse

Richard — Thu, 02 Oct 2008 18:14:23 GMT

This looks very good Kevin, I have been looking for a report like this, how do i import into opsmgr?

re: how to import

kevinhol — Thu, 02 Oct 2008 18:35:40 GMT

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.aspx

re: Auditing on Alerts from the Data Warehouse

Richard — Fri, 03 Oct 2008 15:28:06 GMT

Thanks for the information, Have you ever tried to map the alert to which management pack raised the alert?

re: Auditing on Alerts from the Data Warehouse

kldsts — Fri, 31 Jul 2009 08:14:26 GMT

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.

re: open alerts pending for closing with respective of operations group instead of users

kevinhol — Fri, 31 Jul 2009 08:22:38 GMT

If you can explain that again in English - I will do my best. :-)

re: Auditing on Alerts from the Data Warehouse

kldsts — Fri, 31 Jul 2009 10:11:31 GMT

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.

re: Auditing on Alerts from the Data Warehouse

kldsts — Fri, 31 Jul 2009 10:55:42 GMT

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

re: Auditing on Alerts from the Data Warehouse

kldsts — Mon, 03 Aug 2009 08:15:14 GMT

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.

re: Auditing on Alerts from the Data Warehouse

kldsts — Tue, 11 Aug 2009 14:28:41 GMT

can come one help me out on this.

re: Auditing on Alerts from the Data Warehouse

kldsts — Tue, 25 Aug 2009 15:48:23 GMT

can some one help me to find the relation between alerts table and operators group ?