in

SMSUG.ca

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

Browse by Tags

  • SCCM 2012 Table has multiple records for Server IP

    For full details see http://social.technet.microsoft.com/Forums/en-US/configmanagergeneral/thread/43686ca9-3064-4533-8f94-f28c889b4511/   HS view are for History data, not current data. RA views are discovery data views. vSMS are “extra” views.. I don’t generally use them.   It is generally...
    Posted to Garth Jones (Weblog) by Garth on 10-23-2012
  • PC by Gateway

      select CS.Name0, CS.UserName0, NA.Description0, NAC.IPAddress0, NAC.MACAddress0, NAC.DefaultIPGateway0 From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on NAC.ResourceID = CS.ResourceID join dbo.v_GS_NETWORK_ADAPTER NA on NA.ResourceID = CS.ResourceID and NAC.ServiceName0...
    Posted to Garth Jones (Weblog) by Garth on 10-18-2012
  • Software by OU

    SELECT ARP.DisplayName0, Count (*) AS 'Count' , ARP.Publisher0, ARP.Version0 FROM dbo.v_Add_Remove_Programs ARP join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = ARP.ResourceID WHERE OU.System_OU_Name0 = @OU GROUP BY ARP.DisplayName0, ARP.Publisher0, ARP.Version0 ORDER BY ARP.Publisher0...
    Posted to Garth Jones (Weblog) by Garth on 10-18-2012
  • List of PC by Excel versions

    For full detail see forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/66b71887-acc7-40ac-8634-536784fa5adf SELECT DISTINCT R.Name0 AS 'Machine Name' , left (SF.FileVersion,2) FROM dbo.v_R_System R INNER JOIN dbo.v_GS_SoftwareFile SF ON R.ResourceID = SF.ResourceID...
    Posted to Garth Jones (Weblog) by Garth on 10-07-2012
  • Four reports to answer questions within the reporting forums

    So I have been running with my head cut of these days but I always like to make sure that the Reporting forum questions are answer... http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/threads   For more detail about each of the post see: http://social.technet.microsoft.com/Forums...
    Posted to Garth Jones (Weblog) by Garth on 09-18-2012
  • Count of Manufacturers

    For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/4e4019b0-a28e-4637-ae8c-4ff523d11c1a select top 3 Manufacturer0, Count (*) from dbo.v_GS_COMPUTER_SYSTEM GROUP BY Manufacturer0 Order by 2 desc
    Posted to Garth Jones (Weblog) by Garth on 07-08-2012
  • How to find an application installed in the last 7 days

    For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/38f96191-6e3e-4150-8f3a-18b1c4db8d7d SELECT R.Netbios_name0, R.AD_Site_Name0, ARP.DisplayName0, ARP.InstallDate0, DATEDIFF( Day , CONVERT ( Datetime ,ARP.InstallDate0), GETDATE()) AS [days since installed...
    Posted to Garth Jones (Weblog) by Garth on 07-02-2012
  • List of PCs with Project, Visio or Visual

    For full details, please see this forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/50b2b524-3c11-41c5-a2d5-b8ae979ee3c2/ Select sys.Netbios_Name0, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0, ARP.Version0 FROM v_R_System sys...
    Posted to Garth Jones (Weblog) by Garth on 06-01-2012
  • Find Programs Removed from a PC (updated)

    For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/db96da44-a9e0-4996-bca2-286b6e2c473a SELECT DISTINCT CS.Name0, HARP.Publisher0 AS ' Publisher ', HARP.ProdID0 AS ' Product ', HARP.DisplayName0 AS ' Name ' FROM dbo.v_GS_COMPUTER_SYSTEM...
    Posted to Garth Jones (Weblog) by Garth on 05-21-2012
  • List of PC with Project and Subnet

    For full details, see posts: http://www.myitforum.com/forums/SCCM-report-m235714.aspx http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/07158c51-06e1-4afb-8a46-187eaf8e82eb   select Distinct CS.Name0 from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_Add_Remove_Programs ARP on CS...
    Posted to Garth Jones (Weblog) by Garth on 05-03-2012
Page 4 of 40 (398 items) « First ... < Previous 2 3 4 5 6 Next > ... Last »
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems