Business Application Certification Quarterly getting assigned to Inactive Users.

[SS1510]

CMDB tasks are being assigned to inactive users.I have reviewed the Reference qualifier for Assigned To , filter is there for active = true. 
Is there any other way to check in CMDB Task?

[lpruit2 · Accepted solution]

Greetings @SS1510. I'm assuming you are using a Data Management Certification policy within the CMDB Workspace to generate these CMDBTASKs for Business Applications? If so, there is probably a backend Script Include that is scripting the Assigned to value which will override the Reference qualifier on the field. To prevent this, you could filter out these records before the CMDBTASKs are generated. When you open the Data Management policy > Data Filter > you can update your Condition Builder to exclude those records with Inactive Users. I'll include a screenshot below. If you are assigning these CMDBTASKs to the IT Application Owner, you can dot-walk further into the IT Application Owner and filter on Active = true. 

[SS1510]

@lpruit2 
I have attached the screenshot . Please confirm is this correct way?

[lpruit2]

Greetings @SS1510. That looks good to me. Feel free to add additional statements within the Condition Builder to further filter out any Business Application records that you do NOT wish to certify. You could also add the filter condition of IT Application Owner is NOT empty but the IT Application Owner is most likely mandatory so this condition step may not be needed. Great job!

Active = true -> This will filter out any Business Application that is inactive

IT Application Owner . Active = true -> This will filter out any IT Application Owner that is no longer Active.