in

SMSUG.ca

...your virtual communITy
All Tags » SMS (RSS)

Browse by Tags

  • Find all webcam – WQL

    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...
    Posted to Garth Jones (Weblog) by Garth on 04-02-2013
  • How to find PCs within an AD container

    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...
    Posted to Garth Jones (Weblog) by Garth on 03-16-2013
  • CM12 Collection prompt example

    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...
    Posted to Garth Jones (Weblog) by Garth on 03-15-2013
  • MAC Address report

    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,    ...
    Posted to Garth Jones (Weblog) by Garth on 02-28-2013
  • Adding total HDD and RAM size Part 2

    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...
    Posted to Garth Jones (Weblog) by Garth on 02-11-2013
  • Adding Ram and HD

      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'...
    Posted to Garth Jones (Weblog) by Garth on 02-08-2013
  • Microsoft True Up Report

    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...
    Posted to Garth Jones (Weblog) by Garth on 02-07-2013
  • List Collection Membership

    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'
    Posted to Garth Jones (Weblog) by Garth on 01-22-2013
  • WMI query for C: with more than 1GB of HD space.

    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
    Posted to Garth Jones (Weblog) by Garth on 01-11-2013
  • Finding all PCs without Symantec AV installed

    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...
    Posted to Garth Jones (Weblog) by Garth on 01-06-2013
Page 2 of 48 (479 items) < Previous 1 2 3 4 5 Next > ... Last »
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems