Community FAQ
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

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now