Changing Resource Type
Ever had an Asset created where the Resource Type is incorrect, or have you had a physical server virtualised, but the Resource Type has remained as Computer instead of Virtual Machine?
Well here's a quick script to change the Resource Type for an individual resource
UPDATE vResource SET ResourceTypeGuid = '2C3CB3BB-FEE9-48DF-804F-90856198B600' WHERE vResource.Guid = '9f679247-fc68-4baf-9042-5571cb79ee64'
In this example, a server, GUID 9f679247-fc68-4baf-9042-5571cb79ee64, has had its Resource Type changed to Virtual Machine 2C3CB3BB-FEE9-48DF-804F-90856198B600.
Common Resource types are:
Network Printer 8E4F62F4-948C-4071-87A0-F39EDFFA9795
Network Resource ECADDEC9-3178-4FFB-BEB4-D29E0767A79E
Virtual Machine 2C3CB3BB-FEE9-48DF-804F-90856198B600
As always ensure you have a backup of the database, and if possible check any of your conversions in a test environment first.