Any idea what it will take to get this to work in v4?Select Top 100 Percent dbo.tblLicenses.softwareName, dbo.tblLicenses.softwareVersion, dbo.web30repUsedSoftware.SoftwarePublisher As Publisher, dbo.web30repUsedSoftware.[number in use], dbo.tblLi...
Hello, the following has everything I need except I need Asset Tags included and I can't figure out how to add that without messing everything else up. Here's the code if someone could help add Asset Tags to this:Select Top 1000000 dbo.tblComputers.C...
When I run the query below it is missing most but not all of the computer that haven't been seen in 30 days. Any idea why?SELECT '' as Location, TsysChassisTypes.ChassisName as Type, tblcomputers.Computer as Name, tblComputerSystemP...
I've just installed Lansweeper 4.0.0.102.Most of the custom reports work except for a few which comes up the following error.Report has an invalid syntax:Object reference not set to an instance of an object. Reports are Computers in domainAll mail se...
Hi,I'm using Lansweeper 4.0 premium version - scanning 2 domains.I wanted to extract only the software installed on 1 of these domains so I amended the All Installed Software report to show only software installed on the required domain by adding fro...
Maybe this could sound very strange, but...Is there a way to get a report which identifies machines/users that have filetypes of certain extensions in their user folder or in the machine ?Suppose that i want to find out who has ..mp3 files on his dis...
HelloI was wondering if there is a way to get a report of this tipei have several machines, some with dns x.x.x.1 and some x.x.x.2I need a report which can tellme which are the ones with x.x.x.1 and the x.x.x.2Is this possible ? Cheers It dp
