SQL Query Help

[bpc]

Hello,

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.

Thanks!

[Hemoco]

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,
tblSoftware.SoftwarePublisher
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
'%SecondSoftwarePackage%')
Order By tblSoftware.softwareName