SMSUG.ca
...your virtual communITy
Welcome to SMSUG.ca
Sign in
|
Join
|
Help
in
Garth Jones
SMSUG
(Entire Site)
Search
Home
Blogs
Calendar
Garth Jones
RAM by User name
SELECT
Distinct
SYS.Netbios_Name0
,
SYS.Operating_System_Name_and0
,
MEM
.
TotalPhysicalMemory0
/
1024
As
C083
FROM
v_R_System SYS
JOIN
v_GS_X86_PC_MEMORY MEM
on
SYS.ResourceID
=
MEM
.
ResourceID
WHERE
User_Name0
=
'Garth'
Published
Aug 06 2011, 01:00 PM
by
Garth
Filed under:
SQL
,
SMS
,
Code
,
System Center
,
ConfigMGr
,
SCCM
,
vNext
Comments
No Comments
This Blog
Home
About
Syndication
RSS
Atom
Comments RSS
Recent Posts
Find Programs Removed from a PC (updated)
How to exclude a collection from sccm collection query
70-243
LOL OOO message
Adobe Dashboard
Tags
70-089
70-236
70-293
70-294
70-298
70-299
70-400
70-401
70-402
70-403
70-431
70-432
70-536
70-620
70-622
70-624
70-630
70-631
70-635
70-640
70-642
70-643
70-646
70-647
70-649
70-652
70-659
70-669
70-671
70-672
70-673
A+
App-v
Canada
CM07
CM12
Code
ConfigMGr
CTE Solutions
DevTeach
DPM
Drinks
EnergizeIT
Enhansoft
exam
Flowcharts
Fun Links
Hyper-v
Joke
MCSE
MDT
Med-V
Microsoft
Microsoft Canada
MMS
mobile
MOM
MS Support
MSN
MVP
myITforum
OpsMgr
Ottawa
Podcast
Poll
Q&A
Rant
Redgate
RobertHalf
Samsung
SCCM
SCE
SCMDM
SCSM
SCVMM
Sector
self-study
SMS
SMS Installer
SMSI
SoftGrid
SP2
SQL
Study group
System Center
TechDays Canada
Training
UK
User Groups
Virtual Server
Vista
VMRCPlus
vNext
VS 2008
Windows 2003
Windows 2008
Windows 7
Windows XP
WQL
Zune
News
User Groups
Ottawa Windows Server User Group
myITforum
FAQ shop
SMS Add-ons
Enhansoft
SMS Expert
myITForum
Training
CTE Solutions
Archives
May 2012
(6)
April 2012
(3)
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
(3)
April 2011
(3)
March 2011
(7)
February 2011
(7)
January 2011
(8)
December 2010
(3)
November 2010
(5)
October 2010
(7)
September 2010
(6)
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
(11)
June 2009
(13)
May 2009
(15)
April 2009
(6)
March 2009
(7)
February 2009
(26)
January 2009
(11)
December 2008
(13)
November 2008
(15)
October 2008
(31)
September 2008
(59)
August 2008
(72)
July 2008
(57)
June 2008
(46)
May 2008
(39)
April 2008
(20)
March 2008
(8)
February 2008
(10)
January 2008
(16)
December 2007
(41)
November 2007
(30)
October 2007
(34)
September 2007
(30)
August 2007
(33)
July 2007
(34)
June 2007
(38)
May 2007
(36)
April 2007
(35)
March 2007
(34)
February 2007
(29)
January 2007
(30)
©2010 SMSUG.ca
Privacy Statement