Public.getmanagepercentavailintfwindow (function) - Revision history

Bot at 09:19, 27 August 2011

2011-08-27T09:19:33Z

Bot at 22:38, 24 June 2010

2010-06-24T22:38:50Z

Bot at 07:37, 11 February 2010

2010-02-11T07:37:50Z

Bot at 07:31, 11 February 2010

2010-02-11T07:31:44Z

Bot at 13:52, 7 August 2009

2009-08-07T13:52:38Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''function | public.getmanagepercentavailintfwindow |- |}

 CREATE OR REPLACE FUNCT...

2009-08-07T13:15:55Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''function | public.getmanagepercentavailintfwindow |- |} <pre> CREATE OR REPLACE FUNCT...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''function
| public.getmanagepercentavailintfwindow
|-
|}

<pre>
CREATE OR REPLACE FUNCTION public.getmanagepercentavailintfwindow(integer, character varying, timestamp without time zone, timestamp without time zone)
RETURNS double precision
LANGUAGE plpgsql
AS $function$
DECLARE
nid ALIAS FOR $1;
ipid ALIAS FOR $2;
xtime ALIAS FOR $3;
ytime ALIAS FOR $4;
downtime float8 := 0.0;
count integer := 0;
rollingWindow float := 0;
totalServiceTime float := 0;
BEGIN
IF xtime < ytime THEN
rollingWindow := EXTRACT (EPOCH FROM (ytime - xtime));
downtime := getManagedOutageForIntfInWindow(nid, ipid, ytime, xtime)/1000;
ELSE
rollingWindow := EXTRACT (EPOCH FROM (xtime - ytime));
downtime := getManagedOutageForIntfInWindow(nid, ipid, xtime, ytime)/1000;
END IF;
count := getManagedServiceCountForIntf(nid, ipid);
totalServiceTime := count * rollingWindow;

IF totalServiceTime > 0 THEN
RETURN 100 * (1 - (downtime / totalServiceTime));
ELSE
IF totalServiceTime = 0 THEN
RETURN 100;
ELSE
RETURN -1;
END IF;
END IF;
END;
$function$
</pre>

← Older revision		Revision as of 09:19, 27 August 2011
Line 45:		Line 45:
	$function$		$function$
	</pre>		</pre>
−
−	~~=== References ===~~
−	~~{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"~~
−	~~\|- style="background:silver"~~
−	~~\| '''Dependency Type~~
−	~~\| '''Object Type~~
−	~~\| '''Referenced Object~~
−
−	~~\|- valign="top"~~
−	~~\| Execute~~
−	~~\| Function~~
−	~~\| [[public.getmanagedoutageforintfinwindow_(function)\|public.getmanagedoutageforintfinwindow]]~~
−
−	~~\|- valign="top"~~
−	~~\| Execute~~
−	~~\| Function~~
−	~~\| [[public.getmanagedservicecountforintf_(function)\|public.getmanagedservicecountforintf]]~~
−
−	\|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Function
 | public.getmanagepercentavailintfwindow
 |}
 === Source ===
@@ Line 55: / Line 53: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Execute
 | Function
 | [[public.getmanagedoutageforintfinwindow_(function)|public.getmanagedoutageforintfinwindow]]
-|-
+|- valign="top"
 | Execute
 | Function

@@ Line 1: / Line 1: @@
 == wikibot ==
 CREATE OR REPLACE FUNCTION public.getmanagepercentavailintfwindow(integer, character varying, timestamp without time zone, timestamp without time zone)
   RETURNS double precision
@@ Line 35: / Line 46: @@
     END;
 $function$
 |-
 | Execute
@@ Line 44: / Line 64: @@
 | Function
 | [[public.getmanagedservicecountforintf_(function)|public.getmanagedservicecountforintf]]

@@ Line 7: / Line 7: @@
 |-
 |}
 <pre>