03-26-2012 02:44 PM
03-28-2012 03:38 PM
03-26-2012 05:19 PM
03-26-2012 07:30 PM
adnan wrote:
For example if I wanted to include Chassis Type 3, 4 and 6 in the same report.
Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, tblComputers.Domain, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher,
SoftwareCount.[Number of Installations]
From tblComputers Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
(Select tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, Count(tblSoftware.ComputerName) As
[Number of Installations]
From tblSoftware Inner Join
tblSystemEnclosure On tblSystemEnclosure.Computername =
tblSoftware.ComputerName
Group By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSystemEnclosure.ChassisTypes
Having (tblSystemEnclosure.ChassisTypes = '3') Or
(tblSystemEnclosure.ChassisTypes = '4') Or
(tblSystemEnclosure.ChassisTypes = '6')) SoftwareCount On
SoftwareCount.softwareName = tblSoftware.softwareName And
SoftwareCount.softwareVersion = tblSoftware.softwareVersion
Where (tblSystemEnclosure.ChassisTypes = '3') Or
(tblSystemEnclosure.ChassisTypes = '4') Or
(tblSystemEnclosure.ChassisTypes = '6')
Order By tblComputers.ComputerUnique, tblSoftware.softwareName,
tblSoftware.softwareVersion
03-26-2012 04:56 PM
Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, tblComputers.Domain, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher,
SoftwareCount.[Number of Installations]
From tblComputers Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
(Select tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, Count(tblSoftware.ComputerName) As
[Number of Installations]
From tblSoftware Inner Join
tblSystemEnclosure On tblSystemEnclosure.Computername =
tblSoftware.ComputerName
Group By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSystemEnclosure.ChassisTypes
Having tblSystemEnclosure.ChassisTypes = '3') SoftwareCount On
SoftwareCount.softwareName = tblSoftware.softwareName And
SoftwareCount.softwareVersion = tblSoftware.softwareVersion
Where tblSystemEnclosure.ChassisTypes = '3'
Order By tblComputers.ComputerUnique, tblSoftware.softwareName,
tblSoftware.softwareVersion
03-26-2012 03:04 PM
03-26-2012 02:52 PM
adnan wrote:
-Count of each software on the desktop.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now