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

Number of users in a group

I have created a simple report which gives me the number of users in a groupSelect Top 1000000 Count(tblADGroups.ADGroupID) As Count, tblADGroups.Name, Count(tblADusers.Username) As count2, tblADGroups.DescriptionFrom tblADusers Left Join tblADMe...

User Relations

under the "user Relations" section, we can add when a user starts using an asset, but not when they stop. Can we have a "No longer used by <User>" section where we can add a returned date?for example, I would like to record when a user is assigned a ...

Searching Installer packages in deployment

Hi,I have using Lansweeper for more than 3 years, and recently started to use deployments. As I have more than 50 Installer packages, its hard to scroll the whole page to search Installers (no scroll bar available for instaler packages section).Prese...

Karthik by Engaged Sweeper
  • 1847 Views
  • 0 replies
  • 0 kudos

Change to the SQL Server Versions Report Requested

Is there a way to modify the default report of Software: All SQL Server editions, to include something similar to the Patch Tuesday logic where it shows the ones that are current in that major version (2012, 2014, 2016, 2017, 2019) meaning like if CU...

AZHockeyNut by Champion Sweeper III
  • 1608 Views
  • 0 replies
  • 0 kudos

Help Desk Report

I found this code, but it only shows me the current month.How do I edit it, so that it shows the top 10 ticket types for Year To Date, by month for the current year?Select Top 10 DatePart(yyyy, htblticket.date) As Year, DatePart(mm, htblticket.date) ...

LGuth by Engaged Sweeper
  • 1728 Views
  • 0 replies
  • 0 kudos

Reporting Question On OST Size

Question for the gurus. We are starting to find more and more users that are hitting the 50GB limit on their OST files (Outlook Cached exchange mode).I am hoping there is an easy way to report on the OST file size. The issue is, this file lives in ...

Scanned Items not Updating

Greetings Everyone, I am running into a bit of an issue with Lansweeper scanning systems but not updating the Scanned item sections. Particularly the Uptime Scanned Item that we currently have set to be scanned when ever the asset is scanned. We are ...

Chronuts by Engaged Sweeper
  • 1813 Views
  • 0 replies
  • 0 kudos

IPCONFIG /ALL Report

I'm looking for a report that mirrors "IPConfig /All" for each Windows client and server. The resultant report should display at least two network adapters and both IPv4 and 6.

Rob_B by Engaged Sweeper III
  • 1912 Views
  • 0 replies
  • 0 kudos