Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
I have a Helpdesk report that shows which tickets were closed in the last X days. I have it sorted by user department. The report works great as is below. Select Top 1000000 htblusers.department As Department, htblticket.ticketid, '#' + Cast(htblti...
i try to exclude few values from report but it still contains them, can any1 tell me what i'm doing wrong ?:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssetC...
What change do I need to make so this report shows the initial ticket description (the first email they write in to describe a problem) in the Resolution column, as opposed to the final ticket note? I will change the column name to initial issue. Se...
Dear Support,I want to create a report for specific subnet.For example: 10.10.1.0/24 reportKindly help me.
Hi,We are in the process of rolling out an application. For some reason the installer is unstable and often fails. Because if this we would need a way to find these computers.As the last step in the installation process a .txt file is created in the ...
Does anyone know of a way to have Lansweeper scan for and report suspended windows sessions over a certain age/length?
Hi,I have "Administrator+Agent" permissions, What other additional permissions needed to view the report? Where to place them? Code reportSelect Top 1000000 tblConfigLog.Date, Case tblConfigLog.ActionID When 1 Then 'change' When 2 Then '+' When 3...
Windows firewall settings, local exceptions, stuff from a GPO (if possible which GPO) sorted by PC/Server of course.sorta like this does?https://gallery.technet.microsoft.com/scriptcenter/Script-to-display-the-b4e61729#contentwith the Lansweeper repo...
