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
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Resolved! Report of Software for PC/Mac mixed network

I've been tasked with creating a report that will be similar to the PC Licensing report, for Mac software. Even better, we'd like results from both platforms tallied if possible.On the PC side, Adobe Creative Suite is shown as Adobe Creative Suite. ...

Casey4147 by Engaged Sweeper
  • 3968 Views
  • 1 replies
  • 0 kudos

Resolved! Remove Duplicate entries from report

Hi all,I have put a report together which tells me all of the machines which have 'Event ID 7023'.The report has worked and I can see all the machines, but unfortunately it's showing the each PC multiple times in the report (as each machine has multi...

paultech by Engaged Sweeper
  • 8482 Views
  • 2 replies
  • 0 kudos

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
  • 5423 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
  • 7229 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
  • 6781 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
  • 4823 Views
  • 2 replies
  • 1 kudos