cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dialtone
Engaged Sweeper
I spent some time searching and need help. In our school distrcit we have 26 different schools. All computer names in one school begin with the same 3 letters. I want to adjust the "List of software by computer" report to only give me computers that begin with the letters "GRM". Can someone assist because I am not sure where to enter that criteria.

thanks
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain,
dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As
Version, dbo.tblSoftware.SoftwarePublisher As Publisher, Web40OSName.Compimage
As icon
From dbo.tblSoftware Inner Join
dbo.tblComputers On dbo.tblSoftware.ComputerName =
dbo.tblComputers.Computername Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Where dbo.tblComputers.Computer Like 'GRM%'
Order By dbo.tblComputers.Computer, dbo.tblSoftware.softwareName,
dbo.tblSoftware.softwareVersion

View solution in original post

2 REPLIES 2
Hemoco
Lansweeper Alumni
Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain,
dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As
Version, dbo.tblSoftware.SoftwarePublisher As Publisher, Web40OSName.Compimage
As icon
From dbo.tblSoftware Inner Join
dbo.tblComputers On dbo.tblSoftware.ComputerName =
dbo.tblComputers.Computername Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Where dbo.tblComputers.Computer Like 'GRM%'
Order By dbo.tblComputers.Computer, dbo.tblSoftware.softwareName,
dbo.tblSoftware.softwareVersion
Lansweeper wrote:
Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain,
dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As
Version, dbo.tblSoftware.SoftwarePublisher As Publisher, Web40OSName.Compimage
As icon
From dbo.tblSoftware Inner Join
dbo.tblComputers On dbo.tblSoftware.ComputerName =
dbo.tblComputers.Computername Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Where dbo.tblComputers.Computer Like 'GRM%'
Order By dbo.tblComputers.Computer, dbo.tblSoftware.softwareName,
dbo.tblSoftware.softwareVersion



Thanks a bunch!