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

Browse by Tags

  • SCCM 2012 Table has multiple records for Server IP

    For full details see   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. 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...   For more detail about each of the post see:
    Posted to Garth Jones (Weblog) by Garth on 09-18-2012
  • Count of Manufacturers

    For full details see: 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 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. 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: 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:   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 Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems