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

Browse by Tags

  • How to find all workstations with SNMP.

    For full detail please see, Select CS.Name0 as 'PC Name' , OS.Caption0 as 'OS' , OS.CSDVersion0 as 'SP' From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_SERVICE S on CS...
    Posted to Garth Jones (Weblog) by Garth on 12-29-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
  • 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
  • Finding Adobe X for both x68 and x64

    For full details see 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 = 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
  • 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
  • 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
  • Last Reboot Report

    For full details see:   select distinct R.ResourceID, R.Netbios_Name0 AS ' Computer Name ', OS.LastBootUpTime0 AS ' Last Boot Time ', R.Resource_Domain_OR_Workgr0 AS '...
    Posted to Garth Jones (Weblog) by Garth on 03-18-2012
  • Lists people and how much they've been using specified software with OU fix

    For full details see: select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', ou.ou as OU, round( sum (MUS.UsageTime)/60.0,2) as ' Forbrug (min) ' from dbo...
    Posted to Garth Jones (Weblog) by Garth on 03-16-2012
Page 1 of 5 (49 items) 1 2 3 4 5 Next >
©2010 Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems