Updating STATE & SUB STATE for BULK Assets

Miza Oliva
Kilo Contributor

Hello All,

I have about 900 devices that I need to change their STATE & SUB STATE. How can I do this in BULK?

I need to change whatever the current states are to MISSING and LOST.

Please advise and thank you!

Miza

1 ACCEPTED SOLUTION

Mike Condon
Tera Expert

If you can get them all on a list a view, you can control click and select the the column the state is in.

find_real_file.png

Then double click to change the state and sub state
find_real_file.png

THen it'll make the changes.

find_real_file.png

 

There may be a way to do it via an upload as well.

Thanks

View solution in original post

3 REPLIES 3

Miza Oliva
Kilo Contributor

Additional info: I have a spreadsheet that has the devices info including the Serial Number which I believe would be the key field used to identify devices in ServiceNow.

 

Mike Condon
Tera Expert

If you can get them all on a list a view, you can control click and select the the column the state is in.

find_real_file.png

Then double click to change the state and sub state
find_real_file.png

THen it'll make the changes.

find_real_file.png

 

There may be a way to do it via an upload as well.

Thanks

Thank you sir!