How can I retreive computer information from Active Directory

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
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.
 
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.
 
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..
 
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..
Click to expand...
 
Back
Top