Skills Reporting

david_walters
Mega Expert

Hi,

 

Does anyone know how you report on the Skills users have?

 

E.g. I'd like to run a report that shows all the skills in org and who has those skills and to what level.

 

thanks,

 

David

4 REPLIES 4

Ashish Kumar Ag
Kilo Guru

Hi David,


Is skill and user are related through any table?


Then we can do it through reporting.


Otherwise you have to create a Database view for user and skill, then on that table you can do the report.


Hi,



I think they are related as you can see what skills a user has when looking at that user directly.



- David


Hi David,



This is the table "sys_user_has_skill" (i.e Related list) which can be used to report.


You have to create a database view on the above table and then create a report. Please take a look on the report which I have created on demo


https://createnow014.service-now.com/sys_report_template.do?sysparm_create=true  



Please mark your question as answered if resolves your issue.



Thanks,


Pradeep Sharma


dlb44
Giga Contributor

I had the same question.   I had an ACL which should have enabled me to report on the table but still couldn't report on the 'User Skills /sys_user_has_skill' table.   I was then reminded of the 'glide.ui.permitted_tables' property which is a comma separated list of system tables that are reportable.



Dave