- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-18-2024 07:04 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-18-2024 08:33 AM
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.
Finally for select None as the Quantity. This will show you Knowledge Groups that have no related records associated to them.
Regards,
Eoghan
Please consider marking my reply as Helpful and/or Accept Solution, where applicable. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-18-2024 07:28 AM
Hi @Shane Bjork ,
You can cerate report like below. I have done group by owner but you can do using owner group.
-------------------------------------------------------------------------
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
-------------------------------------------------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-18-2024 07:34 AM
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".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-18-2024 07:40 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-18-2024 08:33 AM
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.
Finally for select None as the Quantity. This will show you Knowledge Groups that have no related records associated to them.
Regards,
Eoghan
Please consider marking my reply as Helpful and/or Accept Solution, where applicable. Thanks!