Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.  

    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:


 

Info

Filter by label (Content by label)
showLabelsfalse
max5
spacesCSKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("removing","v3","application") and type = "page" and space = "CSKB"
labelsapplication v3 removing

...