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

Users: Logins into the Lansweeper web console (Built-in)

Added in v.6.0.100The report below lists the logins that were made to the Lansweeper webconsole and whether they were successful or not.Select Top 1000000 tblLoginLog.Date As LoginDate, Case tblLoginLog.Success When 1 Then 'yes' When 0 Then 'no' En...

Nick_VDB by Champion Sweeper III
  • 4437 Views
  • 1 replies
  • 1 kudos

User report want to add last logged on computer

So far I have this basic report that shows user information, all I'm missing is the last computer used/logged on for the userSelect Top 1000000 tblADusers.Username, tblADusers.Userdomain, SubQuery1.Lastlogon, SubQuery1.DaysSinceLogon, tblADusers....

kbek by Engaged Sweeper II
  • 8101 Views
  • 4 replies
  • 0 kudos

How to filter by Domain Name

I would like to know if I can Filter out one of my domains 'XXXDEV' to not show on my WIN Server Reportor by an IP range. I wish we did just not scan this group but we do and would not like these systems to show in the report. Select Top 1000000 tblA...

Report for not owned assets

Hey I'm currently stuck at creating a report to list all assets which are not owned by a user or ad-group.We have a storage room for such kinds of devices, but I want to be able to crosscheck it simply by checking it in lansweeper too.I created a rep...

tschaller by Engaged Sweeper
  • 1831 Views
  • 0 replies
  • 0 kudos

Resolved! Report by Department, User, then Asset Name

I am trying to create a report that will give AssetName, the User assigned to the asset, and then pull the department from the Active Directory table. I want a sorted list by department, User, and asset name. So it may look something like this. Depa...

How to Find bad blocks Computers from Event log

Hi everyone,I want to write a report, is to find out if each computer event log has「Device \Device\Harddisk0\DR0 has bad blocks」This record, find out the damaged block of the hard disk in advance and replace it, thank you

Powen by Engaged Sweeper II
  • 3668 Views
  • 4 replies
  • 1 kudos