Questions

How to import printers information to a spreadsheet?

Tags:
+
0 Votes
Locked

How to import printers information to a spreadsheet?

plrod1906
I have over 60 printers on my windows 2003 servers, I want to list all the printers information on an excel spreadsheet. How can I import these settings to a spreadsheet. Do I have to write a script.
  • +
    0 Votes
    scott_heath

    Try:

    wmic printer get /format:csv > printers.csv

    If you want to cut out some of the "fat" you can add the property names like so:

    wmic printer get sharename, portname, etc /format:csv > printers.csv

    +
    1 Votes
    sravana.jella

    Use printmig.exe tool ..I'm not sure whether it is not suitable to your requirement....
    (Printmig 3.1)

  • +
    0 Votes
    scott_heath

    Try:

    wmic printer get /format:csv > printers.csv

    If you want to cut out some of the "fat" you can add the property names like so:

    wmic printer get sharename, portname, etc /format:csv > printers.csv

    +
    1 Votes
    sravana.jella

    Use printmig.exe tool ..I'm not sure whether it is not suitable to your requirement....
    (Printmig 3.1)