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: 

Forum Posts

Duplicate User Accounts of Reporting CPlogoninfo Times

Hi,i use the following report to get the user name and logontime of assets.Select Top 1000000 tblassets.AssetID, tblassets.AssetName, tblCPlogoninfo.logontime, tblCPlogoninfo.UsernameFrom tblassets Inner Join lansweeperdb.dbo.tblCPlogoninfo On tb...

daigls by Engaged Sweeper III
  • 2293 Views
  • 1 replies
  • 0 kudos

Ticket report on custom field "System Impacted"

I'm trying to generate a report in LS Helpdesk which shows all tickets opened, along with date opened, assigned agent, agent team, Ticket Type, and a custom field called "System Impacted"I can get everything except for "System Impacted". I can't see...

pryan67 by Champion Sweeper II
  • 2617 Views
  • 1 replies
  • 1 kudos

Resolved! Assistance With AV & Bitlocker Report

Hey Guy's,First off, thank you for the help I have a little urgent request that I am struggling with looking at some of the existing reports.I need a report that shows the current BitLocker Status on C: Eg Off/On and also Antivirus Status. We are cu...

History of relationship between pc and monitor

hello,With the pandemic, employees have taken computer equipment including monitors without notifying the IT department. We would like to have information about the peripherals connected to the computers when they are used while teleworking. I would...

hfaddy by Engaged Sweeper
  • 3761 Views
  • 2 replies
  • 0 kudos

Scanning AWS servers in multiple accounts issue

Hi, i have different credentials for same region but lansweeper show only for last servers.In order i have #4 credentials assigned on Frankfurt Region but lansweeper show only last credentials servers.How can fix this issue?Thank you

HDSwascan by Engaged Sweeper
  • 1342 Views
  • 0 replies
  • 0 kudos

Filter Column to only display CVE values

Hi,Is there a way in SQL to select certain values from a Description column and display just those values in a new column or the same Column, for example I have a table containing CVE information, I'm trying to just identify the CVE Values so this :"...

Andy_Sismey by Champion Sweeper III
  • 3494 Views
  • 2 replies
  • 0 kudos

Exclude specific computers from report

Currently using this report to find out what machines are missing Trend Micro. I have a few I would like to exclude, can anyone advise on how to accomplish this? Sorry not an expert in this area!Select Top 1000000 tsysOS.Image As icon, tblAssets.Ass...

seand by Engaged Sweeper II
  • 7361 Views
  • 4 replies
  • 0 kudos