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

Updated - Asset Relations Report Assistance

Good Morning. I created a custom report to track our computer refresh by using a custom field for replacement year. This works great for us but an issue that we have run into is that the report pulls last user and not the asset relation to a user. I ...

rcamron by Engaged Sweeper II
  • 1753 Views
  • 0 replies
  • 0 kudos

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
  • 4610 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
  • 8356 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
  • 1949 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...