Please use the report below for the information you are after.
Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Firstseen, tblComputers.Lastseen, tblComputers.Userdomain,
tblComputers.Username, tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSoftware.Installdate,
SkypeCount.[Total Skype Installations]
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName,
(Select Count(tblSoftware.ComputerName) As [Total Skype Installations]
From tblSoftware
Where tblSoftware.softwareName Like '%skype%') SkypeCount
Where tblSoftware.softwareName Like '%skype%'
Order By tblComputers.ComputerUnique, tblSoftware.softwareName,
tblSoftware.softwareVersion
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.
