Report : List of reports by role

[mnoland2]

I want to create a report that has a listing of all the reports I have on my Jasper server and what "role" has access to that report.

has any one done this or have any ideas on how i would go about this ?  

 

I have createed a report of user by role (see code below)  if everything went well I would want to join this up to a list of reports this  user has access to

 

Code:

SELECT  "jiuser".username	, "jiuser".fullname	, "jirole".rolename	, "jiuser".enabledFROM 	(public.jiuserrole "jiuserrole"	INNER JOIN	public.jirole "jirole"	ON ("jiuserrole".roleid = "jirole".id))	INNER JOIN	public.jiuser "jiuser"	ON ("jiuserrole".userid = "jiuser".id)  ORDER BY "jiuser".username ASC