Event Console report

[Migration User]

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

[Migration User]

Hi everyone,

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

Thanks in advance.

[Joseph_Carson]

Hello Carmelcw,

You could try the following query for your report.

Select from ec_alert_pooled  without any filters applied

[Migration User]

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

[Migration User]

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 

[Migration User]

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