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

From dbscript Online Help
Jump to: navigation, search
 
Line 37: Line 37:
 
$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"
 
−
| Select
 
−
| Table
 
−
| [[public.ifservices_(table)|public.ifservices]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Table
 
−
| [[public.ipinterface_(table)|public.ipinterface]]
 
−
 
−
|}
 
−
 
−
=== Dependencies ===
 
−
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
−
|- style="background:silver"
 
−
| '''Reference Type
 
−
| '''Object Type
 
−
| '''Referencing Object
 
−
 
−
|- valign="top"
 
−
| Execute
 
−
| Function
 
−
| [[public.getmanagepercentavailintfwindow_(function)|public.getmanagepercentavailintfwindow]]
 
−
 
−
|}
 

Latest revision as of 11:19, 27 August 2011

wikibot[edit]

Function public.getmanagedservicecountforintf

Source[edit]

CREATE OR REPLACE FUNCTION public.getmanagedservicecountforintf(integer, character varying)
 RETURNS double precision
 LANGUAGE plpgsql
AS $function$
   DECLARE
	nid ALIAS FOR $1;
	ipid ALIAS FOR $2;
	orec RECORD;
	counter float8;
   BEGIN
	counter = 0;
	FOR orec IN SELECT DISTINCT ifservices.nodeid, ifservices.ipaddr, ifservices.serviceid 
		FROM ipinterface, ifservices 
		WHERE ifservices.nodeid = nid 
			AND ifservices.ipaddr = ipid 
			AND ipinterface.nodeid = nid 
			AND ipinterface.ipaddr = ipid 
			AND ipinterface.ismanaged = 'M' 
			AND ifservices.status = 'A'
	LOOP
		BEGIN
			counter := counter + 1;
		END;
	END LOOP;
	RETURN counter;
   END;
$function$
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.getmanagedservicecountforintf_(function)&oldid=2991"