question CMDB Data Manager Policy - Filter not showing records in Community Central forum

CMDB Data Manager Policy - Filter not showing records

gab7001 — Thu, 27 Jun 2024 23:48:01 GMT

I am trying to implement a CMDB Data Manager Policy. Policy Type = Retire, Task Assignment Group = Support. For the Condition Filter I have Class is Computer. In my PDI I have 814 records for Class = Computer. I can see that when I filter directly in cmdb_ci table. However, in the Policy, the filter shows 0 records. I have tried different options, but not much I can change, the filter keeps showing 0 records. Why the filter doesn't show the same than when the filter is applied directly to the table?

Re: CMDB Data Manager Policy - Filter not showing records

Shreya Jain2 — Thu, 01 Aug 2024 08:54:21 GMT

I'm facing similar issue, did you find any solution for this?

Re: CMDB Data Manager Policy - Filter not showing records

gab7001 — Thu, 01 Aug 2024 16:31:01 GMT

Hi @Shreya Jain2 , no, not yet. Just reviewed and the same situation, no matter what condition I put on the filter. However for Attestation the filter works. But I can't understand why the other policy types don't allow the filter to work. Maybe for some reason we cannot apply those policies to CIs? But that doesn't make sense. Hopefully somebody out there can explain.

Re: CMDB Data Manager Policy - Filter not showing records

Ryan122 — Fri, 23 Aug 2024 12:41:14 GMT

Haven't discovered a solution yet. We have the same issue, when we clicked on the show results link after running the filter we found the filter is looking for sys_class_name == empty before any of our queries run:

RLQUERYcmdb_policy_ci_exclusion_list.ci,=0^policy_type=[sys_id]^ENDRLQUERY^sys_class_nameISEMPTY^sys_class_pathINSTANCEOFcmdb_ci

Re: CMDB Data Manager Policy - Filter not showing records

rengala — Wed, 28 Aug 2024 18:41:12 GMT

Ok, for us it was a simple missing element.

We needed to go to cmdb_retirement_custom_definitions and set the active field for cmdb_ci to true. This fixed the retirement issue. From there, assuming you've set up your CSDM Life Cycle Mappings, you should be able to build policies for retirement, archival, and deletion.