Page Comparison

...

1. Identifying unmapped applications.
   

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

   Code Block
   language

   Image Removed

   sql

   select * from Application where ApplicationID not

   in (select ApplicationID from MapApplicationDevice)

   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:
   
   
   

...