Grouping computers by subnet

[KRH]

Hi,

In our network we have multiple subnets. I want to create a report that shows the following in the webgui:

subnet 1 workstations
subnet 2 workstations
subnet 3 workstations

How i can implement this and use subnet ip to group computers? I'm not very familiar with sql syntaxes..

[KRH]

I figured it out by myself.

It was pretty easy.

Sample query:

Select tblNetwork.Computername, tblNetwork.IPAddress, tblNetwork.DHCPenabled
From tblNetwork 
Where tblNetwork.IPAddress Like '%10.1%' And tblNetwork.DHCPenabled Like 'True'

DHCPEnableb is there because i wanted to filter out servers.


Lansweeper is just superior!!