report to show Server 2008 (32bit)

[Lars_Vopicka]

Does anyone know how to differentitiate between 64 and 32 bit Server 2008?

My Query shows all 2008 Servers, regardles 64/32bit. What has to be added?

Select Top 100 Percent dbo.tblComputers.Computername As Computer, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Caption, dbo.tblOperatingsystem.Lastchanged From dbo.tblOperatingsystem Inner Join dbo.tblComputers On dbo.tblOperatingsystem.Computername = dbo.tblComputers.Computername Inner Join dbo.tblComputersystem On dbo.tblComputers.Computername = dbo.tblComputersystem.Computername Where dbo.tblOperatingsystem.Version = '6.0.6001' And dbo.tblComputersystem.Domainrole > '1' Order By dbo.tblComputers.Domain

As we are searching Server 2008 x86 for SMB2 vulnerability there is a needd to tell wheter or not file Services are running. Any Idea on that?

EDIT: (FileServices Added)

Select Top 100 Percent dbo.tblComputers.Computername As Computer, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Caption, dbo.tblOperatingsystem.Lastchanged, dbo.tblComputersystem.Roles From dbo.tblOperatingsystem Inner Join dbo.tblComputers On dbo.tblOperatingsystem.Computername = dbo.tblComputers.Computername Inner Join dbo.tblComputersystem On dbo.tblComputers.Computername = dbo.tblComputersystem.Computername Where dbo.tblOperatingsystem.Version = '6.0.6001' And dbo.tblComputersystem.Domainrole > '1' And dbo.tblComputersystem.Roles Like '%LM_Server%' Order By dbo.tblComputers.Domain

but how to differentiate 64 from 32 bit?

[Hemoco]

Some remarks:

Win2008 R2 is only 64 bit (no 32 bit version)
It's also possible to install the 32 bit version on 64 bit hardware.

[Hemoco]

In the description in table operatingsystem it should say "... x64 Edition"

[Lars_Vopicka]

Lansweeper wrote:
In the description in table operatingsystem it should say "... x64 Edition"

It does not. Never mind.