Where can I run a report on all of the customers I have added to Service Desk

[Sara Nicholson]

I just want to run a simple report to tell me what customers are active in Service Desk

[somethingblue]

Hi Sara,

You can run the SQL statement found in How to Get a List of Active Users Counting Towards the JIRA application License:

SELECT DISTINCT u.lower_user_name
FROM   cwd_user u
       JOIN cwd_membership m
         ON u.id = m.child_id
            AND u.directory_id = m.directory_id
       JOIN licenserolesgroup lrg
         ON Lower(m.parent_name) = Lower(lrg.group_id)
       JOIN cwd_directory d
         ON m.directory_id = d.id
WHERE  d.active = '1'
       AND u.active = '1'
 AND license_role_name = 'jira-servicedesk';

You may need to modify the query to fit your environment.  Take a look at How to Get a List of Active Users Counting Towards the JIRA application License for more info.

Hopefully this helps.

Cheers,

Branden

[Sara Nicholson]

Great! Thanks Branden, I will give it a try!

[Jack Brickey]

what do you mean by active? You can easily see all customers for a given JSD project under the Customer page for the project. You can see all customers under the User Management area and the Jira Service Desk screen and then export if you wish.

[Sara Nicholson]

Sorry, new to Service Desk. I am looking for customers we have added to the service desk to allow them to view their requests/tickets. At this time our customers do not make requests, they go thru our support email but we do give them access to view what they have in the system.