Is there a way to have a report that show all the SQL Error Logs for all my SQL servers that have AppInsight for SQL applied to them?
Here i have created quick how to hope it helps
step 1 - create a report
step 2- select your nodes that have the App assigned
step 3 - enjoy
Are you able to add two instances? Mine will only let me select one and not all my SQL instances. I would like one report that shows all my instances sql errors if possible.
never mind, I see how to do it now. thanks for the quick reply!!!
was about to write up a message back no problem
you wouldn't happen to also know how to have it show more than 5 items at a time would you?
you have this filter?
yes, but even though I set it to 10 it always reverts back to 5
if you go to the node that has the application installed and change the filter here you should be able to then change it in the report.
it always reverts to 5 for me, either at the node/instance level or in the report.
Maybe you only have 5 errors? unlike mine lol.
How many 'Display Objects' do you have in total?
also check your time period, you might only be polling the last 15 minutes mines 24 hours
so you are able to change yours to show say 20 and you hit refresh on that same page and yours sticks at 20 and does not revert back to showing only 5?
just refreshed it defaults to 5 didn't realize that is what you were asking
i re built the report but no default filters
Anyway to filter this so that it only shows errors in the log of a particular type?
