Which table to be used for CI status updates

[Hanumant Madan1]

Dear All,

I have one ask from client, I am wondering which table I should be creating this BR on: cmdb_ci or cmdb_ci_hardware.

Rule needed for the following:

If the Status(install_status) = Absent, Retired or In Stock then the Operational Status should = Non-operational

If the Status(install_status) = Installed then the Operational Status should = Operational

The Operational Status supports the CMDB Health Score Card and CSDM metrics.

Also, I will need to run fix script to run for updating all the records as per above situation, so need suggestion on which table this values should be updated as a best/standard  practice.

Help is appreciated.

Regards,

Hanumant

[SebastianKunzke]

In my understanding I would recommend to do this rule on the cmdb_ci_hardware table, because for me the install status for which you want to do this logic is related to a hardware object (In my understanding). You may clarify for what objects your client would need to logic.

Now to the discussion of the necessity: ServiceNow allows you to do such definition. So in my understanding this BR would be valid. Related to the new lifecycle stages/status you should be aware, that you would need to review that rule, when starting with it. But when starting the migration you also need to do a mapping between one status field (install or operational, NOT AND). But over all the lifecycle stage and status would support your logic. As the install status you mentioned are not in the stage "operational".

You can find the lifecycle stage/status here. 

[Hanumant Madan1]

Hi Sebastian,

Yes, we are majorly looking for hardware CIs in this case.

Regards,

Hanumant