Knowledge Block Reporting Help

[JD292]

Hi All,

I am trying to create a report that shows if I have a published knowledge block that is not being used by an article.

We have about 400 blocks and I don't want to go through each one to view the related tabs to see if block is being used.

A report that shows true/false if the KBB block is being used or it would also be helpful if the report could give the KB# of the article the KBB block is being used on. Either would be really helpful.

Thanks so much,

J Dean

[ChristinaMillr1]

Did you ever find a solution to this?

[Peter102]

Hey,

Replying to this even though it is an old post as I had the same issue and this post came up in my search. 

If you run a report on the kb_knowledge_block table:

and then add a related list condition:

That will give you a list of all Knowledge Blocks which do not have an associated Knowledge Article. Worth noting that if the Knowledge Block is in Draft state, then it will show up in this report even with linked knowledge articles. I believe that this is because the draft article version is not linked to the Knowledge article but the published version is.

Peter

[JD292]

Hi @Peter102 , thanks for looking at this. I followed the steps you provided and am not getting anything returned. Do I need to add any conditions outside of selecting the KB Knowledge to Block History table? 

Thanks!

J Dean