how to get report https availability with URL??
To get list of Urls and theirs % availability - regardless application it is assigned to, or template it belongs to -
you can use Custom Table with advanced database SQL query like this:
SELECT TOP 10000
cs.Value AS Url,
AVG(daa.PercentAvailability) AS PercentAvailability
FROM
APM_AlertsAndReportsData ard,
APM_DailyComponentAvailability daa,
APM_ComponentDefinition cd,
APM_ComponentSetting cs
WHERE
MONTH([DateTime]) = MONTH(GETDATE())
AND daa.ComponentID = ard.ComponentID
AND ard.ComponentType = cd.ComponentType
AND cs.ComponentID = ard.ComponentID
AND cd.Name = 'HTTPS Monitor'
AND cs.[Key] = 'Url'
GROUP BY cs.Value
If you want to monitor anything by SAM, you need to assign monitor application to some node.
You can create just "External Node: No Status" or "Status Only: ICMP" for some IP address, if you don't need to monitor any true box bounded to the URL.
Assign "HTTPS Monitor" template to the node.
Start edit the new created application, edit the one component, which it has. Set URL to what you want.
You can add component for every URL you want to monitor.
Thanks for your response,I am new for solarwinds product,I have configured HTTPS monitor same as you describe but I don't know how to generate availability report where it can show me for example : https://gmail.com was available 100% last month
Please Help me to get availability report including url.
I am getting everything what ever I want except History Availability .I am unable to find out option for last month.with above SQL query I am getting this-
I don't have idea about SQL could you please let me know how to get below fields-
Thanks
If last month means last 28/30/31 days, then the query should like this:
cs.Value AS Name,
AVG(daa.PercentAvailability) AS PercentAvailability,
ccs.Availability AS CurrentStatus
APM_ComponentSetting cs,
APM_CurrentComponentStatus ccs
daa.ComponentID = ard.ComponentID
AND ccs.ComponentID = ard.ComponentID
AND [DateTime] >= dateadd(m, -1, GETDATE())
GROUP BY cs.Value, ccs.Availability
If last month means - prior month, it should be something like this:
dateadd(m, datediff(m, 0, [DateTime]), 0) AS [Timestamp],
AND [DateTime] BETWEEN dateadd(m,-1,DATEADD(mm, DATEDIFF(mm,0,getdate() ), 0))
AND dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate() ), 0))
GROUP BY cs.Value, dateadd(m, datediff(m, 0, [DateTime]), 0),ccs.Availability
