Resolved! Report to see what machine upgrade Windows
Hello, is there a report where I can see the date that a machine updated its Windows version? For example, when it was updated from Windows 10 to Windows 11?
Topics in this forum
Resolved! How I get full Asset and Active Directory Information in report
Hello Everyone, I am a new Lansweeper user. I tried the below query to get the device information. In addition, I want to get more information about Department, Office, Title, Country...I have tried linking table AD users but no success.Can you help ...
Finding todays date in SQL
Hi,I am trying to write a SQL report in Lansweeper that shows all users that have logged in today,Below is what I have so far but can't find how to specify LoginTime. I need something likeLastLogonTime = between TodaysDate() AND TodaysDate()Select To...
Query returning results that it should not - No DBAs on staff :(
Hello. I need help with a SQL query I'm trying to run in LS. End goal: we want to find all machines with Java installed, but NOT include anything that has the SE Development Kit OR a software known as "Ignition". [Has: Java but NOT (SE Development ...
Resolved! Software by OU
We seperate our domain by division in AD and I'd like to do a software inventory for each OU. Does anyone have a report for it? Thanks!!
EMR software: eClinicalWorks - Reports and Deployments for managing your EMR
Due to eClinicalWorks updates installing over each other, running a normal "software" report will not do the job. The example below as to why in my experience it is difficult to write a normal software installation report for the software. As you can...
Report that Excludes ALL PC's With a Particular Registry Key and Value
Hey all,I am trying to create a report that shows all PC's with a certain software installed and excludes from the list/report if a particular key and value is set. I am needing this for an automated schedule, but I can't seem to figure out the synta...
Resolved! LS not scanning anymore all of a sudden
Hi, It seems my on-prem LS is suddenly not scanning anymore. The last seen assets and last seen users are all stuck at a certain date and time. Weirdly, this date is on the weekend at a very early hour where nobody would be awake to have done someth...
SQL join columns
Hello! Help to combine the columns in the report. I'm not really friends with SQL) join (CurrentHorizontalResolution CurrentVerticalResolution) to get an EXAMPLE view: 1366x768Thanks!
