Good morning,
I have a report that shows a summary of what version of Adobe Reader is installed in our organisation. When I click a version link it drills down to list all the machines with that version, the domain, description, software, version number and date. The date is the last scanned date (I think). Can this be changed to the installed date?
Select Top 1000000 dbo.tblSoftware.softwareName As Software,
dbo.tblSoftware.softwareVersion As Version, Count(tblComputers.Computer) As
Number
From dbo.tblSoftware Inner Join
tblComputers On tblComputers.Computername = dbo.tblSoftware.ComputerName
Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion
Having dbo.tblSoftware.softwareName Like 'Adobe Reader%'
Tony
In view of the fact that God limited the intelligence of man, it seems unfair that He did not also limit his stupidity.
Konrad Adenauer