Ownership groups without knowledge

Shane Bjork
Tera Expert

I am looking for a way to run a report that shows knowledge ownership groups who do not have any articles published in a certain knowledge base. 

 

 

Looking to run an audit looking for unutilized ownership groups to follow up/remove if not needed. 

1 ACCEPTED SOLUTION

Eoghan Sinnott
Kilo Sage
Kilo Sage

Hi Shane, 

 

For reporting on Ownership Groups that are empty, it takes a bit of walking from one area to another but you can get there. Because you're looking to report on values that are empty, there's no record actually created, so instead of reporting from the Knowledge table you'll have to go through the "Groups" route.

 

Create a report on the [sys_user_group] table.

For the group condition add Type contains Knowledge.

Then under related list conditions add Knowledge -> Ownership Group.

Empty Ownership Groups.jpg


Finally for select None as the Quantity. This will show you Knowledge Groups that have no related records associated to them.

 

related records empty.jpg

Regards,

Eoghan

 

Please consider marking my reply as Helpful and/or Accept Solution, where applicable. Thanks!

View solution in original post

4 REPLIES 4

Runjay Patel
Giga Sage

Hi @Shane Bjork ,

 

You can cerate report like below. I have done group by owner but you can do using owner group.

RunjayPatel_0-1731943692150.png

 

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.


Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

 

@Runjay Patel 

 

This would assume that the ownership group has a published article at some point. I am looking for any group under sys_user_group who meets the knowledge group criteria and then count the number of knowledge articles they have published in kb_knowledge under a specific knowledge base. For new knowledge ownership groups, the answer by be they have never created a record in kb_knowledge table, but I still want to include them in the report with "0".  

Hi @Shane Bjork ,

 

based on mentioned details in your question i had given you the answers. Anyway you can achieve this as will but for that you need PA plugin.

Eoghan Sinnott
Kilo Sage
Kilo Sage

Hi Shane, 

 

For reporting on Ownership Groups that are empty, it takes a bit of walking from one area to another but you can get there. Because you're looking to report on values that are empty, there's no record actually created, so instead of reporting from the Knowledge table you'll have to go through the "Groups" route.

 

Create a report on the [sys_user_group] table.

For the group condition add Type contains Knowledge.

Then under related list conditions add Knowledge -> Ownership Group.

Empty Ownership Groups.jpg


Finally for select None as the Quantity. This will show you Knowledge Groups that have no related records associated to them.

 

related records empty.jpg

Regards,

Eoghan

 

Please consider marking my reply as Helpful and/or Accept Solution, where applicable. Thanks!