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

Resolved! Asset Tag Report - Only show fields with data

Hello, I'm trying to build a report around the 'custom field 1' entry in Lansweeper Assets. Which I have named 'Asset Number' so we can populate with our own Asset numbers from our CMDB. I've used the base report 'Asset Tags' and tweaked it to the be...

bluesymbol by • Engaged Sweeper II
  • 5870 Views
  • 2 replies
  • 0 kudos

Resolved! Microsoft Office Report - Help

Hey All,I have the following report for Computers with Microsoft Office: Select Top 1000000 tblAssets.AssetID,tblAssets.AssetUnique,tblAssets.Domain,tsysOS.OSname,tblSerialnumber.Product,tblSerialnumber.ProductID,tblSerialnumber.ProductKey,tsysOS.Ima...

Cam by • Engaged Sweeper II
  • 7665 Views
  • 3 replies
  • 0 kudos

Resolved! Computers no in AD Group

I am having trouble creating a report that will show me computers that are not a member of a certain AD Group. Any help would be greatly appreciated.Thank you.

lance321 by • Engaged Sweeper II
  • 7261 Views
  • 3 replies
  • 0 kudos

Resolved! Desktops over 5 years old report

Trying to get desktops over 5 years old based off of the purchase date. Here's what I have so far... I'm new to SQL, so please forgive and inefficiencies. It doesn't seem to grab everything...am I missing something? Select Top 1000000 tblAssets.Asse...

Resolved! Detect devices unplugged

Can I see in Lansweeper if a user has disconnected a monitor? I am trying to find a way to detect if a user takes a monitor from one computer and plugs it into another.

MWBrown by • Engaged Sweeper
  • 5214 Views
  • 2 replies
  • 1 kudos

Resolved! Software report Machine Name

I am looking to run a report where it will give the Name of the asset, IP, Hardware info, and the software that is installed on the machine. Here is an example.Machine1 1.1.1.1 PowerEdge 2650 Adobe Chrome ...

pixa241 by • Engaged Sweeper II
  • 8747 Views
  • 5 replies
  • 0 kudos

Resolved! report for unmoved computers with user name USER OU

I want to create report for unmoved computers with user name and USER OUI create it but I want to add user OU in reportSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon,...

Resolved! Force Report To Only Include Results In IP Range?

Hello,I have a report that shows computers that are missing the Firewall Single Sign On agent and I was wondering if there was a way to make it so that it only shows computers who are in the DHCP pool?Our pool is 192.168.90.1 - 192.168.92.254Current ...

RTI_IT by • Champion Sweeper
  • 6910 Views
  • 4 replies
  • 1 kudos

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now