in

SMSUG.ca

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

Browse by Tags

  • 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
  • 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
  • PC Serial Number by OU.

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