/* select machines where the time it last reported was more than 15 minutes ago */
SELECT f_machineID, f_lastreported from tb_machines where f_lastreported < DateAdd("n",-15,now())
	
    /* start looping through the recordset */
	FOR EACH ITEM IN recordset
   
    	/* select machines that match the current record */
    	SELECT f_machineID from tb_machines where f_machineID = currentrecord("f_machineID")
        	
            /* if machine does not have an alert already, then create an alert */
            if recordset is empty then
            	
                	INSERT INTO tb_alerts (f_alertname, f_alertgenerated, f_machineID) VALUES ('Machine Not Reporting', now(), currentrecord("f_machineID"));
            
            end if
    
    LOOP

INSERT INTO Residents (Name, Occupation)
    SELECT Name, Occupation FROM Immigration 
    WHERE Residency = 'granted'; 

INSERT INTO tb_alerts (f_alertname, f_machineID,f_alertgenerated)
      SELECT f_alertname,
             f_machineID, 
             f_lastreported 
        FROM tb_machines 
       WHERE f_lastreported < DATEADD(minute , DATEDIFF(minute , 0, getdate())-15, 0)