Does anybody know how...

Post by **FragaGeddon** » Thu Nov 10, 2005 4:35 am

riddla wrote:pete really needs to learn to fuck off in threads where he has no clue.

Fucking A!

Post by **raw** » Thu Nov 10, 2005 4:42 am

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:

Can't you do a printer search in Active Directory, add/remove columns, and export that?

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.csv

[/color]

Post by **R00k** » 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:

Post by **raw** » 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.

)

Post by **R00k** » Thu Nov 10, 2005 5:09 am

Nice. :icon14: SQL Personal comes in handy - and that's a pretty solid recovery plan, lol.

Post by **raw** » 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.

Guest · Post by **Guest** » Thu Nov 10, 2005 10:55 pm

riddla wrote:pete really needs to learn to fuck off in threads where he has no clue.

For once I agree with you. I really badly must have read the topic in the first place.

Post by **sexybabygirl** » Fri Nov 11, 2005 6:40 am

Post by **werldhed** » Fri Nov 11, 2005 6:49 am

That was unexpected.

Post by **R00k** » Fri Nov 11, 2005 1:38 pm

Both were.

A/S/L, sexy?

Post by **raw** » Sat Nov 12, 2005 12:19 am

Her name is really "Large Marge"

)