Basic OS overview for server-type machines:
Quote:Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Web40OSName.OSname, tblComputersystem.Lastchanged,
Web40OSName.Compimage As icon
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername
Where tblComputersystem.Domainrole > 1
Order By dbo.tblComputers.Computer
Office versions can be filtered in a number of ways, the most common being by name. Example report to show all computers that have Microsoft Office 2003 installed:
Quote:Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSoftware.softwareName, tblSoftware.softwareVersion
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName Like 'Microsoft Office 2003%'
Order By tblComputers.Computer
