Applications that are not mapped to a device

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

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
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: