I’m currently working at a customer site, where I was required to evaluate all their printers for Windows 7 compatibility. I needed to get a dump of all the printers in Active Directory in a useable format (like a CSV file), so I could compare model numbers of the printers – and begin my search for Windows 7 drivers.
To do this is quiet easy, but it did take me a while to figure it out. You can get a dump of all the printers out of AD by using the CSVDE command. Run this command as the administrator on a domain controller.
csvde.exe -f c:printerdmp.csv -r (objectCategory=printQueue)
To change the location of where to write the CSV file, just change the path. This command does give you a lot of information, but once you open the CSV file in Excel, you can just delete the columns you don’t need.