CMDB CI status is set to numeric value
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-25-2019 11:31 PM
Hi All - We have been noticing a lot of our CIs in CMDB have numeric value in the Status field. Instead of "Installed" it is showing as "(7)". Kindly refer to attached screenshot. Would you know any possible reason this could happen?
Appreciate the advice.
- Labels:
-
Enterprise Asset Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2019 09:34 AM
Do you have any third party integrations or manual imports of cis coming in? Seems like this may be an issue referring to the data import or with the transform map. To me this seems like there's a script in the transform map (or perhaps somewhere else) that's setting the value to the string of "7" rather than the integer of 7 that's supposed to align with the value of 'Retired' (this is 7 OOTB) which brings me to my next question, did the ootb values for choices for the install_status field change?
OOTB for install_status on cmdb:
7 - Retired
1 - Installed
There may be a conflict here with the values for the choices which could be leading to issues as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2019 10:24 AM
Hi Jeff,
Please search for script from where the Status field is being set, It might be the issue that the backend value of installed is something different in your system and System do not have any choice value as 7. So, the script is setting the value as '7' and hence it's reflecting as 7.
Kindly mark my answer as Correct and Helpful based on the Impact.
Regards,
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2020 02:35 AM
Hi Ashley and Chaitanya,
Thank you for taking time and assisting me with my query.
The issue is now resolved.
Some background on what may have happened and how it was fixed.
While we were loading some data into CMDB, the Status had been modified to what was indicated in the excel file i.e. In Stock. Somehow the Status has been overwritten and changed to inactive. This created an issue so we enabled the impacted statuses. That's when we noticed a lot of CIs with numeric Status.
It appeared from the sys_choice LIST that wrong table was referenced in updating the Status for Computers CI - cmdb_ci_computer instead of cmdb_ci table.
We set all the cmdb_ci_computer Status choices to inactive. Issue resolved.
Sincerely,
Jeff
