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: 

Topics in this forum

Sign in/Join

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
  • 10205 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
  • 6564 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
  • 6674 Views
  • 3 replies
  • 0 kudos

Resolved! Users by Asset

Is there a way to generate a report that would allow one to search by a username and generate a list of machines that person has logged into? This info is then used for me to login to their computer.

gsetech by • Engaged Sweeper
  • 6388 Views
  • 1 replies
  • 0 kudos

Resolved! Report: Computer Install Date by Location

Maybe I'm just missing it, but I see the built in report for computer 'install date' but that gives me a global result. Is there a way to get this report by IP location? Thanks for any info...

Rockermann by • Engaged Sweeper II
  • 4465 Views
  • 1 replies
  • 0 kudos

Resolved! New Software Installed

Is it possible to create a report that will let you know if any new software was installed in the past 7 days?So for instance it would only report new software installed on assets and not ones it currently has.

berickson by • Engaged Sweeper
  • 5669 Views
  • 1 replies
  • 0 kudos