Jump to content
Changes to the Jaspersoft community edition download ×

How to fetch owner details of a Report


famykhan4u
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

http://community.jaspersoft.com/documentation/jasperreports-server-install-guide/v561/selecting-postgresql-configuration

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...