cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ESIT
Engaged Sweeper
Hello, the following has everything I need except I need Asset Tags included and I can't figure out how to add that without messing everything else up. Here's the code if someone could help add Asset Tags to this:

Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname, Web40OSName.SP, tblOperatingsystem.Description, dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon, dbo.tblComputers.LastknownIP, dbo.tblComputersystem.Model, dbo.tblComputersystem.Manufacturer From dbo.tblComputersystem Inner Join dbo.tblComputers On dbo.tblComputersystem.Computername = dbo.tblComputers.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername Inner Join tblOperatingsystem On dbo.tblComputers.Computername = tblOperatingsystem.Computername Where dbo.tblComputersystem.Domainrole < '2' Order By dbo.tblComputers.Computer


Thanks!
2 REPLIES 2
ESIT
Engaged Sweeper
Forgot to mention, this worked like a charm, thanks!
Hemoco
Lansweeper Alumni
Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname,
Web40OSName.SP, tblOperatingsystem.Description,
dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon,
dbo.tblComputers.LastknownIP, dbo.tblComputersystem.Model,
dbo.tblComputersystem.Manufacturer, tblComputerSystemProduct.IdentifyingNumber
From dbo.tblComputersystem Inner Join
dbo.tblComputers On dbo.tblComputersystem.Computername =
dbo.tblComputers.Computername Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Inner Join
tblOperatingsystem On dbo.tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblComputerSystemProduct On dbo.tblComputers.Computername =
tblComputerSystemProduct.Computername
Where dbo.tblComputersystem.Domainrole < '2'
Order By dbo.tblComputers.Computer