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:
Asset B9EE0AB2-AE0E-4867-BF4C-41D4A382163B
Computer 493435F7-3B17-4C4C-B07F-C23E7AB7781F
Monitor FE46D9CE-B71C-4DE4-B790-242A9EF1A5D3
Network Printer...