Static IP

[paprita]

In my network I have servers with static IP and clients with dynamic IP.
How can I modify "Network: Static IP address configured" query in order to see just clients and not servers?

Thanks.

[paprita]

It run ...thanks.

[Hemoco · Accepted solution]

Use the "domainrole" field in tblcomputersystem

Select Top 1000000 dbo.tblComputers.Computername,
  dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain,
  Web40OSName.Compimage As icon, dbo.tblNetwork.IPAddress,
  dbo.tblNetwork.IPSubnet, dbo.tblNetwork.Lastchanged,
  tbldomainroles.Domainrole, tbldomainroles.Domainrolename
From dbo.tblComputers Inner Join
  dbo.tblNetwork On dbo.tblComputers.Computername = dbo.tblNetwork.Computername
  Inner Join
  dbo.web40ActiveComputers On dbo.tblComputers.Computername =
    dbo.web40ActiveComputers.Computername Inner Join
  Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
  Inner Join
  tblComputersystem On dbo.tblComputers.Computername =
    tblComputersystem.Computername Inner Join
  tbldomainroles On tbldomainroles.Domainrole = tblComputersystem.Domainrole
Where dbo.tblNetwork.IPAddress <> '0.0.0.0' And dbo.tblNetwork.IPEnabled = 1 And
  dbo.tblNetwork.DHCPenabled = 0 And dbo.tblNetwork.IPAddress <> '' And
  tbldomainroles.Domainrole < 3
Order By dbo.tblComputers.Computer