How can I retreive computer information from Active Directory

B

BigMike044

I was wondering is there a way I can retreive computer information(computer
inventory) from Active Directory using MSAccess to do the work instead of
WMI. I would like to pull the information I want, then have it automatically
imported into an access database? Any help is greatly apprecieated.
 
D

david epsom dot com dot au

There is an OLEDB supplier: you can use ADO.
You can't easily link to the data as a table, because
for linked tables, Access can only use ODBC, not OLEDB.

If you have the Active Directory stored in a SQL Server,
you could of course link to those tables, but I don't
think that has ever been documented.

You can off course reference WMI and use VBA code
to retrieve the information.

(david)
 
B

BigMike044

David, thanks for the information, I am pretty new to programming and I was
wondering if you could reference me to any sites that would give me some
insight with using VBA or WMI to retreive the information.
 
G

Guy Kerr

Mike you may be interested in hearing how I accomplish what you're try to do:
I use a VBScript that runs as part of the logon process for each user when
they log onto the domain. This script pushes a large amount of information
from the users computer (computer name, OS, RAM, serial #, installed
applications, MS Hotfixes etc.) to a SQL database. The script runs very
quickly and noboby EVER complains about a slow logon process.

I then use SQL to generate automated reports for me to keep track of newly
installed applications, hotfixes, computer serial #'s (very useful for DELL
computers since it pulls out the Service Tag #) etc. You could easily do the
same using Access reporting.
 
B

BigMike044

Guy, I was wondering If possible could you send a sample of your script. I
would like to analyze how you achieved this and learn more about your
process..
 
B

BigMike044

My email address is (e-mail address removed)

BigMike044 said:
Guy, I was wondering If possible could you send a sample of your script. I
would like to analyze how you achieved this and learn more about your
process..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top