32 or 64 bit devices

[kevinoie]

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

[Hemoco · Accepted solution]

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