Video Screencast Help

Event Console report

Created: 08 Jan 2012 | 5 comments

Hi Everyone,

Is there anyone know how to create a report that show all open alerts? That is I need a report to list out all the "open" alert, which same as when I view from the "Event Console" webpart.

I'm now only use the print screen function to show those open alerts. Even click on the IE print function, it cannot show the whole list.

Thanks in advance.

Carmel Lee

Comments 5 CommentsJump to latest comment

Carmelcw's picture

Hi everyone,

Is there anyone can give a cule to create this kind of report?

Thanks in advance.

Joseph_Carson's picture

Hello Carmelcw,

You could try the following query for your report.

Select from ec_alert_pooled  without any filters applied

Carmelcw's picture

Hi Joseph,

Thanks for the SQL statement.

I tried to pull out the result, it show all the alerts (hehe.... around 16K records).

How do I filter out and only show the unsolved alerts? It didn't seems to be just use this query, may be need to join with others?

Thanks and regards,

Carmel Lee

Jameslynch's picture

Hello Carmelcw, 

My apologies for the delay in getting back to you.

I am currently discussing your query with my colleagues in Technical Support and hope to have an answer for you later today.

 

Regards

James 

Jameslynch's picture

Hello Carmelcw 

I would suggest that you look at the following stored procedure _sp_ec_select_grid_view_limit

 SQL query

exec _sp_ec_select_grid_view_limit @row_limit=50000,@culture=N'en'

 

This will show all alerts displayed in event console webpart

 

Regards

James