how can i report on users that haven't logged an incident

[dave_edgar]

this is the closest scenario i can describe to what i need to achieve.

How can i report on users that haven't had an incident?

I actually need to find all users that don't have a HR Profile record but the solution should be the same.

I know i can do this but exporting two reports then removing all the users that have logged a ticket but i want to get it in SN.

[Slawek_Radziewi · Accepted solution]

It is quite simple. Create a report on sys_user table using new gui. 

On Related List Condition choose incident->caller relation table and condition Less then 1 or Equal 0.

[sachin_namjoshi]

you can create database view between sys_user and incident to find out users who didn't created incidents.

You can apply same logic for HR profile also and then report on DB view.

Regards,

Sachin

[Marcello Correa]

Hi Dave,

Use Related List Conditions: