# Proof of play report probelm
**URL:** https://community.xibo.org.uk/t/proof-of-play-report-probelm/27344
**Category:** Other
**Created:** [May 18, 2022, 10:18am UTC](https://community.xibo.org.uk/t/proof-of-play-report-probelm/27344 "2022-05-18T10:18:09Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Micke\_Salloum](https://community.xibo.org.uk/u/Micke_Salloum)
#### Post date: [May 18, 2022, 10:18am UTC](https://community.xibo.org.uk/t/proof-of-play-report-probelm/27344/1 "2022-05-18T10:18:09Z")
Hi
I am on Xibo CMS V3 and having problem with the proof of play reports. Below is the case
1. If a choose to generate a proof of play report for one media for one day (e.g. yesterday) using display group tags, then i get a complete report
2. If a choose the same but for one week then the CMS start to collect the data (indicated by the gear) and after a short while the gear disappears and no data is provided
Please see images and pdf file here
[Report files (pdf + jpg)](https://drive.google.com/drive/folders/1DAEeyCFPRv6B9wWVq0dKfvj2mVOHmRzB?usp=sharing)
(Sorry, i do not know how to paste images in the post and since I am new user I am not allowed to upload files)
Regards
Micke
---
### Author:  [@Gerard\_Billebault](https://community.xibo.org.uk/u/Gerard_Billebault)
#### Post date: [June 16, 2022, 6:59am UTC](https://community.xibo.org.uk/t/proof-of-play-report-probelm/27344/2 "2022-06-16T06:59:45Z")
Bonjour,
I’ve the same problem.
It is necessary to proceed by schedule because the volumes can be too large for a direct display.
My problem now is that the schedules have been working for 4 months and are no longer providing results.
As if the schedules don’t run at midnight.
Does anyone have a solution
Thanks
---
### Author:  [@Micke\_Salloum](https://community.xibo.org.uk/u/Micke_Salloum)
#### Post date: [June 16, 2022, 3:25pm UTC](https://community.xibo.org.uk/t/proof-of-play-report-probelm/27344/3 "2022-06-16T15:25:14Z")
Hi
A solution could be if getting access to Xibo database and then use MY-SQL front + Crystal Reports to generate reports manually. Anyone knows how to get access to Xibo database (the CMS is on a private server without Docker)
Regards
Micke
---
### Author:  [@Gerard\_Billebault](https://community.xibo.org.uk/u/Gerard_Billebault)
#### Post date: [June 16, 2022, 3:37pm UTC](https://community.xibo.org.uk/t/proof-of-play-report-probelm/27344/4 "2022-06-16T15:37:57Z")
I know with docker …
My SQL access
sudo docker exec -ti xibo\_cms-web\_1 bash
bash-5.0# mysql -u cms -padminmysqlxibo
MySQL [(none)]\> use cms ;
MySQL [(cms)]\> show tables ;
Views
Gérard
---
### Author:  [@Gerard\_Billebault](https://community.xibo.org.uk/u/Gerard_Billebault)
#### Post date: [June 16, 2022, 3:38pm UTC](https://community.xibo.org.uk/t/proof-of-play-report-probelm/27344/5 "2022-06-16T15:38:45Z")
> [@Gerard\_Billebault](#):
>
> xibo\_cms-web\_1
xibo\_cms-web\_1
is the contener (sudo docker ps -a)
---
### Author:  [@Gerard\_Billebault](https://community.xibo.org.uk/u/Gerard_Billebault)
#### Post date: [June 16, 2022, 3:40pm UTC](https://community.xibo.org.uk/t/proof-of-play-report-probelm/27344/6 "2022-06-16T15:40:24Z")
> [@Gerard\_Billebault](#):
>
> mysql -u cms -padminmysqlxibo
Warning: mysql -u cms -padminmysqlxibo
the password “adminmysqlxibo” is pasted to the -p
---
### Author:  [@Micke\_Salloum](https://community.xibo.org.uk/u/Micke_Salloum)
#### Post date: [June 16, 2022, 3:53pm UTC](https://community.xibo.org.uk/t/proof-of-play-report-probelm/27344/7 "2022-06-16T15:53:05Z")
Hi
Thanks Gerard, anyone know without Docker?
Regards
Micke
---
### Author:  [@system](https://community.xibo.org.uk/u/system)
#### Post date: [September 15, 2022, 9:53pm UTC](https://community.xibo.org.uk/t/proof-of-play-report-probelm/27344/8 "2022-09-15T21:53:40Z")
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.