When creating a new computer, the System Number value does not auto-generate to the next expected sequence value. However, when the Auto-Generate button is used, the correct value then is generated. Note: This issue affects any resource that uses an Auto-Generate field (denoted by a yellow "*" button), such as Computers, Purchase Orders, etc.
The CMDB default value for the field has been manually saved with a specific number and/or the mask for it has been manually changed. This causes this number to always be used instead of the next number in the sequence. This can occur if a user has viewed the resource in CMDB Default Values and then saved it (which saves the auto-generated number upon opening the edit window for the resource) or changed the value manually and then saved it, or if the user has added a mask or datamask to the data class.
Remove the default value for the affected field so that it is blank. This restores the auto-generate ability for the field, enabling it to use the next number in the sequence. In some cases, the data class for the affected field may have been modified by the user. Changing its Mask, Start number or Datamask may result in this issue or similar problems of having the auto-generate field work correctly. Verify that the default values are present for the affected data class to ensure that these are not an issue.
Depending on the CMDB Solution version, different workarounds and solutions are available. Refer to the appropriate section below for the specific version.
For CMDB Solution 7.1 SP2/7.5 (non-SP1)
These two CMDB Solution versions have a defect that prevents the below workarounds from other sections from working. This issue is resolved in CMDB Solution 7.5 SP1. To resolve this issue in CMDB Solution versions 7.1 SP2/7.5 (non-SP1), the Item table record for the CMDB Defaults must be reset for its System Number value (or which ever field is the issue, such as from Monitors, etc.), then IIS reset. Note: If the user re-saves any default values in the future, they will need to re-apply this SQL solution, as re-saving overwrites the database record each time. This should therefore be avoided, as this function is not working correctly, as noted here.
For Symantec Management Platform 7.0/7.1 (pre-SP1)/7.5 (non-SP1)
For Notification Server 6.0
In SQL, information regarding the auto-generate next sequence number can be found by running the following query:
USE Symantec_CMDB -- For Notification Server 6, substitute this line with "USE Altiris".
This will return results that look something like the following:
Figure 1: Example SQL query showing auto-generate sequence numbers
The AssetTagCounter field is the value of the next number in the sequence. For example, in Figure 1, the POrder00000000 (Purchase Orders) value for it next number in the sequence is 1. The expectation is then that when a new Purchase Order is created, its Purchase Order Number will then be "POrder00000002". If the script is ran again, the AssetTagCounter will then be 2 for POrder00000000. Note: This equals the eight digits of zero for the AssetTagMask "00000000" plus the AssetTagCounter "1", which still results in an eight-digit number.
If the numbers listed here are incorrect, use a SQL script to manually modify them to their correct expected values. For example, if the AssetTagCounter should be 50 for the Purchase Order field, meaning, the next Purchase Order created will be POrder00000051, then use the following example script to modify this:
SET AssetTagCounter = 50
WHERE AssetTagMask = 'POrder00000000'
This will modify the AssetTagCounter line, then run a SELECT query to show the results.
To change the System Number, this is the first column, which has a blank AssetTagMask. The number 838 designates this, and therefore the next System Number to generate would be xxxx839 (depending on the resource). For example, "Comput0000839". The following example script can be used to change this to a different number in the sequence:
SET AssetTagCounter = 100
WHERE AssetTagMask = ''
Any CMDB Solution version.
Subscribing will provide email updates when this Article is updated. Login is required.
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
This will clear the history and restart the chat.