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. 

     


    select * from Application where ApplicationID not in (

    select ApplicationID from MapApplicationDevice)

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


 

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

...