Microsoft Software Reporting

[kevinoie]

Hi.. I need help..... Im tryin to run a report that will show me all devices that are running Microsoft Lync 2010 along with what version of office is on the device. I can run a report to show one of these application but i cant seem to figure out how to run a report to show both. Any help would be greatly appreciated. Kev..

[Hemoco]

Anyone else wanting a similar report, please try the query below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblSoftware.softwareName, tblSoftware.softwareVersion,
OfficeVersion.[Office Name], OfficeVersion.[Office Version]
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Left Join
(Select tblSoftware.ComputerName, tblSoftware.softwareName As [Office Name],
tblSoftware.softwareVersion As [Office Version]
From tblSoftware
Where tblSoftware.softwareName Like '%microsoft office%') OfficeVersion On
OfficeVersion.ComputerName = tblComputers.Computername
Where tblSoftware.softwareName Like '%microsoft lync 2010%'
Order By tblComputers.ComputerUnique, tblSoftware.softwareName

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.

[kevinoie]

Problem sorted...Figured it out..