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...
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 ...
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!!
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...
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...
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...
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!
I need to create a static group who include all assets belonged to a fixed list of users. For example, a Contoso department of a company has User A, User B, and User C. All of them have a PC (from Lansweeper's viewpoint, an asset). Is there a way to ...
