→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kevinoie
Engaged Sweeper III
Can you tell me what table i need to add to the below to tell me if the OS is 32 or 64bit.. That would be a great help.....................



Select Top 1000000 dbo.tblComputers.Computer, dbo.tblComputers.Domain,
dbo.tblComputers.Description, dbo.tblComputers.Lastseen,
dbo.tblComputers.LastknownIP, Web40OSName.OSname
From dbo.tblComputers 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
tblComputersystem On dbo.tblComputers.Computername =
tblComputersystem.Computername
Where dbo.tblComputers.Computername Not In (Select dbo.tblSoftware.ComputerName
From dbo.tblSoftware Cross Join dbo.tsysantivirus
Where dbo.tblSoftware.softwareName Like dbo.tsysantivirus.Software) And
tblComputersystem.Domainrole < 2
Order By dbo.tblComputers.Computer



Kev

1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni

Select Top 1000000 dbo.tblComputers.Computer, dbo.tblComputers.Domain,
dbo.tblComputers.Description, dbo.tblComputers.Lastseen,
dbo.tblComputers.LastknownIP, Web40OSName.OSname, tblComputersystem.SystemType
From dbo.tblComputers 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
tblComputersystem On dbo.tblComputers.Computername =
tblComputersystem.Computername
Where dbo.tblComputers.Computername Not In (Select dbo.tblSoftware.ComputerName
From dbo.tblSoftware Cross Join dbo.tsysantivirus
Where dbo.tblSoftware.softwareName Like dbo.tsysantivirus.Software) And
tblComputersystem.Domainrole < 2
Order By dbo.tblComputers.Computer

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni

Select Top 1000000 dbo.tblComputers.Computer, dbo.tblComputers.Domain,
dbo.tblComputers.Description, dbo.tblComputers.Lastseen,
dbo.tblComputers.LastknownIP, Web40OSName.OSname, tblComputersystem.SystemType
From dbo.tblComputers 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
tblComputersystem On dbo.tblComputers.Computername =
tblComputersystem.Computername
Where dbo.tblComputers.Computername Not In (Select dbo.tblSoftware.ComputerName
From dbo.tblSoftware Cross Join dbo.tsysantivirus
Where dbo.tblSoftware.softwareName Like dbo.tsysantivirus.Software) And
tblComputersystem.Domainrole < 2
Order By dbo.tblComputers.Computer