We have configured net_connect probe for windows servers to extract availability report of all the servers for 1 month.
Can you please help me to extract this availability report for the servers.
The Net_Connect probes calculates the response time and generates QoS based on that.
In order to create a availability report from the metrics being fetched by net_connect, you might need to create a SLA report for the requirement
The SLA Reports Portlet - CA Unified Infrastructure Management - 8.4.7 - CA Technologies Documentation
A simpler option might be to configure the devices in ICMP probe for Service Availability monitoring which can directly be pulled from UMP as Availability.
icmp (Internet Control Message Protocol) - CA Unified Infrastructure Management Probes - CA Technologies Documentation
You can use this SQL query to return the information, you'd have to create a UR or CABI report with it though. You should only need to modify line 28.
DECLARE @SQL NVARCHAR(1000)DECLARE @RTABLE VARCHAR(50)SET @RTABLE = (select distinct r_Table from S_QOS_DATA where qos='qos_url_response')SET @SQL = ' select [Target], [Available], [NotAvailable], CAST(CAST([Available] * 100.0 AS Numeric(10,2)) / sum([Available]+[NotAvailable]) as Numeric(10,2)) as [Percentage] from ( select s.target as [Target], sum(case when [value] IS NOT NULL then 1 else 0 end) as [Available], sum(case when [value] IS NULL then 1 else 0 end) as [NotAvailable] from S_QOS_DATA s join (select DATEPART(yyyy, r.sampletime) as [sampleyear], DATEPART(mm, r.sampletime) as [samplemonth], DATEPART(dd, r.sampletime) as [sampleday], r.samplevalue as [value], r.sampletime as [time], r.table_id from ' +@RTABLE+ ' r join (select distinct table_id from ' + @RTABLE + ') rr on r.table_id = rr.table_id ) rx on s.table_id = rx.table_id where s.target like ''%tix%'' group by s.target ) b group by b.target,b.Available,b.NotAvailable 'EXECUTE sp_executesql @SQL
Retrieving data ...