Posted: Thu Nov 10, 2005 4:35 am
Fucking A!riddla wrote:pete really needs to learn to fuck off in threads where he has no clue.
Page 2 of 2
Posted: Thu Nov 10, 2005 4:42 am
Can't you do a printer search in Active Directory, add/remove columns, and export that?R00k wrote:Hmm, when I ran it on the server I got a lot more of those messages.
They're easy to weed out with a data sort in Excel, but I'm kinda curious what they are.
At any rate, just ran it, cleaned it, imported it, saved it and I'm going home. Cheers. :icon14:
Also, if it is in Active Directory you can use csvde.exe on any Windows 2000+ Server in the Winnt or System32 directory. This used with the -f command will output everything in Active Directory to a .csv file where you can import it into Excel, Access, or SQL.
Code: Select all
C:\Winnt\:>csvde -f c:\active_directory.csvPosted: Thu Nov 10, 2005 4:48 am
This domain runs on NT4 domain controllers. 
We'll be joining a bigger AD domain later, so we don't plan on upgrading these.
I was thinking earlier how nice it would be to have the AD to search, but I didn't know about that second tool. :icon14:
We'll be joining a bigger AD domain later, so we don't plan on upgrading these.
I was thinking earlier how nice it would be to have the AD to search, but I didn't know about that second tool. :icon14:
Posted: Thu Nov 10, 2005 4:55 am
Yeah, I recently had to use csvde to export all of my objects out of AD so I can sort and export all accounts with email addresses to send to a 3rd party mail provider as a disaster, disaster/recovery plan. 
)
Basically, I had a 27mb csv (text file) with tons of records. Excel couldn't handle the amount of records and Access is just a piece of shit. So I installed SQL Server 2000 Personal on my laptop, import the csv into a new database, and ran a query to get all the records I wanted. If I had of used SQL from the start, I could have finished this task in a half hour instead of in half a day.)
)Basically, I had a 27mb csv (text file) with tons of records. Excel couldn't handle the amount of records and Access is just a piece of shit. So I installed SQL Server 2000 Personal on my laptop, import the csv into a new database, and ran a query to get all the records I wanted. If I had of used SQL from the start, I could have finished this task in a half hour instead of in half a day.
)Posted: Thu Nov 10, 2005 5:09 am
Nice. :icon14: SQL Personal comes in handy - and that's a pretty solid recovery plan, lol.
Posted: Thu Nov 10, 2005 5:11 am
Basically, our DR plan is about 30% complete so we got caught with our pants down. I had to improvise quickly.
Posted: Thu Nov 10, 2005 10:55 pm
For once I agree with you. I really badly must have read the topic in the first place.riddla wrote:pete really needs to learn to fuck off in threads where he has no clue.
,
Posted: Fri Nov 11, 2005 6:40 am
Posted: Fri Nov 11, 2005 6:49 am
That was unexpected.
Posted: Fri Nov 11, 2005 1:38 pm
Both were.
A/S/L, sexy?
A/S/L, sexy?
Posted: Sat Nov 12, 2005 12:19 am
Her name is really "Large Marge" )
)