Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

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

Forum Posts

Users: AD user has no department filled in (Built-in)

Old name: Active directory: User has no department filled in (Built-in)The report below lists users in Active directory having no department filled in.Meets all of the following criteria:User found in Active DirectoryDepartment empty or nullSelect To...

Daniel_B by Lansweeper Alumni
  • 814 Views
  • 0 replies
  • 0 kudos

Windows: Has no location in AD (Built-in)

Active directory: Computer has no location filled in (Built-in)The report below gives back Windows computers having no location filled in Active Directory.The report will only list assets that meet all of the following criteria:The computer's state i...

Daniel_B by Lansweeper Alumni
  • 741 Views
  • 0 replies
  • 0 kudos

How to run a report

To run any of the reports found in the report center, do the following:Open the report builder in the Lansweeper web console under Reports/Create New Report.Paste the SQL query (report) found in the report center at the bottom of the page, replacing ...

Susan_A by Lansweeper Alumni
  • 45248 Views
  • 0 replies
  • 8 kudos

Users: AD user has no email address

The report below lists AD users that do not have an email address associate to them.The report will only list users that meet all of the following criteria:User is scanned from Active DirectoryEmail field is empty or nullSelect Top 1000000 tblADusers...

Bart_M by Lansweeper Alumni
  • 3344 Views
  • 0 replies
  • 0 kudos