maya.public

Parameters

Name	Type	Mode

Definition

DECLARE
    numberOfRecords integer;
    size            integer;
    devices       integer[];
    idDevice         RECORD;
BEGIN

size := 0;
    FOR idDevice IN SELECT distinct(port.iddevice)FROM port
    LOOP

EXECUTE 'SELECT count(*) FROM serialcfg 
                        INNER JOIN port ON serialcfg.idport = port.idport 
                        WHERE port.iddevice =' || idDevice
        INTO numberOfRecords;

IF numberOfRecords > 3 THEN
           devices[size] :=  idDevice.iddevice;
           size := size + 1;
        ELSE

EXECUTE 'SELECT count(*) FROM serialcfg 
                            INNER JOIN port ON serialcfg.idport = port.idport 
                            WHERE port.iddevice =' || idDevice || 'AND alias_port NOT IN (0,1,2)'
            INTO numberOfRecords;

IF numberOfRecords > 0 THEN
               devices[size] :=  idDevice.iddevice;
               size := size + 1;
            END IF;

END IF;

END LOOP;

RETURN devices;
END

find_devicesnotnormal()

Parameters

Definition