Identifying computers connected to the LAN?

[greatmacoy]

Q101676, Q210088, Q148835 retreives computer information
like windows log-on name, computername, workgroup, and
domainname.

I also need the following info:
1. The OS installed (Windows 95, 98, Me, 2000, Xp, or
2003)
2. The computer names or ip addresses of the
computers which are connected to the LAN or belong to a
workgroup which the local computer belongs to.

Can anybody share the MS Access Module code for these?

Please help.

 

[M.L. Sco Scofield]

There is some background info in the Knowledge Base article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210200.

Unfortunately the tests there are not complete.

For a more expanded version, take a look at
http://www.mvps.org/access/api/api0055.htm from The access Web site.

It is still missing a couple of the latest op systems.

Although this article,
http://msdn.microsoft.com/library/d...s/sysinfo/base/getting_the_system_version.asp,
from the Platform SDK is in VC++, you should be able to get enough info from
it to finish off of the VBA version.

Good luck.

Sco

 

[greatmacoy]

Thank you for sharing those hard-to-find information.

Now, the only thing I need is the code to determine the
computers on the LAN through their names and ip or mac
addresses.

Thanks

 

[M.L. Sco Scofield]

"...the only thing I need is..."???

OK, *now* you're talking some minor brain surgery!

The magic to network stuff is the Active Directory Service Interfaces known
as ADSI.

Start with looking at
http://support.microsoft.com/default.aspx?scid=kb;en-us;194115.

The are a *ton* of ADSI articles in the MS Knowledge Base at
http://support.microsoft.com/default.aspx?scid=fh;EN-US;KBHOWTO. Search for
ADSI.

There is a newsgroup for ADSI at
microsoft.public.active.directory.interfaces.

Good luck.

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com