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

Browse by Tags

  • 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
  • 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
  • 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
  • Total SQL Server Systems Query

    See forum post for full details:   SELECT DISTINCT R.Name0, R.User_Name0, ARP.DisplayName0 AS [Software Name], ARP.Version0 AS [Installed Version], IP.IP_Addresses0 AS IPAddress, -- ARP...
    Posted to Garth Jones (Weblog) by Garth on 03-12-2012
  • BIG NEWS!!!!

    I have big news but there is a catch….. I can’t say much until Wednesday at noon PST! J Which works out perfectly, as that is almost the exact time that I will be finishing my SCCM Guru webcast! So make sure that your register for the session to hear it Live!   oh, you want...
    Posted to Garth Jones (Weblog) by Garth on 03-11-2012
  • AD discovery and add the following attributes (givenname, sn, mail & ou) report

    For full details see. I fix the query to make it work, change OS to a readable name, formatting etc.. SELECT R.Name0 as ' Host Name ', CS.Model0 as ' model ', BIOS.SerialNumber0...
    Posted to Garth Jones (Weblog) by Garth on 02-14-2012
  • PC not logon for 14 days.

    For full details see.   select CS.Name0, LCU. date From dbo.v_GS_COMPUTER_SYSTEM CS join ( Select ResourceID, max (LastConsoleUse0) as ' date ' from dbo.v_GS_SYSTEM_CONSOLE_USER SCU...
    Posted to Garth Jones (Weblog) by Garth on 02-06-2012
Page 5 of 6 (51 items) « First ... < Previous 2 3 4 5 6 Next >
©2010 Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems