in

SMSUG.ca

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

Browse by Tags

  • 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
  • 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
  • Finding Adobe X for both x68 and x64

    For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/66c80e66-9760-49b3-b429-08bf2ca8f572 http://social.technet.microsoft.com/Forums/en-US/configmanagerapps/thread/b68ce42c-98f5-4500-bced-0e8e901cb211/ select distinct SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType...
    Posted to Garth Jones (Weblog) by Garth on 07-02-2012
  • Query on user history

    For full details please see http://www.myitforum.com/Forums/tm.aspx?m=230539&high = SELECT DISTINCT R.Netbios_Name0, tu.SystemConsoleUser0, tu.logontime FROM dbo.v_R_System R join ( SELECT husr.ResourceID, Husr.SystemConsoleUser0, max (Husr.LastConsoleUse0) as logontime FROM dbo.v_HS_SYSTEM_CONSOLE_USER...
    Posted to Garth Jones (Weblog) by Garth on 07-01-2012
  • Query for computers with single partition

    For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/4d84e5f9-fd48-4fcb-b490-d0a64052aa08 select SMS_R_System.Name from SMS_R_System where SMS_R_System.ResourceId not in ( select SMS_G_System_PARTITION.ResourceId from SMS_G_System_PARTITION where SMS_G_System_PARTITION...
    Posted to Garth Jones (Weblog) by Garth on 06-09-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
  • How to exclude a collection from sccm collection query

    For full details, see this forums post. http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/75288b97-1fe6-4634-a20a-54091bba8d91   select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup...
    Posted to Garth Jones (Weblog) by Garth on 05-19-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
  • MMS 2012

    Well MMS 2012 is over and it has been crazy for me. Here is the summary of what happened:   My passport expired so had to get a new one, I picked it up on Thursday just before I left for Vegas I know my luggage would be close to being overweight, so I didn’t bring a few things like shaving cream...
    Posted to Garth Jones (Weblog) by Garth on 04-30-2012
Page 5 of 15 (148 items) « First ... < Previous 3 4 5 6 7 Next > ... Last »
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems