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
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: