CMDB right click function Assign to Location fails to work

Article:TECH199132  |  Created: 2012-10-30  |  Updated: 2013-05-02  |  Article URL
Article Type
Technical Solution


When using the right click CMDB function for a resource, Assign to Location, this fails to work.


CMDB 7.1 SP2 MP1


Defect, Etrack 2981472.

The cause of the issue is the stored procedure spsetAssetLocation.


This issue will be resolved in a future version of CMDB.

Workarounds include:

  • Edit the resource and change it's location there, not through the right click assignment menu.
  • Or, run the attached SQL script in Microsoft SQL Server Management Stuido to alter the stored procedure which will resolve the issue and right click assignment will work. Note: It is recommended to backup the Altiris database before making this change.


SpSetAssetLocation.txt (3 kBytes)

Article URL

Terms of use for this information are found in Legal Notices