Is there any possibility to create a report on all alerts configured on each node.
I add this resource on my Node Details page, at least at node level.
There is not a report, and bobmarley’s answer using the widget is the correct way to do what you are asking. Although eventually you will have a situation where a complex alert will appear and it shouldn’t, or it won’t appear in the list and it should. Maybe you get lucky and your alerts are not that complicated, but eventually it is likely to happen.
The only real solution is having good alert scheme and descriptive names. This is usually done with custom properties.
For example you could have a custom property on a node called AlertHours that could have values of 24Hours, Weekdays8to5, etc. Then you create an alerts called “Alert – Node – 24Hours”, another one called “Alert – Volume Critical – 24Hours”, etc. Your alerts use the custom properties to filter what they alert on. Now you report on the custom properties to make sure they are set like you expect and you know which alerts go with that combination of custom properties.
How to use custom properties to organize everything can be simple or really complex depending on how you expect things to work, so it will take some time and planning (and in a few years regret that you didn’t do something different in the beginning).