Browse by Tags

• 70-089
• 70-236
• 70-293
• 70-294
• 70-298
• 70-299
• 70-400
• 70-401
• 70-402
• 70-403
• 70-431
• 70-432
• 70-536
• 70-620
• 70-622
• 70-624
• 70-630
• 70-631
• 70-635
• 70-640
• 70-642
• 70-643
• 70-646
• 70-647
• 70-649
• 70-652
• 70-658
• 70-669
• 70-671
• 70-672
• 70-673
• A+
• App-v
• Canada
• Code
• ConfigMGr
• CTE Solutions
• DevTeach
• DPM
• Drinks
• EnergizeIT
• Enhansoft
• exam
• Flowcharts
• Fun Links
• Hyper-v
• Joke
• MCSE
• MDT
• Med-V
• Microsoft
• Microsoft Canada
• MMS
• mobile
• MOM
• MS Support
• MSN
• MVP
• myITforum
• OpsMgr
• Ottawa
• Podcast
• Poll
• Q&A
• Rant
• Redgate
• RobertHalf
• Samsung
• SCCM
• SCE
• SCMDM
• SCSM
• SCVMM
• Sector
• self-study
• SMS
• SMS Installer
• SMSI
• SoftGrid
• SP2
• SQL
• Study group
• TechDays Canada
• Training
• UK
• User Groups
• Virtual Server
• Vista
• VMRCPlus
• vNext
• VS 2008
• Windows 2003
• Windows 2008
• Windows 7
• Windows XP
• WQL
• Zune

• Have you Voted?

  There is a poll on myITforum that talks about Certification and System Center. Basically what it wants to know is What SC certs do you hold and if you have any Windows 2008 MCITPs http://www.myitforum.com/absolutenm/templates/site.aspx?articleid=19149&zoneid... Posted Aug 04 2010, 05:24 PM by Garth with | with 1 comment(s) Filed under: System Center, Windows 2008, OpsMgr, 70-401, 70-400, SCVMM, exam, 70-403, DPM, SCCM, Microsoft, 70-658

• VM Heaven aka 24TB

  So, my test lab has been running lean and mean for a while. A few weeks back I decided that in order to test ConfigMgr v.Next. I needed to update my lab. In the past I had a few discussion about Hyper-v and getting more performance out of it.   The... Posted Jul 20 2010, 07:06 AM by Garth with | with 1 comment(s) Filed under: Virtual Server, System Center, ConfigMGr, self-study, Training, OpsMgr, SCVMM, Hyper-v, SCCM, vNext

