Applications that are not mapped to a device

Owned by Conor McCann
Last updated: Nov 03, 2017

When deleting devices using the stored procedure which is located from the iQData > Programmability > Stored Procedures > dbo.DeviceEx_de.

You will be left with applications that are not mapped to a device. The steps to remove these are as follows.

Step-by-step guide

 

  1. Identifying unmapped applications.

    Using the below SQL statement this will give a list of applications that are unmapped from the devices. 

    select * from Application where ApplicationID not in 
	(
	select ApplicationID from MapApplicationDevice
	)

     


    Removing the applications
  2. Using again from the iQData > Programmability > Stored Procedures .
    Using the application IDs that were collected using the SQL Statement in Step 1.
    Add the Application ID to the end of the Procedure.
    Example: