Resource Association Diagram

A software purchase rule with a win32 license should automatically create the association with the inventory scan.

How would I go about this? I'm not familiar with Asset Management and CMDB.

I'm going to try this out in my dev enviorment but it seems like there is an eisier way to do this

Article ID: 46677

How to create a CMDB Rule that will perform the computer to location association?
Applies To

• CMDB Solution 6.5

Question

The NS contains a large number of computer resources and a requirement has been made to associate these resources with their locations. As the resources already exist in the database, importing them from a data source has not been chosen as an option. How can a CMDB Rule perform these associations based off of the first two letters of the computer name?

Answer

The folloiwng CMDB Rule will perform the requested action:

Name: Assign AB Computers to their AB Country Location
Description: This rule will move all AB resources to the root of the AB Location based on the first two letters of the computer location name.
Resource type: Computer
Target using: SQL Query

SELECT i._ResourceGuid FROM Inv_AeX_AC_Identification i
LEFT OUTER JOIN ResourceAssociation ra ON ParentResourceGuid = i._ResourceGuid
AND ra.ResourceAssociationTypeGuid = '05DE450F-39EA-4AAE-8C5F-77817889C27C'
WHERE i.[Name] LIKE 'AB%' AND ra.ParentResourceGuid IS NULL

Forward Associations
Name: Location
Type: Asset to Location
Lookup Key: Value
Key Column Mappings: AB Location

The information contained in the Altiris Knowledgebase is subject to the Terms of Use as outlined at http://www.altiris.com/legal/termsofuse.asp.