RE: AD to Access

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

RE: AD to Access

Logged in as: Guest

arrSession:exec spGetSession 2,2,42182

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> RE: AD to Access
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: << < prev 1 [2]

Message

<< Older Topic Newer Topic >>

RE: AD to Access - 1/19/2007 3:02:13 AM

dm_4ever

Posts: 2430
Score: 38
Joined: 6/29/2006
From: Orange County, California
Status: offline

Yes.

_____________________________

dm_4ever

My philosophy: K.I.S.S - Keep It Simple Stupid
Read Me: http://www.visualbasicscript.com/m_24727/tm.htm
Frequently Asked Stuff: http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to twilliamsen)

Post #: 21

RE: AD to Access - 1/19/2007 3:05:05 AM

twilliamsen

Posts: 195
Score: 0
Joined: 1/18/2007
Status: offline

Excellent. I will give it a whirl and see how it does!

Next steps is to

send it to a SQL Server DB

Create a stored procedure to fire off the script

Create change histories of each computer

Query SMS to grab information from its DB to have one Inventory DB

(in reply to dm_4ever)

Post #: 22

RE: AD to Access - 1/22/2007 2:11:12 AM

twilliamsen

Posts: 195
Score: 0
Joined: 1/18/2007
Status: offline

Works as it is suppose to! One issue, now the boss wants servers in one table and workstations in another table. Great. Servers are all over the place(in the AD). There is one in Servers OU, and another group in a Domain Controller OU. Interesting.

(in reply to twilliamsen)

Post #: 23

RE: AD to Access - 1/22/2007 3:37:19 AM

dm_4ever

Posts: 2430
Score: 38
Joined: 6/29/2006
From: Orange County, California
Status: offline

You can try changing you AD query to something like this to look for all computers in your domain:
"Select Name, operatingSystem from 'LDAP://DC=corp-nj,DC=mrsassociates,dc=com' Where objectclass = 'Computer'"
You can use the operatingSytem info to determine what table to insert data into.

_____________________________

dm_4ever

My philosophy: K.I.S.S - Keep It Simple Stupid
Read Me: http://www.visualbasicscript.com/m_24727/tm.htm
Frequently Asked Stuff: http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to twilliamsen)

Post #: 24

RE: AD to Access - 1/22/2007 3:44:20 AM

twilliamsen

Posts: 195
Score: 0
Joined: 1/18/2007
Status: offline

Yes, I was thinking that. I have two scripts that are running as one. One is for the workstations and the other is for servers. Now if I can shorten the script where it gets the OS and I tell it, if the OS is Windows Server 2003 insert into Server table, I would assume that would really shorten up the time it takes to run. It takes about 2 hours to populate 2 tables for about 700 computers, which is way too long

(in reply to dm_4ever)