This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ

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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Sign in/Join

Resolved! Need to pull a report from 5.22

Hi All,I am still learning SQL and was wondering if there is a way to create a query to be able to pull a report to list all software installed on each asset. I originally had this query but it does not list the OS. Select tblAssets.AssetName,tblAsse...

Resolved! How to search for specific Microsoft Patch

I am trying to determine how I can search for whether or not a specific Microsoft patch is installed on systems. When I go to Software > Microsoft I only see a few dozen Microsoft related programs installed. Have I selected an option that is hiding...

bdowell by • Engaged Sweeper
  • 9078 Views
  • 1 replies
  • 0 kudos

Resolved! Report on new users

Hello,I'm pretty new to Lansweeper, and have no knowledge in SQL aswell, so I hope my question doesn't sound too silly. Also I hope my question is understandable, I'm not a native english speaker.I need to make a report which shows what users are new...

Cactus by • Engaged Sweeper
  • 4415 Views
  • 2 replies
  • 0 kudos

Resolved! Link to doc added to report

Hello,Situation: we keep PDF's of our invoices when we purchase hardware, and intend to upload them to lansweeper's 'doc' page for each asset.We'd like to add a column to the below report that will provide a link the uploaded document associated with...

MustQ by • Engaged Sweeper
  • 5584 Views
  • 2 replies
  • 0 kudos

Resolved! Active Directory Security Groups

I was wondering if Lansweeper can report of what AD groups a user is a member of, or the other way around ( all users in a group)The ADUsers table doesn't seem to have that information. Thanks,

Malbanese by • Engaged Sweeper III
  • 6062 Views
  • 2 replies
  • 0 kudos

Audit: Disk Partition Alignment = FALSE

List of hard-disk partitions which are not alignedNote: This report runs only if the Lansweeper DB is installed on SQL Server Express or higher edition.Select Top (1000000) tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysOS.OSname, ...