Garth Jones at myITforum.com : Code, SMS

Video card with Sound card.

Garth Jones — Thu, 18 Apr 2013 18:50:48 GMT

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...(read more)

Video Card Details v2

Garth Jones — Thu, 18 Apr 2013 13:28:44 GMT

Find all webcam - SQL

Garth Jones — Tue, 02 Apr 2013 12:26:07 GMT

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)

Find all webcam – WQL

Garth Jones — Tue, 02 Apr 2013 12:24:07 GMT

Use this WQL query to find all webcam http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/fa5fcfe2-69ef-4482-adfc-de25d6d19669/?prof=required select SMS_R_System.Name, SMS_G_System_SYSTEM_DEVICES.Name, SMS_G_System_SYSTEM_DEVICES.DeviceID...(read more)

How to find PCs within an AD container

Garth Jones — Sat, 16 Mar 2013 13:02:12 GMT

If you need to find all PC within an AD container (not an OU). Use this WQL query to find them. For more details about this request, see the full forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/9358cee7-75a5-4595-80a3...(read more)

CM12 Collection prompt example

Garth Jones — Fri, 15 Mar 2013 20:20:06 GMT

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...(read more)

MAC Address report

Garth Jones — Thu, 28 Feb 2013 16:17:37 GMT

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...(read more)

Adding total HDD and RAM size Part 2

Garth Jones — Mon, 11 Feb 2013 13:41:36 GMT

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'...(read more)

Adding Ram and HD

Garth Jones — Fri, 08 Feb 2013 22:32:33 GMT

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'...(read more)

Microsoft True Up Report

Garth Jones — Thu, 07 Feb 2013 13:24:33 GMT

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...(read more)

List Collection Membership

Garth Jones — Tue, 22 Jan 2013 13:18:09 GMT

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 ...(read more)

WMI query for C: with more than 1GB of HD space.

Garth Jones — Fri, 11 Jan 2013 13:39:36 GMT

For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/fde395bb-a4b6-4347-b1b6-8c180c3f7f46 This is a WMI WQL query and NOT and native CM07 / CM12 WQL query. select Size from Win32_LogicalDisk Where...(read more)

Finding all PCs without Symantec AV installed

Garth Jones — Sun, 06 Jan 2013 17:04:45 GMT

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...(read more)

List new CM clients within the last 14 days.

Garth Jones — Mon, 31 Dec 2012 17:01:25 GMT

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...(read more)

How to find all workstations with SNMP.

Garth Jones — Sat, 29 Dec 2012 16:39:44 GMT

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...(read more)