Description

In some cases the value for the installed app version will not be removed automatically from TEOS. This guide explains how to remove the app version manually for a specific device.

Requirements

• Sysadmin credentials for SQL Server.
• Admin access to the TEOS web interface

How to remove app version for a specific device in the database

1. On your desktop click on the ‘Start’ Menu and open ‘SQL Server Management Tool (SSMS)’.  
   
    
2. A window will open to login, use the following: Authentication: SQL Server Authentication Login: Use the sa credentials.
   
    
3. In SQL go to: Databases > CustomerDB > Tables.
   
    
4. In the tab ‘Tables’ right click ‘dbo.Devices’ and select ‘Edit Top 200 Rows’. 
   
    
5. In here you can see the ‘ID’ of the devices which you want to adjust. you need the ‘ID’ for the next step.
   
    
6. Once you know which ‘ID’ to use go back to tables and right click ‘dbo.DeviceInformations’ and select ‘Edit Top 200 Rows’.
   
    
7. In here compare the ‘ID’ to the device ‘ID’ from step 5. 
   Now scroll to the back until you see the tabs called: 
   TeosAppVersion,
   TeosControlVersion
   TeosConnectversion
   
   Select which app version you want to remove and rename the block to: NULL.