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
We’re currently experiencing a high volume of support requests, which may result in longer response times — thank you for your patience and understanding.
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: 

Topics in this forum

Sign in/Join

Resolved! error while getting report

Hi,When i try to run the following report i get the error message "Error converting data type varchar to numeric"this is the querry i try to run.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetType...

BartCl by • Engaged Sweeper
  • 9670 Views
  • 6 replies
  • 0 kudos

Resolved! modify Software: All Microsoft software report

This may not be possible but the goal is to show how much of all Microsoft titles are used by location. Below would be a sample of what I am trying to achieve.Microsoft Office Professional 2013 NorthAmerica 400Microsoft Office Professional 2013 Af...

jschlepp by • Engaged Sweeper
  • 5613 Views
  • 2 replies
  • 0 kudos

Resolved! IIS Report

I would like to create a report that will show ALL servers that are running IIS, IIS version, server name, OS Version, and IP. I am new to Lansweeper so if it already has this report please forgive me.

Ron by • Engaged Sweeper
  • 16820 Views
  • 4 replies
  • 1 kudos

Resolved! Report to display all assets with asset types, IP addr, and full OS

I'm trying to develop a report that is like the "All Assets" under the Asset link, but I just want to display the Asset Name, Type, OS, Model and IP address. If I use this query I get all asset types:Select tblComputers.Computername, tblComputers.Com...

oocio by • Engaged Sweeper
  • 10364 Views
  • 2 replies
  • 0 kudos

Resolved! List all computers except VMmachines?

Hello,I got a simple question. I want to list all computers except VMWare machines.Now I got by AssetTypename = 'windows'. That gives all the computersNow I want to have also integrate a filter on Model, that should be: does not contain VMware or is ...

Resolved! unique installed software

I am trying to find unique installed software and the highest version of the software installed.There is a report with "All installed software"That gives me 4 columns. SOftware Name, version, publisher and number if installations.to start:How would i...

ogeccut by • Engaged Sweeper II
  • 6693 Views
  • 2 replies
  • 0 kudos

Resolved! "Where Custom1 > Number" Not Working

Simple query, unexpected result. I am using the second Custom2 field to save Cost, since Lansweeper is about the only inventory system in the world without a field for it Trying to see something over the cost of $500SELECT a.AssetName, at.AssetType...

Matt8 by • Engaged Sweeper III
  • 6847 Views
  • 3 replies
  • 0 kudos