sccmug

Canadian SCCM User Group

Total of space used by all Page files.

October 26, 2007
Posted by Garth Jones

Select Sum(RAM.TotalPageFileSpace0)
From v_GS_X86_PC_MEMORY RAM

Updated: February 25, 2016 at 10:52 am
Tags: Code, ConfigMGr, SMS, SQL, System Center
◀ List all Printers that handle B4 (JIS) paper
List all Local Color Printers ▶

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
  • Limiting a report to a Collection
  • Count of PC within each OU
  • Find all PC with HW and SW inventory dates greater than 180 days
  • Finding all PCs with MS Access using ARP data

Recent Comments

    Archives

    • December 2017 (1)
    • January 2014 (1)
    • September 2013 (1)
    • August 2013 (1)
    • July 2013 (3)
    • June 2013 (1)
    • April 2013 (1)
    • March 2013 (1)
    • February 2013 (1)
    • January 2013 (2)
    • December 2012 (3)
    • November 2012 (1)
    • 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