in

SMSUG.ca

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

Browse by Tags

  • Count of PCs by OU v2

      For more details please see: http://social.technet.microsoft.com/Forums/systemcenter/en-US/aea60e7b-a88b-48d8-8cc3-8675097abe62/trying-to-do-a-report-of-sup-failures-by-ou?forum=configmgrinventory   SELECT OU.ou, COUNT (*) AS 'COUNT' FROM dbo.v_R_System SYS join ( select SOU.ResourceID...
    Posted to Garth Jones (Weblog) by Garth on 03-19-2014
  • Count of PCs by OU

    Please see post http://social.technet.microsoft.com/Forums/systemcenter/en-US/aea60e7b-a88b-48d8-8cc3-8675097abe62/trying-to-do-a-report-of-sup-failures-by-ou?forum=configmgrinventory for full details SELECT Max (SOU.System_OU_Name0), COUNT (*) AS 'COUNT' FROM dbo.v_RA_System_SystemOUName SOU...
    Posted to Garth Jones (Weblog) by Garth on 03-19-2014
  • PCs with Either of two applications installed.

    Use this query to determine if a PC has either or both applications installed. For more details, please see http://social.technet.microsoft.com/Forums/systemcenter/en-US/6c4650c7-3246-4e13-a78d-05691c13c89d/duplicate-rows-when-finding-pcs-with-installed-software?forum=configmgrreporting   SELECT...
    Posted to Garth Jones (Weblog) by Garth on 01-24-2014
  • Limiting a report to a Collection

    For more details please see http://www.windows-noob.com/forums/index.php?/topic/9766-sccm-report-on-collection/     SELECT DISTINCT CS.Name0, R.User_Name0, MAX (SOU.System_OU_Name0) AS Expr1, CS.Description0, CS.Manufacturer0, CS.Model0, BIOS.SerialNumber0 FROM dbo.v_Collection Coll join dbo...
    Posted to Garth Jones (Weblog) by Garth on 01-13-2014
  • Joining Users to a PC

    Use this query to join Users to PCs Select R.Name0, U.User_Name0, U.Full_User_Name0, U.Unique_User_Name0, U.Mail0 From dbo.v_R_System R INNER JOIN dbo.v_R_User U ON U.Unique_User_Name0 = R.User_Domain0 + '\' + R.User_Name0 .csharpcode, .csharpcode pre { font-size: small; color: black; font-family...
    Posted to Garth Jones (Weblog) by Garth on 07-06-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
  • 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
  • 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
Page 1 of 35 (348 items) 1 2 3 4 5 Next > ... Last »
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems