I have managed to get a report put together that Reports on all systems in my Inventory that have a Certain SSL Certificate installed. Using the GetDate() Function, I can report on systems that have an expired certificate that expired prior to the c...
Hello Community, I am new to the Lansweeper and need to know a detail about Lansweeper reports. I have a customer and they need to get the details of the PCs that not installed an Antivirus product in their enterprise network. Can I get those details...
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 ...
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...
