Asset Management Suite

 View Only
Back to Library

Changing Resource Type 

Nov 24, 2008 10:06 AM

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  8E4F62F4-948C-4071-87A0-F39EDFFA9795
Network Resource  ECADDEC9-3178-4FFB-BEB4-D29E0767A79E
Peripheral  09095D15-330C-406C-87EF-CE2A621DCFCA
Rack  37EF20CC-33DE-441D-9860-373E53723258
Scanner  D05FE2CE-4FF2-41CF-9112-AC5FC31D41F1
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.

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
​
Attachment(s)
jpg file
6355.jpg   2 KB   1 version
Uploaded - Apr 10, 2020
 
Download

Tags and Keywords

Comments

Migration User
Apr 29, 2009 02:00 PM

Sorry folks, it is not in CMDB 7.0 but it is high on the potential enhancements for whatever comes after it, i.e 7.1. 

By the way CMDB and Barcode 7.0 are in beta now.  Unfortunately, Asset Management is still months away so you can play with the betas but do NOT upgrade production yet (you will loose Asset Management data such as software license compliance if you upgrade before all of the solutions are at 7.0).

Migration User
Mar 05, 2009 12:26 PM

Does this only work with agents using Inventory solution?  If so, then that may be my problem.  We are running the agents by only collection basic informatin.  We don't have the inventory solution installed on these machines...

Migration User
Mar 05, 2009 12:09 PM

There is a scheduled task that is supposed to do this for Computer resources, to switch them to Virtual Machines.  Does anyone know how this works, or what it uses to determine a Virtual machine?   Its not working for us, and I'm trying to write my own.

Migration User
Jan 02, 2009 10:00 AM

We have had this issue for some time now. Using network discovery we scan ranges and assets are picked up and using network inventory the inventory data is retrieved as well. This works "super" well! Unfortunately, the issue we have had is that some routers and switches come back as Computers.
I cannot wait until the day that this is a changeable item within the Altiris console...do I hear 7.0? Maybe 7.1??? We will see.
-d

Migration User
Dec 03, 2008 07:09 PM

I was always wondering how I could resolve that issue easily. Thanks for the tip - works beautifully!!!!

Migration User
Dec 02, 2008 04:58 AM

I had this issus too and choose the deleting/recreating-way. If I understand correct, the "easy-way" with changing the guid would work (with a few not so fine effects) but Altiris-Support doesn't avise this!?!

Migration User
Nov 24, 2008 03:28 PM

I've had talks with Altiris Support about just changing the resource type versus deleting/recreating the resource. My biggest concern is with resource associations. Only certain associations work with certain types, and certain fields only apply to certain resource types. I'd wonder what would happen to the data in the database when a Monitor resource (changed from a Network Resource) still has DNS host name details tied to its GUID. With Altiris Support, we did change some Fixed Asset resources to Computers and things seemed to work correctly, but the icon displayed for all of those resources in the console never changed to a computer icon; they remained as Fixed Asset icons. Just a slight GUI inconsistency, but I still what else just didn't meld right.

Related Entries and Links

No Related Resource entered.