Calculate overall availability

Anonymous — Mon, 15 Jan 2018 03:31:25 GMT

Hi All,

I’m working for poc. My kips are overall availability and unavailability for device and Location wise.

I have Unavailable data(which are in Down). I need availability of that devices and 100% availability of the rest of the devices (which are not in Down). How to do this.

Below code is only for affected Devices. i need same data with 100% Availability of Devices which are not in Down.

LOAD

Affected_ID,

Date(Affected_Date,'MM/DD/YYYY')as Affected_Date,

Month(Affected_Date) as Affected_Month,

Year(Affected_Date) as Affected_Year,

MonthEnd(Affected_Date) as MonthEnd,

"Affected Device",

"Affected Location",

"Affected Location" as $geoname,

Time( "From ",'h:mm') as From,

Time("To ",'h:mm') as TO,

interval(time("To ", 'hh:mm') - time("From ", 'hh:mm'), 'hh:mm:ss')as "Outage Duration",

((interval(time("To ", 'hh:mm') - time("From ", 'hh:mm'), 'hh:mm'))/time('24:00', 'hh:mm'))*100 as Unavailability%,

Interval(time('24:00', 'hh:mm')- (time("To ", 'hh:mm') - time("From ", 'hh:mm')),'hh:mm')as "Overall Availability",

((Interval(time('24:00', 'hh:mm')- (time("To ", 'hh:mm') - time("From ", 'hh:mm')),'hh:mm'))/time('24:00', 'hh:mm'))*100 as "Overall Availability%"

FROM [lib://QVD/Unavailable_info.QVD]

(qvd);

Pls help me.

Regards,

Krishna.

topic Calculate overall availability in App Development

Calculate overall availability