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

Browse by Tags

  • 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
  • Link to Name

    For full details see post here.   select ARP.resourceid, CS.Name0, max (ARP.version0) as JavaVersion from dbo.v_GS_COMPUTER_SYSTEM as CS join dbo.v_ADD_REMOVE_PROGRAMS as ARP on CS.ResourceID = ARP.ResourceID where ARP...
    Posted to Garth Jones (Weblog) by Garth on 03-11-2012
  • Cannot get rid of duplicate rows on an Add or Remove Programs query

    For for details see post. Select DISTINCT SYS.Netbios_Name0 AS ' Name ', case SEM.ResourceID When NULL THEN ' N ' Else ' Y ' End AS ' SafeNet? ', ARP. Timestamp...
    Posted to Garth Jones (Weblog) by Garth on 03-04-2012
  • Custom ChassisType Report - wrong counts

    See the full details within the forum declare @Manufacturer0 as varchar (250) set @Manufacturer0 = ' All ' declare @Version0 as varchar (250) set @Version0 = ' All ' declare...
    Posted to Garth Jones (Weblog) by Garth on 03-04-2012
  • Software Metering Test query

    select CS.Name0, MRIB.ProductName, MD.* from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_MeterData MD on CS.ResourceID = MD.ResourceID join dbo.v_MeterRuleInstallBase MRIB on MD.FileID = MRIB.MeteredFileID where MD.starttime > ' 2012-02-16 '
    Posted to Garth Jones (Weblog) by Garth on 03-02-2012
  • Tips and Tricks for SSRS

    I want to let everyone know that I will be giving a webcast on SSRS Report Writing for CM07/CM12 on Wednesday, March 14, 2012, at  11:00 a.m. to 12:30 pm PST.    Episode 9: Garth Jones A Deep Dive into SCCM Data! Bring Your Snorkel!   In this session, I will dive deep into the depths...
    Posted to Garth Jones (Weblog) by Garth on 02-24-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
  • MyITforum donation for 2012

    With the start of a new year, it is that time again to support the System Center Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF).   MIF is truly a community that helps each other both professionally and...
    Posted to Garth Jones (Weblog) by Garth on 01-02-2012
  • Query on Prohibited application for specific OU

    Select distinct ou.system_ou_name0, sys.Netbios_Name0, fcm.SiteCode,sys.User_Domain0, sys.User_Name0, -- DATEADD(mi,(usr.lastLogontimeStamp0 / 600000000) - 157258080,0) AS [Last Logon Time Stamp (UTC)], usr.company0, sys.Operating_System_Name_and0, Displayname0, Version0, InstallDate0 FROM dbo.v_R_System...
    Posted to Garth Jones (Weblog) by Garth on 11-28-2011
  • Show list of computers whithout more than 30 criticals patches not installed

    select v_R_System.Name0 as ' Computername ', Count (v_StateNames.Statename) as ' Required Updates ' from v_StateNames, v_Update_ComplianceStatusAll Inner Join v_R_System On (v_R_System.ResourceID = v_Update_ComplianceStatusAll.ResourceID) Inner Join v_UpdateInfo On (v_UpdateInfo.CI_ID...
    Posted to Garth Jones (Weblog) by Garth on 11-27-2011
Page 3 of 7 (63 items) < Previous 1 2 3 4 5 Next > ... Last »
©2010 Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems