Information Concerning Reports

So I was asked by my mgmt. if it was possible to produce a report listing all of our active/in-use component monitors and all of our active and enabled alerts. I did some snooping around and fount the "All Configure Alerts" reports which is good. But, it lists all configured alerts to include those that are not enabled. I tried to modify the SQL query so I would only get enabled alerts and I failed miserably (I don't claim to be a SQL guru, not even close). As for the report for all in-use component monitors. Well I have no idea where to even start on that. So I'm turning to the by THWACK Brotherin for assistance / guidance. Again what I'm look for is the ability to pull each of the below listed reports:

1. Listing of all configured and enabled alerts

2. Listing of all in-use component monitors

Thanks in advance

Find more posts tagged with

sam components report

sam report

Accepted answers

vinay.by

Point 1 - Create a Advanced SQL Report/Web Report Custom Table with SQL and give the below mentioned query (this will list all configured and enabled alerts)

SELECT Name FROM AlertConfigurations where Enabled='true'

All comments

vinay.by

Point 1 - Create a Advanced SQL Report/Web Report Custom Table with SQL and give the below mentioned query (this will list all configured and enabled alerts)

SELECT Name FROM AlertConfigurations where Enabled='true'

vinay.by

Point 2 - Are you really sure about this ? All in-use component monitors ? The below query would list all in-use component monitors

SELECT Name FROM APM_ComponentTemplate where IsDisabled='false'

azsmitty

Vunay BY - Thanks your suggestion worked like a champ

azsmitty

Vinay BY - Yes I was sure about the listing for all in-use component monitors. You suggested method worked perfectly and as suspected the list of component is quite long and contains duplicate entries. All of which I figured would happen. But my manager is now happy which in-turn makes me happy. Thanks again