Browse by Tags

All Tags » CM12 » System Center (RSS)
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...
by Garth Jones
Filed under: , , , , , , , ,
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...
by Garth Jones
Filed under: , , , , , , , ,
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...
by Garth Jones
Filed under: , , , , , , ,
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...
by Garth Jones
Filed under: , , , , , , ,
Find all webcam – WQL
Tuesday, April 02, 2013 8:24 AM
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 from SMS_R_System inner join SMS_G_System_SYSTEM_DEVICES on SMS_G_System_SYSTEM_DEVICES.ResourceID = SMS_R_System... Read More...
by Garth Jones
Filed under: , , , , , ,
How to find PCs within an AD container
Saturday, March 16, 2013 9:02 AM
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-4016ea572f1b   select SMS_R_System.Name, SMS_R_System.LastLogonUserName from SMS_R_System where SMS_R_System... Read More...
by Garth Jones
Filed under: , , , , , , ,
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...
by Garth Jones
Filed under: , , , , , ,
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...
by Garth Jones
Filed under: , , , , , , ,
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...
by Garth Jones
Filed under: , , , , , , ,
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...
by Garth Jones
Filed under: , , , , , , ,
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...
by Garth Jones
Filed under: , , , , , , , ,
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...
by Garth Jones
Filed under: , , , , , , ,
WMI query for C: with more than 1GB of HD space.
Friday, January 11, 2013 8:39 AM
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 DeviceId="C:" and size > 1073741824 Read More...
by Garth Jones
Filed under: , , , , , , ,
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...
by Garth Jones
Filed under: , , , , , , , ,
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...
by Garth Jones
Filed under: , , , , , , , ,
More Posts Next page »
Go

This Blog

Syndication