Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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)

  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:


 

  • No labels