Hi, our ServiceNow implementation includes an AWS integration and we are currently Tag based mapping. What I want to do is report on AWS CIs that have not been mapped to a Tag based application service.
My plan is to build a report against cmdb_key_value table, then use a Related List Condition against the svc_ci_assoc table to check for zero rows. This isn't available by default and in our Dev environment I have created a relationship (on the CI sys_ids) between the two tables, then added a Related List Condition on the cdmb_key_value form. However, this hasn't resulted in this becoming available in reporting.
I have also tried to create a database view using these two tables but any report returns no rows so I must have used an incorrect "where clause" e.g. tag_cmdb_ci = rel_ci. The "tag" and "rel" are the table alias'.
Can anyone advise what the correct "where clause" in a database view please, or suggest why the Related List Condition is still not available in reporting.
Thanks in advance.
David Pooley
