Calling all techies, calling all techies...

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » October 30th, 2006, 14:24

Anybody here know how to export a list of shared windows printers along with their Location, Comments details into a spreadsheet file such as *.csv or *.xls?

I really really don't want to type this out manually for over a hundred printers, and I'm pretty sure you guys would have had to do this at some point in your career.

If it helps, we have Active Directory and the printers are installed on a clustered 2003 server, but I assume that should make no odds.

Thanks in advance

Fear · Post by **Fear** » October 30th, 2006, 14:34

On the "Windows 2000 Server Resource Kit Supplement" CD there is a vbs script named share.vbs.

You want this.

Code: Select all

The Kit Supplement contains Share.VBS, which can list, create, or delete shares from a local or remote computer. The syntax is:

1.  Share.vbs /L [/S <server>] [/U <username>] [/W <password>]
                 [/O <outputfile>]
2.  Share.vbs /C /N <name> /P <path> [/T <type>] [/V <description>]
             [/S <server>] [/U <username>] [/W <password>]
             [/O <outputfile>]
3.  Share.vbs /D /N <name>
             [/S <server>] [/U <username>] [/W <password>]
             [/O <outputfile>]

PARAMETER SPECIFIERS:
   /L            Lists all shares on a machine.
   /C            Creates a share on a machine.
   /D            Deletes a share from a machine.
   name          Name of the share to be created or deleted.
   path          Path of the share to be created.
   description   A description for the share.
   type          Type of the share to be created. Must be one
                 one of Disk, Printer, IPC, Special.
   server        A machine name.
   username      The current user's name.
   password      Password of the current user.
   outputfile    The output file name.

EXAMPLE:
1. cscript Share.vbs /l /s MyMachine2
   List the shares on the machine MyMachine2.
2. cscript Share.vbs /c /n scratch /p c:\scratch /t Disk /v "Scratch Directory"
   Creates a file share called "scratch" on the local machine.
3. cscript Share.vbs /d /n scratch /s MyMachine2.
   Deletes the share named "scratch" on the machine MyMachine2.

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » October 30th, 2006, 15:15

Brilliant stuff!

Slight problem though, I cannot find that CD anywhere

Post by **fabyak** » October 30th, 2006, 16:25

Had to use Google to find the bloody things on M$'s website but here be downlaods of said resource kit tools

http://download.microsoft.com/download/2/0/C/20C1B0F7-B803-4BAB-BA2F-27DDCADAD68E/sp4supporttools.exe

Otherwise this should do it

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » October 30th, 2006, 16:45

I was so nearly

'd then.
Thanks dude, much appreciated, I was havign issues finding that online myself.

Post by **fabyak** » October 30th, 2006, 16:47

Pleasure

both for the attempted horseying and the link, I remember it being a bitch to find when I last wanted it too

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » October 30th, 2006, 16:56

Hmmm, that exe doesn't seem to contain the share.vbs script mentioned above

I've searched the entire hard drive and install directories, and can't find it anywhere?

Damn Microsoft, damn them to hell

Fear · Post by **Fear** » October 30th, 2006, 16:59

It comes with the supplement CD so perhaps wont be in the 'free' M$ downloads.

I'll see if I can dig out the script from anywhere, gotta find the cd first.

Post by **fabyak** » October 30th, 2006, 17:13

This may be what you're after

http://www.microsoft.com/windows2000/do ... tools.mspx

*WARNING* THE ABOVE LINK DOES NOT CONTAIN HORSES

ARSE, and looks like it may be the same thing

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » October 31st, 2006, 15:15

Looks like I'm an hour away from giving up and typing this thing out manually

Damn you Microsuck, damn you!

Fear · Post by **Fear** » October 31st, 2006, 15:17

Try sitting on the server which shares the printers and typing:

Code: Select all

net share

This will give you a list you can cut and paste and will probably be a lot quicker than hand writing them. It does not exclude non-printer shares tho.

Code: Select all

Share name   Resource                        Remark

-------------------------------------------------------------------------------
print$       C:\WINDOWS\system32\spool\drivers
                                             Printer Drivers
C$           C:\                             Default share
ADMIN$       C:\WINDOWS                      Remote Admin
IPC$                                         Remote IPC
EPSON880     USB001                 Spooled  EPSON Stylus COLOR 880
The command completed successfully.

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » October 31st, 2006, 15:21

Thanks mate, that's something so simple, I never would have thought of it.
At least it makes things slightly easier by having to just edit stuff, and not completely populate the list.

Damn you Microsuck for truncating my results!

Fear · Post by **Fear** » October 31st, 2006, 15:26

Woo Elephant Yeah wrote:Damn you Microsuck for truncating my results!

Right click on the command window icon, properties.

Then set the buffer size here (in # of lines) which you need to be able to see all your results. Should make it a little easier.

(edit: layout tab not options tab)

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » October 31st, 2006, 15:43

Hmm doesn't make any difference it seems, thanks anyway though dude.

/Ninja Edit

Post by **Dr. kitteny berk** » October 31st, 2006, 16:29

would something similar be possible dumping to text file using Gonad?

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » October 31st, 2006, 17:24

Managed to cheat and print screen to tiff, then OCR the files and save them as a spreadsheet.

Hoorah for overly complicated methods of doing simple things!

Post by **Dog Pants** » October 31st, 2006, 18:20

Woo Elephant Yeah wrote:Hoorah for overly complicated methods of doing simple things!

Hooray! Have you ever considered a career in the military?

Woo Elephant Yeah · Post by **Woo Elephant Yeah** » May 29th, 2007, 14:50

Cast Resurrect Thread Level 111eleventyone!

I need to do the same thing again, and I'm really reluctant to save printscreens and OCR them again

Anyone have any other suggestions, as I still can't find that Share.vbs script Fear mentioned anywhere.

Surely there must be an easy way to output every printer on a file and print server into a file in some way? I'm googled out, but I wondered if any of you techies new any decent sites for posting questions such as this?

mrbobbins · Post by **mrbobbins** » May 29th, 2007, 15:14

Have you tried just not doing it?

This usually works when I don't know how/can't be bothered to do something.

Chickenz · Post by **Chickenz** » May 29th, 2007, 16:32

I'm a Weapons Technician if that helps Woo?!?!

I'm sure I could get some PE4 if you want to blow it up