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

Browse by Tags

  • Last Logon User

    For full details see:   Select R.Netbios_Name0, R.User_Domain0 + '\' + R.User_Name0, CS.UserName0 from dbo.v_R_System R join dbo.v_GS_COMPUTER_SYSTEM CS on R.ResourceID = CS.ResourceID join dbo.v_FullCollectionMembership...
    Posted to Garth Jones (Weblog) by Garth on 12-07-2012
  • Count of how often clients report HW inventory

    For full detail see.     I liked this request, I might ever try to make an NICE SSRS report out of this one. But not for a few weeks, so here you go.   select CS.Name0 as 'PC'...
    Posted to Garth Jones (Weblog) by Garth on 12-05-2012
  • Asset Information with User Full name

    For full details please see:     select distinct R.ResourceID, R.User_Name0, R.Netbios_Name0 AS 'Computer_Name' , R.Resource_Domain_OR_Workgr0 AS 'Domain_workgroup' , S.SiteName...
    Posted to Garth Jones (Weblog) by Garth on 11-21-2012
  • PC with MAC Address

    For full details see Select R.Netbios_Name0, MAC.MAC_Addresses0 from dbo.v_R_System R join dbo.v_RA_System_MACAddresses MAC ON R.ResourceID = MAC.ResourceID Where MAC.MAC_Addresses0 in ( SELECT...
    Posted to Garth Jones (Weblog) by Garth on 11-17-2012
  • 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
  • IE7 Collection

    For full detail please see forum post   select * from SMS_R_System left join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceId = SMS_R_System.ResourceId...
    Posted to Garth Jones (Weblog) by Garth on 10-08-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
Page 4 of 41 (402 items) « First ... < Previous 2 3 4 5 6 Next > ... Last »
©2010 Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems