Garth Jones at myITforum.com
What is on his mind, aka Does he have a mind?
Browse by Tags
All Tags
»
SQL
»
Code
(
RSS
)
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-669
70-671
70-672
70-673
A+
App-v
Boot Image
Canada
CM07
CM12
ConfigMGr
CTE Solutions
DevTeach
DPM
Drinks
Drivers
EnergizeIT
Enhansoft
exam
Flowcharts
Fun Links
Hyper-v
Joke
MCSE
MDT
Med-V
Microsoft
MMS
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
ssrs
Study group
SU
System Center
TechDays Canada
Training
UK
URL
User Groups
Virtual Server
Vista
VMRCPlus
vNext
VS 2008
Windows 2003
Windows 2008
Windows 7
Windows XP
WQL
Zune
Video card with Sound card.
Thursday, April 18, 2013 2:50 PM
For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name' , R.User_Name0 as 'User' , CS.Manufacturer0 as 'Manufacturer' , CS.Model0 as 'Model' , BIOS.SerialNumber0 as 'Serial' , SD.Name0 as...
Read More...
Video Card Details v2
Thursday, April 18, 2013 9:28 AM
For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name' , R.User_Name0 as 'User' , CS.Manufacturer0 as 'Manufacturer' , CS.Model0 as 'Model' , BIOS.SerialNumber0 as 'Serial' , SD.Name0 as 'Processor'...
Read More...
Video Card details
Monday, April 15, 2013 7:36 AM
For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name' , R.User_Name0 as 'User' , CS.Manufacturer0 as 'Manufacturer' , CS.Model0 as 'Model' , BIOS.SerialNumber0 as 'Serial' , SD.Name0 as 'Processor'...
Read More...
Find all webcam - SQL
Tuesday, April 02, 2013 8:26 AM
Use this query to find all webcam – SQL reports select CS.Name0, SD.Name0, SD.DeviceID0 from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_SYSTEM_DEVICES SD on CS.ResourceID = SD.ResourceID Where SD.Name0 like '%Webcam%'
Read More...
CM12 Collection prompt example
Friday, March 15, 2013 4:20 PM
For full details see: http://www.myitforum.com/forums/tm.aspx?high=&m=238953&mpage=1#239186 SELECT distinct sys1.Name0, csys.Model0, csys.Manufacturer0, os.Caption0, os.CSDVersion0, BIOS.SerialNumber0, sys1.description0, REPLACE(( SELECT IPAddress0 + ', ' FROM v_GS_NETWORK_ADAPTER_CONFIGUR WHERE resourceID = sys1.resourceID AND ipenabled0 = 1...
Read More...
MAC Address report
Thursday, February 28, 2013 11:17 AM
For full details please see: http://social.technet.microsoft.com/Forums/en-ca/configmgrreporting/thread/19e0771c-eddc-43f7-956c-a5c9f0110e59 SELECT A.Name0, B.SerialNumber0 , A.Manufacturer0, A.Model0, C.Name0 , D.TotalPhysicalMemory0 , ...
Read More...
Adding total HDD and RAM size Part 2
Monday, February 11, 2013 8:41 AM
For full details, please see http://social.technet.microsoft.com/Forums/en-ca/configmgrai/thread/7951b781-8354-490b-9b59-4fe4e68d1975 SELECT DISTINCT CS.Name0, CASE WHEN ES.ChassisTypes0 in ( '3' , '4' , '6' , '7' , '15' ) THEN 'Desktop' WHEN ES.ChassisTypes0 in ( '8' , '9' , '10' , '21'...
Read More...
Adding Ram and HD
Friday, February 08, 2013 5:32 PM
SELECT DISTINCT CS.Name0, CASE WHEN ES.ChassisTypes0 in ( '3' , '4' , '6' , '7' , '15' ) THEN 'Desktop' WHEN ES.ChassisTypes0 in ( '8' , '9' , '10' , '21' ) THEN 'Laptop' Else 'Unknown' END as 'Chassis' , BIOS.SerialNumber0, CS.Manufacturer0, CS.Model0...
Read More...
Microsoft True Up Report
Thursday, February 07, 2013 8:24 AM
For full details please see http://www.myitforum.com/Forums/tm.aspx?m=238674&high = SELECT distinct DisplayName0, Count (arp.ResourceID) AS 'Count' , Publisher0, @CollID as CollectionID FROM dbo.v_Add_Remove_Programs arp JOIN dbo.v_FullCollectionMembership fcm on arp.ResourceID = fcm.ResourceID WHERE fcm.CollectionID = @CollID AND (Publisher0...
Read More...
List Collection Membership
Tuesday, January 22, 2013 8:18 AM
For full details, please see http://www.windows-noob.com/forums/index.php?/topic/7308-collection-membership/#entry27677 select C.Name from dbo.v_FullCollectionMembership FCM join dbo.v_Collection C on C.CollectionID = FCM.CollectionID Where FCM.Name = 'Gartek-DC'
Read More...
PC Serial Number by OU.
Wednesday, January 16, 2013 9:37 PM
For full details, please see http://www.myitforum.com/forums/Active-Directory-Discovery-additional-Attributes-and-broken-reports-and-queries-m238462.aspx select distinct R.ResourceID, R.Name0, R.Client0, BIOS.SerialNumber0 from dbo.v_R_System AS R LEFT OUTER JOIN dbo.v_RA_System_SystemOUName AS OU ON R.ResourceID = OU.ResourceID INNER JOIN dbo.v_GS_PC_BIOS AS...
Read More...
Finding all PCs without Symantec AV installed
Sunday, January 06, 2013 12:04 PM
For Full detail see http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/547016e0-9f15-4611-aac9-24f582aa0614 select R.netbios_name0, R.user_name0, OS.Caption0 AS 'Operating System' , ES.SerialNumber0 AS 'Serial Number' from dbo.v_R_System R join dbo.v_GS_OPERATING_SYSTEM OS on OS.ResourceID = R.ResourceID JOIN...
Read More...
List new CM clients within the last 14 days.
Monday, December 31, 2012 12:01 PM
For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/2f072158-88c2-48e9-8125-2e137494fbeb select Creation_Date0, Name0, User_Name0 from dbo.v_R_System where datediff(dd,Creation_Date0, getdate()) < 14 and Client0 = 1
Read More...
How to find all workstations with SNMP.
Saturday, December 29, 2012 11:39 AM
For full detail please see, http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/2eb10f29-0927-4b43-a4a4-0c712793673f Select CS.Name0 as 'PC Name' , OS.Caption0 as 'OS' , OS.CSDVersion0 as 'SP' From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_SERVICE S on CS.ResourceID = S.ResourceID join dbo.v_GS_SYSTEM SYS on CS.ResourceID...
Read More...
File not in a list
Friday, December 28, 2012 1:57 PM
For full detail , please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/688bff46-a0ed-44cb-84c2-df036fe40e84 select SF.* from dbo.v_GS_SoftwareFile SF Where FileName not in ( 'sol.exe' , 'freecell.exe' ) and FileName like '%.exe'
Read More...
More Posts
Next page »
Go
This Blog
Home
Contact
Links
About
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-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
Ottawa Windows Server User Group
Podcast
Poll
Q&A
Q&A
Rant
Redgate
RobertHalf
SCCM
SCE
SCMDM
SCSM
SCVMM
Sector
self-study
SMS
SMS Installer
SMSI
SoftGrid
SP2
SQL
ssrs
Study group
System Center
TechDays Canada
Training
UK
User group
User Groups
Virtual Server
Vista
vNext
VS 2008
Windows 2003
Windows 2008
Windows 7
WQL
Zune
Navigation
Site Home
Home
Bloggers List
Forums
Blogs
Photos
Downloads
Donate
Archives
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 (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 (8)
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 (40)
November 2007 (30)
October 2007 (35)
September 2007 (30)
August 2007 (31)
July 2007 (32)
June 2007 (38)
May 2007 (34)
April 2007 (34)
March 2007 (33)
February 2007 (28)
January 2007 (29)
November 2006 (5)
October 2006 (5)
May 2006 (5)
April 2006 (3)
March 2006 (7)
February 2006 (4)
January 2006 (8)
December 2005 (2)
November 2005 (1)
October 2005 (5)
September 2005 (6)
August 2005 (9)
April 2005 (1)
March 2005 (1)
February 2005 (2)
January 2005 (10)
December 2004 (26)
Syndication
RSS
Atom
Comments RSS