Hi Releint,
you might consider using the report generator which is part of premium tools.
try this one.
Select Top 100 Percent dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As Version, dbo.tblSoftware.SoftwarePublisher As Publisher, Count(dbo.tblSoftware.ComputerName) As Total, tblComputersystem.Domainrole From dbo.tblSoftware Inner Join dbo.tblComputers On dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername Inner Join tblComputersystem On dbo.tblComputers.Computername = tblComputersystem.Computername Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion, dbo.tblSoftware.SoftwarePublisher, tblComputersystem.Domainrole Having tblComputersystem.Domainrole = '3' Order By Count(dbo.tblSoftware.ComputerName) Desc
