
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-16-2018 01:38 PM
Hi,
We would like to know which days (Monday to Sunday) in 2017 that we received the most tickets, and on those days, know the time of the day that we received the most tickets, but I can’t find the option.
Thank you,
Best regards,
We would like to know which days (Monday to Sunday) in 2017 that we received the most tickets, and on those days, know the time of the day that we received the most tickets, but I can’t find the option.
Thank you,
Best regards,
Labels:
- Labels:
-
Report Center
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-19-2018 04:30 PM
Hi,
I've added a report below that will show a count of tickets per day and hour in a specific year (2017), which you can modify. Other filters can also be added to the report such as filtering out certain ticket types etc., but this base report should be able to get you going. Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/Forum/yaf_postst9882_How-to-run-a-report.aspx#post38309
If you are interested in building or modifying reports, we do recommend:
I've added a report below that will show a count of tickets per day and hour in a specific year (2017), which you can modify. Other filters can also be added to the report such as filtering out certain ticket types etc., but this base report should be able to get you going. Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/Forum/yaf_postst9882_How-to-run-a-report.aspx#post38309
If you are interested in building or modifying reports, we do recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial: https://www.w3schools.com/sql/
- Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/Forum/yaf_postst9870_Lansweeper-database-dictionary.aspx#post38296
Select Top 1000000 DateName(dw,htblticket.date) As DayOfWeek,
DatePart(hh, htblticket.date) As HourOfDay,
Count(htblticket.ticketid) As Tickets
From htblticket
Where DatePart(yyyy, htblticket.date) = 2017
Group By DATENAME(dw,htblticket.date),
DatePart(hh, htblticket.date),
DatePart(dw, htblticket.date)
Order By DatePart(dw, htblticket.date)
