→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

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 on PCs That Have Been Left Powered On > 24 hours

Hi All,My boss wants to catch users whom do not turn off their PC after business hours. Hence, would like to know whether it's possible to show this in a report?Report Format looking for:Hostname | Last Powered On DateTime | Scan Datetime | Durations...

mydurian by Engaged Sweeper II
  • 3499 Views
  • 1 replies
  • 1 kudos

Resolved! Hardware information from last 90 days

Daniel is there a report I can pull all the Hardware information from the last 90 days.I was using this sql Query.declare @LastSeenDays intset @LastSeenDays = 90select upper(a.Domain) as DomainName, upper(a.AssetName) as DeviceName, --replace(repl...

Resolved! Related assets listed in one field

Hey folks,we use the asset relation possibility where often.We connected many assets with others. For example we have one parent asset and about 10 other child assets are related to it.Now we want to have a report where there is one line for every pa...

ppoppe by Engaged Sweeper
  • 3434 Views
  • 1 replies
  • 0 kudos

Resolved! Custom Internet Explorer version

Hi team,I need a variation of the default report "Files: Internet explorer version", tried to do by myself but nothing good happened The information I need:Assetname, OS,OSbitness, last user logged on, if IE is version 8.Thats the default SQL:Select ...

Resolved! Dashboard - windows update

Is there a way on Lansweeper Dashboard to get information regarding clients Windows update status?We would like to be informed if anyone has put Windows updates ON/OFF.With best regards,

bostjanc by Engaged Sweeper III
  • 6882 Views
  • 2 replies
  • 0 kudos

Resolved! Need to pull a report from 5.22

Hi All,I am still learning SQL and was wondering if there is a way to create a query to be able to pull a report to list all software installed on each asset. I originally had this query but it does not list the OS. Select tblAssets.AssetName,tblAsse...

Resolved! How to search for specific Microsoft Patch

I am trying to determine how I can search for whether or not a specific Microsoft patch is installed on systems. When I go to Software > Microsoft I only see a few dozen Microsoft related programs installed. Have I selected an option that is hiding...

bdowell by Engaged Sweeper
  • 8969 Views
  • 1 replies
  • 0 kudos

Resolved! Report on new users

Hello,I'm pretty new to Lansweeper, and have no knowledge in SQL aswell, so I hope my question doesn't sound too silly. Also I hope my question is understandable, I'm not a native english speaker.I need to make a report which shows what users are new...

Cactus by Engaged Sweeper
  • 4277 Views
  • 2 replies
  • 0 kudos