Is there a report that will give the below information?User IDComputerDateTimeSuccessful LoginDenied LoginLocked AccountLogged in locallyLogged in remotely
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...
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...
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...
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...
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
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 :"...
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...
