Need help with a report that includes the following:

[ESIT]

I need to provide a report that provides a certain type of software (in this case, Cisco IP Communicator), version number, and the users that have it installed.

We need to contact our IP Communicator users that are running older versions and have them upgrade to the latest.

Thanks in advance for any help with this, I'm not a Lansweeper Reporting guru.

[ESIT]

Never mind, I got it. Forgot to include ' ' around my software name.

Thanks a million for your help, this was exactly what I needed!

[ESIT]

Thank you. I am getting a error when trying to save this though. Says incorrect snytax near 'IP'

SELECT
dbo.tblComputers.Computername,
dbo.tblComputers.Userdomain,
dbo.tblComputers.Username,
dbo.tblSoftware.softwareName,
dbo.tblSoftware.softwareVersion
FROM
dbo.tblComputers
INNER JOIN dbo.tblSoftware ON (dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName)
WHERE
dbo.tblSoftware.softwareName = Cisco IP Communicator

[Hemoco]

SELECT dbo.tblComputers.Computername, dbo.tblComputers.Userdomain, dbo.tblComputers.Username, dbo.tblSoftware.softwareName,
dbo.tblSoftware.softwareVersion
FROM dbo.tblComputers INNER JOIN
dbo.tblSoftware ON dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName
WHERE (dbo.tblSoftware.softwareName = 'softwarename you want')