How to create a report of the number of users converted from user to contact class?

[Justine Mae Ruf]

Hi everyone,

Is there an OOB way or any way to create a report to show the number of users [sys_user] that were converted from user to contact/changed class from user to contact?

[Maik Skoddow]

Hi @Justine Mae Ruf 

this is a pretty unusual question, and you can report on this if your sys_table is audited. If so, you can take a look on the following article for a reporting approach: https://www.servicenow.com/community/in-other-news/reporting-on-ci-changes-using-history-sets/ba-p/2... 

Maik

[ersureshbe]

Hi, Class is a field to represents the users are part of contact table. Take one record with the sample scenario and Identify audit entry exist for that change then it's a unique id to achieve your requirement.

Instead of manual check, you should write the script (when you write the script you should be very careful and put more and right queries else it will create a performance issue ) or use reports to identify the details.