Added in v.6.0.100The report below gives back a count of the tickets that have been created during each year/month.The report will only take count tickets that meet all of the following criteria:The ticket has not been set to ‘Ignore’Select Top 10000...
Hey There,we are trying to get a Report for all our Workstations and Notebooks of the Company. All Notebooks have the "NB" in their Name and all Workstations have "WS" in it.so theoreticaly i can filter withWhere tsysAssetTypes.AssetTypename Like '%...
Hi Sweepers. I have been tasked with creating a list of all updates missing on all of our Win 2016 servers. I have found articles that show how to make a query for a single specific KB on a single server. The problem is i have 71 servers that i need ...
Good morning.I found this to be perfect, but it does count based on the ip and not the location map. How can I replace the location with the iplocation?Select Top 1000000 tblSoftwareUni.softwareName As Software, tblSoftware.softwareVersion As Versio...
I want to have a report that would show if a specific file on a users C drive has been modified in the last 24 hours. Is anyone able to create this for me?
Hi Guy'sI am trying to create a chart report to show OS Version Numbers.I have the following, but I can't get the first numbers listed first to show the Version Numbers and the count afterwards which is what I believe is required for the chart.At pre...
Hello,We are trying to use Lansweeper to track which assets are 'used by' our AD users.I can report on which assets have user assets set to 'used by' or 'borrowed by' pretty easily. My problem arises with End Dates, and past relationships. To report ...
