Filter by PC or Server

[lewis_turner]

What Database field can I use to differentiate a PC from a Server.

I have A report detailing the operating systems however it is including server is with it - I only want the info for pc's

Any ideas anybody?

[taeratrin]

Not sure if it's the same in 3.5, but in 4 it is in tblComputersystem.Domainrole. A value >1 indicates that it is a server.

[Hemoco]

taeratrin wrote:
Not sure if it's the same in 3.5, but in 4 it is in tblComputersystem.Domainrole. A value >1 indicates that it is a server.

0 Standalone Workstation
1 Member Workstation
2 Standalone Server
3 Member Server
4 Backup Domain Controller
5 Primary Domain Controller