Reporting on Articles without translated versions

Mike D3
Tera Contributor

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!

12 REPLIES 12

Parent is the name set in the old releases to map the relationship between the original and translated article, starting from Tokyo (not sure 100%) SN renamed that field to Translated from. 

Arnaldo
Tera Guru

Hello Mike D3 
With the "convention" that English is always the original article,  we have setup this report able to list all published articles and related existing translations .
Translations and related parent.jpg

 

Mike D3
Tera Contributor

I have done similar (glad we are on the same page)... you are using the Pivot Table report for this? Does this catch articles that have no published translations?

Pls look the picture 
Translations and related parent1.jpg

Mike D3
Tera Contributor

Yes, thank you. What is the behavior when the Parent article has zero translated versions? I was guessing it would not show up on that chart at all. Is that correct?