Report to display users with less than 10 skills

[CV1]

Hello All,

Looking for help to create a report that list users with less than 10 skills.

TIA

[Tanushree Maiti]

Hi @CV1 ,

Under related condition, update it and chk

[Dr Atul G- LNG]

Hi @CV1 

You are doing duplicate work. As I mentioned, you can use the existing reporting and, in the related list section, just change the tab to the Skill table. There’s no need to create a separate database view.

Instead of role table use the skill table (has skill table)

[CV1]

we resolved this via scriptinclude . Its working as expected.
We were not able to select sys_user_has_skill table in the report.
there was no field call repotab;e on the table.
the only way to do this was via a databaseview  and then scriptinclude calling in report
Thank you for the inputs.

[Dr Atul G- LNG]

Good to know. .. so db view work. Please close the thread mate.

[SohamTipnis]

Hi @CV1 ,

You can use the below steps (these steps are from documents, not from me):

Use Database View (Recommended for Accurate Count)

• Create a database view joining sys_user and sys_user_has_skill.
• Join condition: sys_user.sys_id = sys_user_has_skill.user.
• Create a report on this database view.
• Use: Group by → User. Aggregation → Count.
• This will show the number of skills per user.

You can use the below articles:

https://www.servicenow.com/community/developer-forum/show-users-who-report-to-me/m-p/3115114

https://www.servicenow.com/community/developer-forum/how-to-create-a-report-to-only-show-where-count...

If you find my answer useful, please mark it as Helpful and Correct. ‌‌‌😊

Regards,
Soham Tipnis
ServiceNow Developer ||  Technical Consultant
LinkedIn: www.linkedin.com/in/sohamtipnis10