I would like to create a report that will show ALL servers that are running IIS, IIS version, server name, OS Version, and IP. I am new to Lansweeper so if it already has this report please forgive me.
I'm trying to develop a report that is like the "All Assets" under the Asset link, but I just want to display the Asset Name, Type, OS, Model and IP address. If I use this query I get all asset types:Select tblComputers.Computername, tblComputers.Com...
Hello,I got a simple question. I want to list all computers except VMWare machines.Now I got by AssetTypename = 'windows'. That gives all the computersNow I want to have also integrate a filter on Model, that should be: does not contain VMware or is ...
Hi, thanks for reading...I have a report that I need to build and due to a non-standard environment I'm struggling a little. The workstations we use are not on AD and as such login with a default user name, we use Novell and this username is stored ...
I am trying to find unique installed software and the highest version of the software installed.There is a report with "All installed software"That gives me 4 columns. SOftware Name, version, publisher and number if installations.to start:How would i...
Simple query, unexpected result. I am using the second Custom2 field to save Cost, since Lansweeper is about the only inventory system in the world without a field for it Trying to see something over the cost of $500SELECT a.AssetName, at.AssetType...
Is there a way to generate a report that would allow one to search by a username and generate a list of machines that person has logged into? This info is then used for me to login to their computer.
