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'm trying to add the HOTFIXID to this report to show the KB update that was installed. But when I try to add it, it adds multiple rows for each Workstation.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysOS.OSname, tblAssets.Userna...
Below is the script I have but it's only showing Windows Servers, nothing else. Any help would be greatlt appreciated:Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.IPAddress, tsysOS.OSname As OS, tbl...
I have a question about https://www.lansweeper.com/tutorial/find-that-dinosaur-in-your-network/How can you make this report show Linux machines as well?
Hi i want to get a detailed end of year reportid like a list of all tickets closed for the previous year, 2019, to include call typeand what agent closed it.Once i get that into CSV i should be able to get the information that i need.thanks
HI,I have tried my hand at writing a report. My objective was to get a report that shows how many tickets were created in a month and how many tickets were closed that month and have it group by type. I have 4 types of tickets in my system. Here is w...
I am having a tough time trying to manipulate the reports of Asset Out of Warranty and Asset Out of Warranty in 60 Days. We want to not only keep the manufacturer's report of when that warranty expires, but we also have set a standard where 5 years ...
Hi,I need a report which shows all Windows PC's along with their custom registry keys scanned in a report. For example, I want to be able to show Asset name, Software Version (Symantec Endpoint Protection) and two different registry keys which I have...
This report returns all computers with Office versions whose third number is less than 12228.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Username, tsysOS.Image As icon, tblSoftwareUni.softwareName, tblSoftware.softwareVe...
