Printer Devices Using Magic

Today there is NO SQL service for getting the list of printer devices.  If you want to automatically integrate you devices.. its just not easy.  One of our ISV asked us is there a way to do that with SQL.  At first the thought was no...there is no SQL services.  BUT, upon review we thought, we have a toolbox of services that can be used and if you combine a few...walla!   You have your list devices in an automated manner.  In this iSee we will unwrap how to use a CL command that only creates spool data, use some nifty SQL to pull part that spool file to build a table with the data we are after.  This iSee while sure it give you the printer devices, its far more, its a learning guide to some very powerful SQL techniques