Difference between revisions of "Public.getmanagedoutagefornodeinwindow (function)"

From dbscript Online Help
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Function
 
| '''Function
 
| public.getmanagedoutagefornodeinwindow
 
| public.getmanagedoutagefornodeinwindow
|-
 
 
|}
 
|}
 
  
 
=== Source ===
 
=== Source ===
Line 32: Line 30:
 
$function$
 
$function$
 
</pre>
 
</pre>
 
=== References ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
| '''Dependency Type
 
| '''Object Type
 
| '''Referenced Object
 
 
|-
 
| Select
 
| Table
 
| [[public.ifservices_(table)|public.ifservices]]
 
 
|-
 
| Select
 
| Table
 
| [[public.ipinterface_(table)|public.ipinterface]]
 
 
|-
 
| Select
 
| Table
 
| [[public.node_(table)|public.node]]
 
 
|-
 
| Execute
 
| Function
 
| [[public.getoutagetimeinwindow_(function)|public.getoutagetimeinwindow]]
 
 
|}
 
 
=== Dependencies ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
| '''Reference Type
 
| '''Object Type
 
| '''Referencing Object
 
 
|-
 
| Execute
 
| Function
 
| [[public.getmanagepercentavailnodewindow_(function)|public.getmanagepercentavailnodewindow]]
 
 
|}
 

Latest revision as of 10:19, 27 August 2011

wikibot[edit]

Function public.getmanagedoutagefornodeinwindow

Source[edit]

CREATE OR REPLACE FUNCTION public.getmanagedoutagefornodeinwindow(integer, timestamp without time zone, timestamp without time zone)
 RETURNS double precision
 LANGUAGE plpgsql
AS $function$
   DECLARE
	nid ALIAS FOR $1;
	xtime ALIAS FOR $2;
	ytime ALIAS FOR $3;
	downtime float8 := 0.0;
	orec RECORD;
   BEGIN
	FOR orec IN SELECT distinct ifservices.nodeid, ifservices.ipaddr, ifservices.serviceid FROM ipinterface, ifservices, node where ifservices.nodeid = nid AND ipinterface.nodeid = nid AND ipinterface.ismanaged = 'M' AND ifservices.ipaddr = ipinterface.ipaddr AND ifservices.status = 'A' AND node.nodeid = nid and node.nodetype = 'A'
	LOOP
		BEGIN
			downtime := downtime + getOutageTimeInWindow( orec.nodeid, orec.ipaddr, orec.serviceid, xtime, ytime);
		END;
	END LOOP;
	RETURN downtime;
   END;
$function$