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: 

Topics in this forum

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
  • 9452 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
  • 6352 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
  • 8248 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
  • 7820 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...

LiquidKaoz by • Engaged Sweeper
  • 5685 Views
  • 2 replies
  • 0 kudos

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
  • 5628 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
  • 9305 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,...

sayed_awad by • Engaged Sweeper
  • 5881 Views
  • 1 replies
  • 0 kudos