DX Unified Infrastructure Management

Hi,

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.

Thanks.

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