Hi All,
Could you please suggest how to find the List of URL being Monitored in SAM.
Assuming your component names reflect the website being monitored then you can pretty easily create a table/report of Components that shows the Node Caption, Application Name, and Component Name of any component where the componenttype = 6 or componenttype =14
If the info you need is the way my lab is where the URL info isn't listed there in the names then you would have to dig into the DB a bit, this custom SWQL query seems to work for my environment:
SELECT distinct c.Application.Node.Caption as [Node], c.Application.Node.IPAddress as [IP], c.Application.Name as [Application] , c.Name as Component, case when cs.Value is not null then cs.value when cts.value is not null then cts.value end as URL
FROM Orion.APM.Component c
left join Orion.APM.ComponentTemplateSetting cts on c.TemplateID = cts.ComponentTemplateID and c.componenttype in (6,14) and cts.[key] = 'url'
left join orion.apm.ComponentSetting cs on cs.ComponentID = c.ComponentID and c.componenttype in (6,14) and cs.[key] = 'url'
where cts.Value is not null or cs.Value is not null
You will find that unless you aren't using the defaults at all your url's most likely look like this ^ with ${IP} and ${PORT}. If you get fancy with the new replace() function you could have the report automatically populate those variables with the relevant info but not everyone has that feature yet so I don't want to post up a script that doesn't work for 80% of the user base.
