‎06-21-2011 05:21 AM
Solved! Go to Solution.
‎06-24-2011 01:33 PM
Select tblADusers.Department, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher,
Count(tblSoftware.SoftwareID) As Total
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Group By tblADusers.Department, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
Order By tblADusers.Department, tblSoftware.softwareName
‎06-24-2011 04:18 PM
‎06-24-2011 02:19 PM
‎06-24-2011 01:33 PM
Select tblADusers.Department, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher,
Count(tblSoftware.SoftwareID) As Total
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Group By tblADusers.Department, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
Order By tblADusers.Department, tblSoftware.softwareName
‎06-21-2011 08:57 AM
‎06-21-2011 08:52 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now