I am new to the lansweeper, but I am trying to make a report that is to give me a detailed inventory by server of all the software that is installed on each server.
I need a report of basically everything (Servers, Computers, Routers, Etc) with name, make/model, S/N and maybe IP. Anyone know what tables will put all of this together?
Does anyone know of a way to generate something like this? Yes, WSUS wlll show this to you, however we have several WSUS servers and was wondering if I could use LanSweeper to consolidate this into a single view.
Below I have pasted my code in. I'm trying to get a report on the versions of 2 different software apps. 1 is Symantec and the other is our TSM backup. Some or both might not have the software installed. That is 1 thing I'm looking for also. The pr...
Would be really grateful if anyone can help with this report.. I need a report with the following: Computer, Manufacturer, Model, OS, SP, CPU, #Processors, Memory, IP, and Install date. I seem to be missing something in the SQL report builder and ...
I finally finished this report but haveing a problem changing the Total Physical Memory from bytes to MB (from 4294144000 to 4294). Here is my code below.Select Top 1000000 tblComputers.Computer, tblComputers.Domain, tblCompCustom.Custom2 As [Tech Co...
Hello,I have seen this post to report locally installed printersSELECTtblcomputers.ComputerUnique,tblPrinters.Caption,tblPrinters.Portname,tblPrinters.Sharename,tblPrinters.Location,tblPrinters.CommentFROMtblcomputersINNER JOIN tblPrinters ON (tblcom...
In my network I have servers with static IP and clients with dynamic IP.How can I modify "Network: Static IP address configured" query in order to see just clients and not servers?Thanks.
