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
1 Answer:
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-insta...
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%')
Thanks a lot. That worked perfectly.