This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Sign in/Join

Report: Count of tickets per *Custom Field* and month

Hi All,We have a custom field (drop down) in our Tickets for "Location" used to select geographic locations that a ticket relates to (only 4 possible values in the drop down). I would like to modify the standard Lansweeper Report "Helpdesk: Count of ...

ebruntjen by • Engaged Sweeper
  • 13481 Views
  • 15 replies
  • 0 kudos

Windows 10 OS Builds

I have pieced together this report that reports the full OS Build of Windows 10. It works, but it relies on 2 custom registry scans. The 2 custom scans are both from \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion. One is ReleaseID...

pfenton by • Engaged Sweeper III
  • 4550 Views
  • 1 replies
  • 0 kudos

Windows 10 readiness report

In light of the closing Windows 7 EOL date, you can use the report below to check whether your workstation are ready for a Windows 10 upgrade. The report checks the hardware requirements and if an in-place upgrade is possible or not. The specificatio...

Esben_D by • Lansweeper Employee
  • 10788 Views
  • 2 replies
  • 2 kudos

Find overlapping IP scan ranges

This report shows you overlapping IP scan ranges and the assigned site server. Select Top 1000000 t1.IprangeID As [1 Range ID], t1.Servername As [1 Scanning server], t1.Ipstart As [1 Start], t1.Ipend As [1 End], '<----->' As [=], t2.IprangeID As...

klaus by • Engaged Sweeper III
  • 6147 Views
  • 2 replies
  • 1 kudos

Monitor name with ScreenHeight & ScreenWidth

Hello, I'm trying to write a report that gives information about the monitors, not so much about the computers they are attached to.So far this is what I have:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename A...

cycleheat by • Engaged Sweeper III
  • 6627 Views
  • 5 replies
  • 0 kudos

Resolved! Failed Deployment Report Issues

I am trying to make a report that will show the last 100 failed deployments.The issue is when I run this it just has the same asset listed 100 times.Wondering what this issue is?Sorry in advance as I'm sure its something simple I am over looking.Sele...

MHScripts by • Engaged Sweeper II
  • 3352 Views
  • 1 replies
  • 0 kudos

Inventory Windows systems

I share my little sheet. Welcome to make it better. To work it had to be with SQL server, not compact version. LinkSelect Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, Case When (tblAssetCustom.State Like '1') Then 'Active' When (...

BioFerS by • Engaged Sweeper II
  • 12763 Views
  • 2 replies
  • 6 kudos