SQL query to change status of assets

[Kreg]

Hi there,

Has anyone ever tried to change the status for many assets via SQL?

We need to change the status for 800 devices.
Based on the serial number lists
Currently there are several states (A/B/C...) I need my 800 serial numbers to be in the "D" state.
Any chance to do that easily ?

Many thanks!
Kreg

[Esben_D]

tblstate has the state ID's of all the states in your installation.
tblassetcustom holds the state of the asset.

So basically, find the state ID you want to switch to. Create an update script with your condition.

[Kreg]

Esben.D wrote:
tblstate has the state ID's of all the states in your installation.
tblassetcustom holds the state of the asset.

So basically, find the state ID you want to switch to. Create an update script with your condition.

Thanks,
Yes very simple in fact 😉