lee mcdermott Posted March 6, 2018 Share Posted March 6, 2018 Hi, i am trying to run a report to see how many calls in total we logged in Hornbill since going Live last April until the end of the year 2017. It first returned 6000 in total for Incidents and Changes. So I amended the filter for only Service requests and this also returned 6000 entries. Too much of a coincidence I think. So is there a setting that limits reports to 6000 entries? Also it does not create a PDF - is this because the output is to large? I fi reduce the time period to 1 or 2 months it does create a pdf thanks lee Link to comment Share on other sites More sharing options...
Dan Munns Posted March 6, 2018 Share Posted March 6, 2018 There is a setting: api.xmlmc.queryExec.maxResultsAllowed (although it being set to 6000 by default is incorrect I am sure) so you might want to try that. I would make the change, run the report, and then change it back to its current setting. As @Victor says 'Use with caution' Link to comment Share on other sites More sharing options...
lee mcdermott Posted March 6, 2018 Author Share Posted March 6, 2018 @Dan Munns cheers Dan will give this a go. Link to comment Share on other sites More sharing options...
Dan Munns Posted March 6, 2018 Share Posted March 6, 2018 If you only want the number you could create a widget to show the number of calls logged in 2017. Link to comment Share on other sites More sharing options...
lee mcdermott Posted March 6, 2018 Author Share Posted March 6, 2018 @Dan Munns funny you should say that as once I had posted this originally - I thought Iwould create a measure to see if I can just get that figure. It does seem to have generated a figure which seems about right. thanks for the help. I will still try the report setting to see if that does allow the report to run Link to comment Share on other sites More sharing options...
Dan Munns Posted March 6, 2018 Share Posted March 6, 2018 Cool, hope it works Link to comment Share on other sites More sharing options...
lee mcdermott Posted March 6, 2018 Author Share Posted March 6, 2018 @Dan Munns just checked and the value was set to 6000 - looks like it has already been changed to this value previously (not by me) Link to comment Share on other sites More sharing options...
Dan Munns Posted March 6, 2018 Share Posted March 6, 2018 Cool. At least you can change it for the report. I believe the overall limit is 25000 so hopefully you won't hit that Link to comment Share on other sites More sharing options...
lee mcdermott Posted March 6, 2018 Author Share Posted March 6, 2018 @Dan Munns ah right if it is a limit of 25,000, I will be above that - so i will just stick with the measure and use the reports for shorter stuff i.e.monthly good to know though Link to comment Share on other sites More sharing options...
Dan Munns Posted March 6, 2018 Share Posted March 6, 2018 @Steven Boardman can you confirm the 25K limit or am I just dreaming that? Link to comment Share on other sites More sharing options...
Guest Posted March 6, 2018 Share Posted March 6, 2018 @Dan Munns On my test system the default is 1000 and not 6000. It is possible someone else needed more results to be returned and they set it to 6000 but I would bring it back down. regards Pamela Link to comment Share on other sites More sharing options...
Dan Munns Posted March 6, 2018 Share Posted March 6, 2018 @Pamela I know the default is 1000, we have ours set to 2500 currently. I think I remember seeing the hard set limit was 25000 though, but I may be wrong. Was just trying to get confirmation of that. Link to comment Share on other sites More sharing options...
Guest Posted March 6, 2018 Share Posted March 6, 2018 @Dan Munns @lee mcdermott I would not advise to set it to the very maximum because even setting it at 10000 may have an impact on performance. How about running the report in such a way that it returns calls logged first quarter, second quarter, and so on of a particular year. I am not sure how busy your desk is but am sure you would be best placed to judge roughly how many calls were logged in a particular period and what kind of report can return valid results. Regards Pamela Link to comment Share on other sites More sharing options...
Steven Boardman Posted March 6, 2018 Share Posted March 6, 2018 @Dan Munns so your memory is correct there is a 25000 max limit on the reports. @lee mcdermott There are also a couple of other considerations. If you are trying to create a report and output it to PDF then the above limit it overwritten to restrict the size of the HTML which in turn is converted to PDF, this is hard set at: reporting.display.maxcolumns = 20 reporting.display.maxrows=5000 If the PDF generation exceeds this limit the PDF generation will fail and the reason will be written to the log. You can still create reports and output them to CSV etc to the limit you have set on your instance up to the maximum of 25000 For these higher value type requirements like total requests logged last year, then widgets on the dashboard should happily return you the values be this in total, year on year, quarterly etc, as demonstrated in the example below (this specific one and others are available for review in the sandbox instance) I have updated the relevant wiki page to this effect https://wiki.hornbill.com/index.php/Service_Manager_Reports#Output_Options Hope that helps Steve Link to comment Share on other sites More sharing options...
Dan Munns Posted March 6, 2018 Share Posted March 6, 2018 Thanks for the info @Steven Boardman Link to comment Share on other sites More sharing options...
lee mcdermott Posted March 6, 2018 Author Share Posted March 6, 2018 @Steven Boardman yeah great thanks also Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now