Help with reporting....

[cossie]

Hi there.

First of all i need to say that im not wery strong in SQL.

I would like to know if it is possible to segment the views you have in to different sites.

eg. i would wery much like to have an report that show me all installed software on a given subnet is this possible??

/Jesper

[Hemoco]

Are the other sites in a differt domain? maybe you can use this.

Other possibilities:
Different computername (like sitename%)
Users are in a different OU in active directory?
Otherwise, use field ipaddress in table tblnetwork

[cossie]

Lansweeper wrote:
Are the other sites in a differt domain? maybe you can use this.

Other possibilities:
Different computername (like sitename%)
Users are in a different OU in active directory?
Otherwise, use field ipaddress in table tblnetwork

No same domain.

I could properbly do something with the computernames, but the IP net would be the best - at the centreal site all computers have an 172.16.xxx.xxx address the others have 10.254 / 10.253 address.

How do i make a quiry like that? im an total newbie to SQL quiries.

[Hemoco]

With subnet do you mean an ip subnet/range?

This might be difficult as users can roam with their computers/portables.

[cossie]

Lansweeper wrote:
With subnet do you mean an ip subnet/range?

This might be difficult as users can roam with their computers/portables.

Yes an IP net.

My case is that i administrer a network with one large site with approx 300 pcs. then we have about 80 smaller location there there is 1-40 computers.

Because of budget reasons i only have to deal with the large site.

I am in the proces og testing Vista so i would like to get a report that show what software are running on all the machines in our subnet so i can start testing our software on Windows Vista.

I know this a stupid situation but thats life 😞

I i cant do this my other option is to empty the database and change the logon script so that only my users connect to the lansweeper server - i wouldnt like this becuase already here after running lansweeper fore a week it has been of great help fore us to know so much about the computers on the smaller sites.