in

SMSUG.ca

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

Browse by Tags

  • Last Logon User

    For full details see: http://www.windows-noob.com/forums/index.php?/topic/7022-last-logged-user/   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. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/32c4db2f-ae84-4fed-93c1-c3f35f8a6fff     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: http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/107d690a-4bbd-49c4-87bf-389278525b63     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 http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/6c00b44f-1b92-4c1b-924e-fd79c191d5e9 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 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
  • 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: 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
Page 4 of 41 (402 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