SQL Script - Set All the Device within a folder to Uninnstall

Set All the Device within a folder to Uninnstall

Written by Giuseppe

Last published at: April 14th, 2023

Query Description

Set all the Device State within a specific folder to Uninstall

Folder Name example = Terminated_SRW


Before the query

After the query 

Query


update DeviceSlims

  set DeviceState = 2  -- set the state to Uninstall

  where FolderId = 'A3364F0B-BC14-4420-AA48-1624B87E2D0E'


  select next value for SEQDeviceSlims




update DeviceSlims

  set DeviceState = 1  -- set the state to Disabled

  where FolderId = 'A3364F0B-BC14-4420-AA48-1624B87E2D0E'


  select next value for SEQDeviceSlims