→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

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.

Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Local admin group report based on domain role

/** Select required fields from tables **/Select Top 1000000 t1.AssetID, t1.AssetName, t2.Username, t2.Domainname, t2.Groupname, t3.Domainrole,/** Sets naming convention based on domain role **/ Case t3.Domainrole When 1 Then 'WORKSTATION' ...

Noobmode by Engaged Sweeper III
  • 2 replies
  • 1 kudos

Modify "....less than 1GB free HD..." Report

How would I go about modifying the built-in report for Servers and Workstations, the "Disk: ....less than 1 GB HD" report, to exclude "RECOVERY" drive letters and other non-boot drives, regardless of drive letter? Working on proactive maintenance, I...

mhammond by Champion Sweeper
  • 2 replies
  • 0 kudos

Report NB and Workstation

Hey There,we are trying to get a Report for all our Workstations and Notebooks of the Company. All Notebooks have the "NB" in their Name and all Workstations have "WS" in it.so theoreticaly i can filter withWhere tsysAssetTypes.AssetTypename Like '%...

Modified file last 24 hours

I want to have a report that would show if a specific file on a users C drive has been modified in the last 24 hours. Is anyone able to create this for me?

baycrest by Engaged Sweeper II
  • 1 replies
  • 0 kudos