• PCs without IE 8

  select Distinct     CS.Name0 from     dbo.v_GS_COMPUTER_SYSTEM CS     left outer join dbo.v_GS_SoftwareFile SF on CS.ResourceID = SF.ResourceID where     SF.ResourceID not in (select Distinct... Posted Jul 19 2010, 07:08 AM by Garth with | with 1 comment(s) Filed under: SQL, SMS, Code, System Center, ConfigMGr, vNext

• Range Like

  select * from dbo.v_GS_NETWORK_ADAPTER_CONFIGUR where IPAddress0 IS not NULL and IPAddress0 like '192.168.[1-9].%' Posted Jul 08 2010, 07:47 PM by Garth with | with 1 comment(s) Filed under: SQL, SMS, Code, System Center, ConfigMGr, SCCM, vNext

• SMSUG.ca Forums

  I have decided that the forums on www.SMSUG.ca are not being used and due to some SPAMMER populating the membership list, I have closed them down. This is a good thing as it means I will arrange for the site to be convert to a blog only site. With the... Posted Jul 01 2010, 08:44 AM by Garth with | with 1 comment(s) Filed under: SQL, SMS, Virtual Server, Joke, User Groups, Code, MOM, SoftGrid, System Center, MS Support, Fun Links, Canada, Study group, WQL, EnergizeIT , ConfigMGr, Flowcharts, 70-622, 70-293, self-study, MVP, VS 2008, Windows 2008, Podcast, Training, OpsMgr, 70-299, 70-640, 70-643, 70-642, 70-401, 70-400, UK, Ottawa, 70-620, 70-536, CTE Solutions, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, 70-624, Q&A, 70-298, A+, Windows 2003, 70-649, 70-646, 70-647, 70-431, TechDays Canada, Sector, MCSE, Hyper-v, MDT, 70-635, 70-671, 70-672, 70-673, Drinks, 70-631, 70-089, MMS, DPM, Enhansoft, Poll, RobertHalf, Microsoft Canada, DevTeach, Redgate, myITforum, Rant, 70-236, 70-630, VMRCPlus, Windows 7, MSN, SCCM, SP2, SMSI, SMS Installer, Microsoft, Zune, App-v, Med-V, 70-669, Windows XP, Samsung, mobile, 70-432, vNext

• How to connect to Windows Internal db using SQL Server Management Studio

  I was troubling shooting a WSUS issue and I need to connect to the db to edit some settings. This turns out to be harder than you think when you using Windows Internal db. So how do you connect to the db? Well this post will answer that for you. http... Posted Jun 26 2010, 09:34 AM by Garth with | with 1 comment(s) Filed under: SQL, System Center, ConfigMGr, vNext

• Remote Assistance and ConfigMgr

  Today I was trying to use the Remote Assistance from ConfigMgr, I keep getting a error message Your Offer to help could not be sent see screen shot below     Of course I did the normal troubleshooting stuff. ·        ... Posted Jun 26 2010, 08:52 AM by Garth with | with 12 comment(s) Filed under: System Center, ConfigMGr, Windows 2008

• List of Disabled Programs

  SELECT  [AdvertisementID]       ,[AdvertisementName] ,[ProgramFlags]       ,[PackageID]       ,[ProgramName]       ,[CollectionID]      ... Posted Jun 23 2010, 03:35 PM by Garth with | with 1 comment(s) Filed under: SQL, SMS, Code, System Center, ConfigMGr, vNext

• List of user with X

  Select distinct     TopConsoleUser0 from     dbo.v_Add_Remove_Programs ARP     Join dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on ARP.ResourceId = SCUM.ResourceID Where     ARP.DisplayName0... Posted Jun 21 2010, 05:17 PM by Garth with | with 1 comment(s) Filed under: SQL, SMS, Code, System Center, ConfigMGr, vNext

• List of Random PCs by Condition

  Here is a nice and simple way to get a list of Random PCs.   Create a query based on what you want to find, in my example Windows XP. Then add to the query a condition to find those with a “3” as the last character in the SMSID, Since the SMSID/GUID... Posted Jun 16 2010, 04:56 PM by Garth with | with 3 comment(s) Filed under: SMS, Code, System Center, WQL, ConfigMGr, vNext

• Vista without SP1 or SP2 (WQL)

  select     R.Name,     OS.Caption,     OS.CSDVersion from      SMS_R_System R     inner join SMS_G_System_OPERATING_SYSTEM OS on OS.ResourceID = R.ResourceId where    ... Posted Jun 13 2010, 09:55 AM by Garth with | with no comments Filed under: SMS, System Center, WQL, ConfigMGr, vNext

• Count of PCs by AD site

  SELECT     R.AD_Site_Name0,     Count(SMS_Installed_Sites0) AS 'Count' From     v_R_System R     JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceID WHERE    ... Posted Jun 07 2010, 05:19 PM by Garth with | with 1 comment(s) Filed under: SQL, Code, System Center, ConfigMGr

• List of PCs by AD site

  SELECT     R.Netbios_Name0,     R.User_Name0,     R.Operating_System_Name_and0,     R.AD_Site_Name0,     IP.IP_Addresses0 From     v_R_System R    ... Posted Jun 07 2010, 05:18 PM by Garth with | with 1 comment(s) Filed under: SQL, SMS, Code, System Center

• Free MS SQL 2008 administrator certification

  Now that I have your attention, every SMS / ConfigMgr administrator needs to know SQL in order to support SMS/ ConfigMgr. There are no “Ifs” “ands” or “buts” about it, without SQL, ConfigMgr / SMS could not run. You could not write reports or use SSRS... Posted May 18 2010, 07:23 AM by Garth with | with 2 comment(s) Filed under: SQL, SMS, User Groups, MOM, SoftGrid, System Center, Study group, ConfigMGr, self-study, Training, OpsMgr, exam, 70-431, MCSE, MDT, DPM, 70-432

• Added Collection

  Select Distinct     sys.Netbios_Name0,     fcm.SiteCode,      sys.User_Domain0,     sys.User_Name0,     sys.Operating_System_Name_and0,     arp.DisplayName0... Posted Mar 19 2010, 07:03 AM by Garth with | with no comments Filed under: SQL, SMS, Code, System Center, ConfigMGr, SCCM