in

SMSUG.ca

...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! http://bit.ly/yMimvp   oh, you want...
    Posted to Garth Jones (Weblog) by Garth on 03-11-2012
  • Link to Name

    For full details see post here. http://www.myitforum.com/forums/tm.aspx?high=&m=234875&mpage=1#234894   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. http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/3bea8fa6-968a-4f0e-b412-469577e409aa 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 http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/d8477233-4b10-4a6d-a5ea-de73abc9b815/ 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. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/7f48aa48-d260-4ad1-babc-8b2496d103fb 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). http://myitforum.com/myitforumwp/aboutus/donations/   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 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems