CMDB Data Manager Policy

[VShine]

Hello Experts,

I am seeking advise on CMDB Data Manager functionality in Washington DC release.

We are using CMDB Data Manager policy to retire Stale/ orphan CIs in our CMDB. We have defined policy and its retiring CI as expected. Issue is, we are not able to tie back the retired Ci to the CMDBTask. We like to have reporting capability which task is retiring what for future audit purpose. Would love to know how other people/organization are using CMDB data manager.

As once approved, the data manager task is closed & then related list doesn't have any information about which CIs. 

Please advise.

[spgarg04]

Hello, you should be able to see all the CMDBtasks in the cmdb_data_management_task table, please check if any filter is applied. 

[VShine]

Hello spgarg04 - thank you for your response.

cmdb_data_management_task table does list all task but not fulfilling my requirement.

When CMDB data manager task is created, it creates a dynamic list of Ci that match the filter & add it on the CMDB task related list.  Once the CMDB task is close complete, the related list of CIs will be gone (as no Ci will be matching that filter condition). 

My requirement is to ger report on relationship between CMDB Task & CIs that are retired. Which Cis is retired as part of which CMDB task.

[spgarg04]

got it, try checking cmdb_ci_state_management_task_to_ci table, and see if this helps

Please mark my solution accepted if I helped you

[VShine]

I think cmdb_ci_state_management_task_to_ci table is a temporary table which store list of Cis which match the CMDB data manager policy filter. Once the task is close complete, the list will be gone. 

One solution we are trying is to add comment to the individual Cis - "Being retired as part of CMDBTASKXXXX" once status is updated to Retired. This does gives us capability to get list of CIs were retired as part of Data manager task.  But for hardware Ci, when comment is added to the retired CI, CDSM life cycle status is updated to "Non- operational" from "Retired".