→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
hysthos
Engaged Sweeper II
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,
1 REPLY 1
Ian_F
Lansweeper Alumni
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:

  • 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)

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now