sccmug

Canadian ConfigMgr User Group

List all Printers that handle A4 paper

October 23, 2007
Posted by Garth Jones

select PRN.SystemName0, PRN.DeviceID0
from dbo.v_GS_PRINTER_DEVICE PRN
Where PRN.PrinterPaperNames0 Like (‘%A4%’)

Updated: February 25, 2016 at 10:54 am
Tags: Code, ConfigMGr, SMS, SQL, System Center
◀ Count of Windows Update Agents
News from Seattle ▶

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • SQL Query for Getting Started with Power BI Desktop and SCCM
  • Count of PCs by OU v2
  • Count of PCs by OU
  • PCs with Either of two applications installed.
  • Limiting a report to a Collection

Recent Comments

    Archives

    • December 2017 (1)
    • March 2014 (2)
    • January 2014 (3)
    • October 2013 (1)
    • September 2013 (1)
    • August 2013 (1)
    • July 2013 (3)
    • June 2013 (1)
    • April 2013 (5)
    • March 2013 (2)
    • February 2013 (4)
    • January 2013 (4)
    • December 2012 (8)
    • November 2012 (6)
    • October 2012 (5)
    • September 2012 (1)
    • July 2012 (4)
    • June 2012 (2)
    • May 2012 (7)
    • April 2012 (2)
    • March 2012 (15)
    • February 2012 (7)
    • January 2012 (7)
    • December 2011 (2)
    • November 2011 (5)
    • October 2011 (4)
    • September 2011 (4)
    • August 2011 (5)
    • July 2011 (7)
    • June 2011 (1)
    • May 2011 (2)
    • April 2011 (3)
    • March 2011 (8)
    • February 2011 (7)
    • January 2011 (8)
    • December 2010 (3)
    • November 2010 (5)
    • October 2010 (7)
    • September 2010 (7)
    • August 2010 (2)
    • July 2010 (8)
    • June 2010 (12)
    • May 2010 (4)
    • April 2010 (1)
    • March 2010 (13)
    • February 2010 (6)
    • January 2010 (3)
    • December 2009 (11)
    • November 2009 (10)
    • October 2009 (8)
    • September 2009 (11)
    • August 2009 (8)
    • July 2009 (12)
    • June 2009 (16)
    • May 2009 (11)
    • April 2009 (6)
    • March 2009 (6)
    • February 2009 (27)
    • January 2009 (11)
    • December 2008 (13)
    • November 2008 (17)
    • October 2008 (31)
    • September 2008 (60)
    • August 2008 (72)
    • July 2008 (56)
    • June 2008 (47)
    • May 2008 (38)
    • April 2008 (20)
    • March 2008 (8)
    • February 2008 (10)
    • January 2008 (17)
    • December 2007 (42)
    • November 2007 (29)
    • October 2007 (34)
    • September 2007 (31)
    • August 2007 (32)
    • July 2007 (33)
    • June 2007 (38)
    • May 2007 (34)
    • April 2007 (35)
    • March 2007 (35)
    • February 2007 (29)
    • January 2007 (29)
    • May 201 (1)

    Categories

    • SQL Query
    • Uncategorized

    Meta

    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org
    Asteroid Theme