Configuring Key Performance Indicators for CMDB - Documentation for BMC CMDB 19.11
James Rogers
Completeness Weightage Calculation
This section describes the calculation used to determine the completeness of a CI.
The Completeness calculation assigns the highest score to attributes that have Priority= 1 and the score decreases by 0.3% down the priority ranking.
If there are multiple attributes sharing the same ranking, the score is distributed equally among those attributes. The total score of a CI is a sum of the scores of all non-null attributes. A pre-decided range of scores decides whether the CI can be qualified as Complete or Incomplete. In this case, the criteria is 50%. On the CMDB Dashboard, those CIs that are Complete are displayed in the Green band, whereas those CIs that are Incomplete are displayed in the Red band.
Example 1
To understand the calculation, let us consider class BMC_Document that has attributes and its priorities assigned as follows:
- Attribute1 with Priority = 1
- Attribute2 with Priority = 2
Attribute1 is assigned a weightage of 50% because its Priority = 1.
Attribute2 gets a weightage which is 0.3 % lesser than Attribute1 because it has a Priority = 2.
As per the original Standard Identification rule, if Attribute1 has a missing value, then the CI is considered as Incomplete even though the Attribute2 with priority 2 has a value.
Now, you can add new attributes to a class and define its priorities for the Completeness KPI.
Let us assume that we define two more attributes to this class BMC_Document, which are:
- Attribute3 with Priority = 1 and
- Attribute4 with Priority = 2
When all the four attributes are populated, their weightage is as shown in the following table:
| Attribute | Priority | Weightage |
|---|---|---|
| Attribute1 or Attribute 3 | 1 | 50% |
| Attribute2 or Attribute4 | 2 | 49.85% [Its weightage is 0.3 % lesser than Attribute1 or Attribute3 because it has a Priority = 2] |
Depending on which attributes have values, the completeness score is calculated as follows.
Combination | Expected | Reported as Incomplete? | Reason | |
1 | The value of Attribute1 is missing, but values of the other attributes are present. | Complete CI | No | Attribute3 is present which has weightage of 50% If a Priority =1 attribute is present it takes a weightage of 50%. As the criteria for completeness criteria is satisfied, the CI is marked as complete. |
2 | The value of Attribute3 is missing, but values of the other attributes are present. | Complete CI | No | Attribute1 is present which has weightage of 50% If a Priority =1 attribute is present it takes a weightage of 50%. As the criteria for completeness criteria is satisfied, the CI is marked as complete. |
3 | The values of Attribute1 and Attribute3 are missing, but values of the other two attributes are present. | Incomplete CI | Yes | It is an incomplete CI because both attributes of Priority =1 are missing. |
4 | The values of Attribute2 and Attribute4 are missing, but values of the other two attributes are present. | Complete CI | No | It is a complete CI because both attributes of Priority =1 are present. |
Example 2
Let us consider another example of BMC_ComputerSystem class that has Serial No, Token Id, Hostname, and Domain attributes having priority 1.
According to the completeness calculation, the weightage for attributes of priority 1 is 50%. When four attributes have priority 1, each attribute is assigned a weightage of 12.5%.
Let's assume that we have four computer system CIs, Comp1, Comp2, Comp3, and Comp4 with attributes populated as follows:
| CI | Attributes populated | Is the CI complete? | Reason |
|---|---|---|---|
| Comp1 | Token Id attribute only | No | Token Id has a weightage of 12.5% which is less than 50% . |
| Comp2 | Token ID and Serial No attributes only | No | Token ID and Serial No attributes have a weightage of 12.5% each, which totals to 25%, and is less than 50%. |
| Comp3 | Token ID, Serial No, and Hostname attributes | No | Each of the attributes has a weightage of 12.5%, which totals to 37.5% and is less than 50%. |
| Comp4 | Token ID, Serial No, Hostname, and Domain attributes | Yes | Each of the attributes has a weightage of 12.5%, which totals to 50%. As the criteria for completeness criteria is satisfied, the CI is marked as complete. |