I had to find a way to get all the printers attached to a particular host computer by using SQL reporting services.
Prerequisite – Please make sure that “Printer Device” and “Printer Share” classes has been enabled in hardware inventory.
Default Client Settings > Properties > Hardware Inventory > Hardware Inventory Classes > Set Classes
Please check if the above classes have been enabled. Once that is done, please use the below query to create a custom report.