Written by The below modifications have now been re-coded into an easy to install plugin. The plugin is currently available on 1.10 installations for $50. Additional details, support information and community boards are coming very soon at a new website.
Available Time Ranges
Today
Yesterday
This Month
Last Month
Last 30 days
This week (Sun-Sat)
Last week (Sun-Sat)
This business week (Mon-Fri)
Last business week (Mon-Fri)
This year
Last year
All Time
Manual dates entry
Available Reports
Tickets per Department
Tickets per Group
Tickets per Team
Tickets per Day
Tickets per Month
Tickets per Staff
Tickets per Help Topic
Tickets per Client
Tickets per Organization
Replies per Staff
7.0 Updates:
Time to Resolution for all reports
THREE new reports!
Tickets per Organization
Tickets per Group
Tickets per Team
Visual
Control the color scheme on the reports page
Administration
Default Report Type (automatically loads this report when the “Reports” link has been clicked)
Default Report Time Range
Quick Stats toggle (Easily show/hide quick stats)
Default Email (Don’t want to type in the optional email address each time? Set a default)
When emailing in the payment please include what version of osTicket you will be using. There are different files for different versions of osTicket.
Thank you everyone and I look forward to your input into future releases!
Demo now online! I’ll try to get some more data added to this as soon as I can.
http://reportsdemo.sudobash.net/scp
Username: demo_admin
Password: reportsDemo
Note regarding demo. The database for this will be restored every day so we don’t get a bunch of crap loading up in it from anyway goofing around, etc. Also the staff table is restored every single minute, so don’t bother making extra users, etc 😉
Hi Scott
Thank you for your hard work.
Can you guide me how to make a donation?
Top right, above the “GO” button 🙂
Hi Scott,
I am interested in this Mod. How would I make the donation to get this full version?
Thanks for this awesome mod.
Hi Warren, thanks! The donate button is at the top right of the page above the search/go area.
Hi Scott,
I got the zip file, but in which dir do these files go into? Not a coder but know enough to be dangerous LOL
hehe, np. Just put the zip file in scp/ and open it there. Then just make sure everything has the correct permissions for the web server use (usually apache, httpd, or www-data).
Just out of curiosity – Any new functionality with 6.0 version? ( Looks like the ChangeLog Link still needs to be updated )
Thanks again for the Great MOD Scottro!
Nothing just yet, initial release is just compatibility with osTicket 1.7. More is planned though.
Hey,
Nice website. By the way, saw you 160 production osTicket theme and I am interested. Send me an email (as I couldn’t find any contact form on your blog).
Do you have more osTicket templates?
Cheers,
The 120 Production theme doesn’t yet work with osTicket 1.7 but I’m going to be working on getting a new version that will be soon. Presently it’s my only template but I’m thinking about making more.
Hi Scott;
I am trying to find out if your 120 Productions SCP skin is suitable for 1.7 use can you confirm?
http://osticket.com/forums/showthread.php?p=40682
S
The 120 Production theme doesn’t yet work with osTicket 1.7 but I’m going to be working on getting a new version that will be soon.
hi,
i have just donated for the script – please advise how to download it.
regards
steve
I installed and made the changes following the above steps.
But when I try to login in admin section, I am getting nothing only blank page.
Can you please provide me step by steps how to go about?
Regards,
TK Gopu
Hi,
Any reply to my above query?
I am getting the login screen sometimes and when I input the admin details, I am getting the blank page. Please help me. I am using:
OSTicket 1.7
Firefox 22
Windows 7
Apache 2.2.17
PHP 5.3.5
MySQL 5.5.8
Regards,
TK Gopu.
Make sure you have the right permissions on the reports_admin.php file and also check your error log to see if there is anything useful in there.
Hello Steve, Thank you very much for the great,great job u did for us. Now, me and my company are enjoying the result of your job.
The report module is working great, just to ask you something which my boss is askng me to do, and I don’t have any idea:
If I go into report criteria, choose report type and select ‘tickets by help topic’, and submit, there is a field called ‘null’, which maybe is a default for tickets with no help topic. I want to modify it and call it for example ‘others’.
Please help. Or if any other can intervene, i will be more than happy.
Thx
Is there a report that groups on who the ticket is from? To show that this person submitted x tickets and that person submitted y tickets, etc.
Yep, sounds like you are looking for “Tickets by Client”. 🙂
Great! Thanks!
good day, please I request your help, I have installed locally ostickets I mean at 127.0.0.1, and it works perfect, the problem is that when you include the reports module, to change or replace the file header.inc . php with the correct module code, the system will not charge more, this returns a 500 error. if i use it on a web server if it works perfect, but locally not work I do not know what could be?
If you are getting a 500 error message there should be something helpful in your error log. See what that says and if you need any help let me know what the error is and I’ll do what I can to help.
Well, I thought I followed everything correctly. But after logging into scp and navigating to reports.php I see messages like this: Can’t open reports_csv/Report_1374457836.csv. Also get that when trying to run a report.
Also for reports_admin.php I get Unable to load the webpage because the server sent no data. Error code: ERR_EMPTY_RESPONSE.
I figure I probably need to do something with permissions or something, but I am not sure what or where to do it.
Yep, first thing to check would be the permissions. Also, make sure everything is dumped into the scp/ folder. If that all appears correct check your web servers error log and see if there is anything helpful in there. Feel free to email any errors in the log to me and I can work with you to get it all resolved.
Cheers,
Scott
I did all the steps that are shown above, but whenever I try to click on the reports link in the scp page it comes back with a blank page. Is there something that is missing such as reports php? do you include that when you make the donation?
Yes, if you haven’t donated there are dozens of files you would be missing.
Hi Scott,
We are very interested with this but do you have any demo available? I am not sure if this mod has the reporting feature I am looking for.
Thanks
I don’t just yet, I hope to be setting one up tomorrow night though!
Demo is now up and I’ll be posting information for it in the next few minutes. 😀
Hi, I was watching the mod I think, is very good congratulations.
would be interested to have it but we would need to know if you have any study reporting the time spent with each client from one period of time, for example you can have the following data
client, date, ticket number, time spent, ticket status?
I agradeze your comments
Hello Scott ,
After, many issues , your reports Mod Works well.
I’ve Internationalize it with gettext, in french.
Is it possible to add a PDF export button in next release near csv export. It could be very interresting. I try to work on it , with html2pdf but it does’nt work properly.
Many thanks for your work
Bruno
hi Scott,
we receiving Valid CSRF Token Required error.
is there anyway you could help us?
Please advice
Where can I make the donation of 10$ in order to get the latest version of the software?
Hi Scott.
Very impress with your reports. Were can I send my donation to have the report files? do you use Paypal?
Gustavo,
I tried emailing this to the email address you provided but it failed.
Thank you for your compliment and interest in my Reports MOD for osTicket.
Yes I do accept Paypal and you can use the donate button at the top right
of my website.
Thank you,
Scott
Good day,
Does it can be deployed into osticket 1.7.2 ?
Thanks,
Olga
Yes!
Installation problems: 0
Installation time: 3 mins
Satisfaction: 100%
T.Y.
Thanks, i received it. nice job
Hi Scott
I really love your OS Ticket First Theme and would like to purchase the Customer Client. My question is can I fully customize the CSS file to create a Metro (Windows 8) style. The design needs to be flat colors without gradients. Of course I will also need to update the color palette and replace the logo.
Thanks
Martin
Yes, you can feel free to edit the theme as much as you’d like, I just ask that you don’t sell the files as your own.
Hi,
Does it can be deployed into osticket 1.7.0?
And prefix in my database is osti_****, therefore do I need to change ost_reports to osti_reports?
Thanks
Danish
Yes, it works on 1.7. You can change the prefix if you want to but it should work either way.
I am using report 5.0 and when I select report criteria I receive Valid CSRF Token Required. what might be the problem?
Reports 5.0 does not work with osTicket 1.7+. You will need to upgrade to Reports 6.x
You ask for a donation but do not give a link to show how we can make the donation.
Does the full version come as complete installation or do we still need to copy and paste code into the PHP files?
DavidR
The only code that needs copied is the header file code and then to run the database commands. You can find the donate button/link at the top right of my website 🙂
To get this to work with the new OSTicket 1.8, we had to edit bootstrap.php to define the reports table. Other than that, it appears to be working! Test cautiously 🙂
Hi
When will this module be available for v1.8.x?
Thanks,
–Ian
It already is 🙂
Hi Scott,
Can you send me the latest version please?
Thanks.
How can I do the $10 donation for receive the version 6.0.
A question. The version 6.0 is compatible with version 1.8?
Thanks a lot
Luca,
You can use the donate button at the top right of any page on my website. Version 6.0.8 (Current) is compatible with 1.8.
Thanks,
Scott
Ok Thanks!
I’ve made the donations of 15$ with my paypal account blukas82@gmail.com
Hi
Followed your instructions and get this error:
Parse error: syntax error, unexpected $end in /var/www/html/osticket/include/staff/header.inc.php on line 126
Rolled the file back and osTicket works fine (no reporting obviously). Are you sure this report module is compatible with 1.8.x? Didn’t have this issue on 1.7.x at all ..
Thanks,
–Ian
Hi,
I am ussing 1.7 and I have the same error
parse error in C:\dolibarr\www\soporte\scp\reports.php on line 617
Did you find a real solution ?!
Yes I have it running on the latest build (1.8.0.2).
Do you have short tags enabled? If not have you upgraded to use the 6.1 code? I have replaced all of the short tags in 6.1 with the full php tags.
Hi there,
I use OST 1.8.0.2, and reports give me the following error:
Warning: mysql_result() expects parameter 1 to be resource, boolean given in /var/www/virtual/domain/servicedesk/htdocs/scp/reports_includes/functions.php on line 18 Warning: mysql_result() expects parameter 1 to be resource, boolean given in /var/www/virtual/domain/servicedesk/htdocs/scp/reports_includes/functions.php on line 18
Any clue?
This code is looking up something from the config table. Is your config table intact? Also have you tried using the code from 6.1?
Hi Scot,
I used the latest you’ve send me, the table seems to be ok:
CHECK TABLE `ost_config`
ostsupport.ost_config check status OK (phpmyadmin)
In bootstrap.php I found: define(‘CONFIG_TABLE’,$prefix.’config’);
It seems ok, but somehow it isn’t.
To date, I couldn’t resolve this. Any hints are more then welcome.
Hi Scott,
Great implementation !
I provided the amount of all future release, please send me files and instruction.
Many Thanks !
Does it works for latest 1.9x?
Yes it does
Have you confirmed that this works on 1.9.1?
Reports is now working for 1.9.1!
Cheers,
Scott
Hey Scott,
Is there anything new or special that needs to be done in order to get Reports working in OSTicket v1.9.1? Or is it rinse-and-repeat for the installation instructions?
Thanks for the assist!
Jesse R
No change!
Is this ready for v1.9.2 yet?
Does it works for 1.9.x yet?
Yep
Hello Scott,
Does your report tool work with OS Ticket 1.9.3?
Thanks!
John
Yes it does!
Hi,
Does your reports works with OS Ticket 1.9.4 release?
Thanks
Yep! The latest (6.2) works with 1.9.4
Does 6.2 supported reports per organization?
Hi,
Does your reports works with OS Ticket 1.9.5.1 release?
Thanks
Yes, it does!
I’ve donate by paypal but i’ve not received anything can you verify?
Thanks
Andrea
Andrea,
I tried sending it to you but it bounced saying your mailbox was full. Is there somewhere else I can send it or should it be safe to send it again now?
andreadg88_AT_GMAIL_DOT_COM
Scott, have any news regarding the email?
Thanks
Hi Scott,
I see a field on your reports, “hours to resolution”. How can you calculate that value, if you dont input “worked hours” to the tickets?
If I recall correctly the time was based off of the time between when the ticket was opened and the time the ticket was closed.
i need zip file how to get it ?
Once you’ve donated you should be receiving instructions to download the zip file. Extract all files to the scp/ directory and set all directories to 0755 and all files to 0644. Please also move the included file “include/staff/header.inc.php” to ROOT_INSTALL/include/staff/header.inc.php”
in the donation page i can’t see any login or ID saying that i am (Samuel) paying. How i will receive the zip file if there is no login id for me.
Second Q : Will this work in Osticket Version v1.9.8.1 ?
Kindly reply i will donate and get the zip file.
Once you’ve donated you should be receiving instructions to download the zip file. Extract all files to the scp/ directory and set all directories to 0755 and all files to 0644. Please also move the included file “include/staff/header.inc.php” to ROOT_INSTALL/include/staff/header.inc.php”
in the donation page i can’t see any login or ID saying that i am (Samuel) paying. How i will receive the zip file if there is no login id for me.
Second Q Will this work in Osticket Version v1.9.8.1 ?
Kindly reply i will donate and get the zip file.
Where to buy the new MOD.
You can click on the “Donate” button at the top right of any page on the site. In the comments simply mention what it’s for and I’ll get the appropriate software sent to you.
Thanks!
Scott
Scott,
I want to get known that you went the extra mile to give always quick support to something that was revealed not to be your responsibility. Your input and quick assistance forced me to setup another server… then according to your instructions all went smooth and is running great. Great product and support!
Thanks
JP
Hey Scott,
how much should I pay for the module??
Jorge,
The Module is $35 for the current version or $50 for the current version and all future versions.
Thanks,
Scott
Hi Scott
This module is available in Spanish language?, works with 1.9.12 version?
I donated but havent received the software
Michael,
I sent the following a few days ago to your support email address
>>>
Hello,
Sorry for the confusion and thank you for the email and payment, however,
there has been a lot of work done on the reports MOD since it was priced at
$10 / $15. Several new reports and features have been added and we are also currently working on turning it into a drop in plugin. With this in mind the reports MOD price was changed to $35 / $50. Would you like me to
refund your $10 or would you like to send in the rest of a payment?
http://www.sudobash.net/osticket-reports-6-0-osticket-release-1-7/
Thank you,
Scott
Hello Scott, is the reporting mod still available to buy?
Yes, it is! We keep it updated to run on the latest osTicket code at all times. 🙂
Hello Scott,
First of all congratulations for develope this great mod, can you please tell me which os ticket version it is supporting. is this support all version ? like 1.9.6 , 1.9.7, 1.9.9
Thanks
The Reports plugin is currently being developed only for the 1.10+ branch, however, 99% of the reports work under 1.9+ (there is a database change regarding ticket threads between 1.9 and 1.10).
Also, as an FYI, I tried emailing the address you supplied but it was returned by yahoo saying that account doesn’t exist.
Thanks,
Scott
Couple questions:
-Is it possible to create reports based on custom fields?
-Is anyone else having issues with the applications button?
-Is anyone else getting the ‘use of unidentified constant…’ messages at the top of the reports page?
Clayton,
There currently isn’t support for creating custom field reports, it may be something I look into in the future. The applications button not working is actually an osTicket bug, there is no apps.php page included and so it fails. Can you check on your scp/reports.php line 3? You should have the definition for the REPORTS constant?
This is what I have in line 3: define(REPORTS,’../include/plugins/ReportsMod/’);
Investigation of that location does show a ReportsMod folder containing two folders and 3 files:
images
includes
config.php
modreport.php
plugin.php
Having never really delved into PHP before, I am wondering as to the feasibility of creating my own apps page. Has anyone done this?
Does anyone believe the “juice is worth the squeeze”, so to speak?
What is the possibility of seeing reports by priority at some point in the future? Is it feasible?
Hello Scott,
I want to buy the mod for the reports….i just wanna know if it is compatible with the 1.9.15 version of osticket….and if i have any problem of installing it you’ll help me ?
thanks !
Hi Giannis,
I do have a slightly older version that works with 1.9.15, however, the reporting plugin is no longer being developed so it doesn’t have the latest updates.
I’m always available to help with installation and any issues. 🙂
Hi Scott,
I wanna buy the older version as you said. How much does it cost and how i should pay you.
Thanks again !
You can just use the Buy Now button above, I’ll watch for your email address/domain and send you the 1.9.15 version instead of the 1.10.
Thanks!
Scott
i paid it from my partner paypal account with email f*****g@yahoo.gr
You can send it to my email or to my partner.
Thanks again !
Hiya, will this plugin allow export of the full ticket/response details?
I would like to list every response on a separate row on a spreadsheet, for costing purposes.
Not presently, but it’s something we can consider for a future release.
Thanks!
Scott