SQL Script - Set All the Device within a folder to Uninnstall
Set All the Device within a folder to Uninnstall
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