Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper

I'm conceptualizing a possible way to query particular information from Lansweeper.

The basic premise is this: Take a given unique Identifyingnumber, query the lansweeper database to see if that workstation has all or any of software packages 1,2, or 3 installed. I would like to search for the software using some sort of ID or key instead of a text string if possible. Does such an ID for a particular software entry exist and how would I find it?

If you could provide a general query for 1 computer based on this, I should be able to adapt and script it for the rest of them.


Lansweeper Alumni
There is currently no unique ID you can use to identify software packages. You will have to search for them based on other criteria like name, version or publisher.

An example report to find particular software on a particular computer can be seen below.
Select tblComputers.Computername, tblComputers.Computer, tblComputers.Domain,
tblSoftware.softwareName, tblSoftware.softwareVersion,
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where (tblComputers.Computer = 'YourComputer' And tblSoftware.softwareName Like
'%FirstSoftwarePackage%') Or
(tblComputers.Computer = 'YourComputer' And tblSoftware.softwareName Like
Order By tblSoftware.softwareName