cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
davez
Engaged Sweeper
i need a report that will detail what version is on each computer. anybody?
1 ACCEPTED SOLUTION
Salamine
Engaged Sweeper III
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblSoftware.softwareName As Software, tblSoftware.softwareVersion As Version
From tblSoftware Inner Join
tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Where tblSoftware.softwareName Like '%Acrobat %'
Order By tblSoftware.softwareVersion, tblComputers.ComputerUnique

View solution in original post

1 REPLY 1
Salamine
Engaged Sweeper III
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblSoftware.softwareName As Software, tblSoftware.softwareVersion As Version
From tblSoftware Inner Join
tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Where tblSoftware.softwareName Like '%Acrobat %'
Order By tblSoftware.softwareVersion, tblComputers.ComputerUnique