This board contains archived posts from the retired Lansweeper Forum and Insiders Community.
Added in v.6.0.100The report below lists the average time worked for each agent in the helpdesk during the last 7 days. The report will only list users that meet all of the following criteria:The user is an agent.The notes are not sent in a ticket th...
Added in v.6.0.100The report below lists the average time that it takes for a ticket to be set to the ‘Closed’ date for each month.The report will only list users that meet all of the following criteria:The ticket has been set to the ‘Closed’ state.T...
Added in v.6.0.100The report below lists the average initial response time in days for each month.The report will only list tickets that meet all of the following criteria:The ticket has not been set to ‘Ignore’Select Top 1000000 DatePart(yyyy, htblt...
Added in v.6.0.100The report below lists assets that have been added to a ticket in the helpdesk. General information about the asset and the ticket it is related to are also given back in the report.The report will only list users that meet all of t...
Added in v.6.0.100The report below lists all the open tickets in the helpdeskThe report will only list tickets that meet all of the following criteria:The ticket has not been set to ‘Ignore’.Select Top 1000000 htblticket.ticketid, '#' + Cast(htbltic...
Added in v.6.0.100The report below gives back tickets that have are not in the ‘Closed’ state.The report will only take into account tickets that meet all of the following criteria:Ticket is not set to the ‘Closed’ state.The ticket has not been set t...
Hi thereHere is a Powershell script to backup Lansweeper with SQL Compact and IIS Express. Just modify Set-Location field and run the script to backup Lansweeper.## 1. Stop the Lansweeper Server serviceStop-Service lansweeperservice## 2. Stop web ser...
Added in v.6.0.100The report below lists all the tickets that have been created.The report will only list tickets that meet all of the following criteria:The ticket must be set to ‘Ignore’.Select Top 1000000 htblticket.ticketid, '#' + Cast(htblticke...
