Jump to content
Changes to the Jaspersoft community edition download ×

How to fetch owner details of a Report

Go to solution Solved by reportdev,

Recommended Posts

Hello Guys,

I am stuck with a problem & need help for the same. I have different versions of executed reports saved on the Jasper Server with data(.pdf, .xls etc). By using the database I want to know the owner of those file.

Since the database schema is very new to me I am unable to fetch the desired result.

I want to know the owner & the Url of all such files.

Any help would be great. Thanks in advance..!!!


Thanks & regards,

Fahim Khan

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

  • Solution

the jasperserver uses postgres database and this database can be accessed from the pgadmin tool.

Add a connection in pgadmin to your postgres database. check this site


In the jasperserver database, execute below query in pgadmin and it will return the required resultset.

select jr.id, jr.name, jr.label, jr.creation_date,ja.user_id, ju.username
   From jiresource jr, jiaccessevent ja, jiuser ju
where jr.id = ja.resource_id
and ja.user_id = ju.id
and (jr.name like '%.pdf' or jr.name like '%.xls%')

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...