Hi Guys,I was wondering how can I change the name of a state?ie. active, non-active, sold? i want to rename some of them and when I do a report to show the value, not just the number in the column.Regards,QuA
Hello,We are new users of Lansweeper and we need to group the scaned software. The program detects many different software that in fact is the same software. For example we have Windows 2000 profesional, Windows 2000 profesional SP1 and more. The sam...
I have a need to pull a report for the workstations & servers that Lansweeper is failing to run on. I need to be able to run a report that can list the error(s) that are causing Lansweeper to not inventory the device.I can see the "errors" if I look...
Hello,first of all: great Tool!My first question:how could I select alle Software of one type names whithout knowing korrekt Version extens?e.g.: WHERE (softwareName = 'Windows Internet Explorer 7')is the full known Software-String.And how could...
I'd like to create a report to figure out how many Microsoft Office licenses we are using. I want it to cover Office 2003, Office 2007, Visio, and Project. I haven't seen a standard report that will do this, and I can't figure out how to create a c...
I have a report as follows:Select tblComputerSystemProduct.Name, tblComputers.Computername, tblComputers.Lastseen, tblComputers.Username, tblComputerSystemProduct.IdentifyingNumber From tblComputers Inner Join tblComputerSystemProduct On (tblComputer...
Hi everyone.Now I managed to create 2 report errors trying to create this report in Report Builder.Does anyone have an idea of what my SQL should be for the following:Hardware report that shows all PCs with names beginning with "XSS" and with less th...
Trying to run the built in Software Report in lsbuilder and it's coming up with no data. We have plenty of data and I've run other reports with success. Here is the the SQL and I haven't done any kind of modification to it:SELECT web30repsoftwareto...