Long time lurker, first time poster - fingers crossed and thanks in advance for any help anyone can contribute.
In our instance we leverage parent/child translations. We have added a Country field to all articles, treating all English articles labelled as Global to be the Parent article which needs to be translated into all 4 non-English languages we support (Japanese, Malay, Traditional Chinese, Simplified Chinese).
Problem statement: Knowledge governance would like a report/dashboard that alerts them to any Published, Global English article that is not translated into all expected languages (or none at all). So I need to be able to show them, for all Published/English/Global articles, all gaps where that article does not yet have Published Child articles in all of those 4 languages listed above. I have looked at kb_2_kb and I have attempted using Interactive Analysis on kb_knowledge. I just can't get to a report for the absence of required child articles. I would prefer to keep users in ServiceNow and find a way to integrate this information on a dashboard for them.
I have created a List report off of kb_knowledge (reporting off the Parent field), grouped by Parent that indicates how many translated versions there are but it's clunky, ugly and does not indicate where there are 0 translated versions...
Any help would be greatly appreciated!
