in

SMSUG.ca

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

Browse by Tags

  • Find PC by Last logon user โ€“ prompted

    Use this query if you want to locate PCs by that last logon user but prompt for the user name each time. select SMS_R_System.Name from SMS_R_System where SMS_R_System.LastLogonUserName = ##PRM:SMS_R_System.LastLogonUserName## order by SMS_R_System.Name
    Posted to Garth Jones (Weblog) by Garth on 06-29-2013
  • Video card with Sound card.

    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'...
    Posted to Garth Jones (Weblog) by Garth on 04-18-2013
  • Video Card Details v2

    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' ,...
    Posted to Garth Jones (Weblog) by Garth on 04-18-2013
  • Video Card details

    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' ,...
    Posted to Garth Jones (Weblog) by Garth on 04-15-2013
  • Find all webcam - SQL

    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%'
    Posted to Garth Jones (Weblog) by Garth on 04-02-2013
  • 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
Page 2 of 6 (51 items) < Previous 1 2 3 4 5 Next > ... Last ยป
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems