SMSUG.ca

select * from dbo.v_GS_COMPUTER_SYSTEM where name0 like '___m%'

Do you want a free copy of Windows 7? if so check out this post! http://www.myitforum.com/forums/m_215495/mpage_1/key_/tm.htm#215495

The ConfigMgr / SCCM documentation script has been updated to v1.24 for more details please see http://tinyurl.com/yfpgocw

select     DisplayName0,     Version0,     Count(*) From     dbo.v_Add_Remove_Programs ARP Where     DisplayName0 like '%office%' Group by     DisplayName0...

  Back at TechDays Ottawa I was using my laptop to give a presentation on Hyper-v live migration. Anyways Rick walked into the room as I was just about to “clean” my desktop of folders and icons as I always do before a presentation. Rick said “Let...

  Ellen told me about this article, it not really a joke but it is funny. http://www.winnipegsun.com/comment/columnists/greg_weston/2010/02/12/12858676.html

John Marcum send me this picture from his cellphone… Don’t ask me how you can have something manufactured in both Canada and the USA!  

  MS is looking for people to beta test a new App-v / Med-v Exam. Seats are limited but if you are into App-v or Med-v Check out their blog post. http://borntolearn.mslearn.net/2010/02/recruiting-beta-candidates-for-exam-71-669   Hey Jeff, What...

SELECT Distinct         sys.Netbios_Name0,     fcm.SiteCode,     sys.User_Domain0,     sys.User_Name0,     sys.Operating_System_Name_and0,    ...

What give is it? I just don’t get it. I understand their need to block some content based on your location and the rights that they have within the locations. BUT why block FREE contact that is OPEN to everyone!!!! WHY MUST I change regional setting?...

This might NOT list all routers in your environment, and it will has lots of false positives too.   Of the 7 device marked as a router, only 3 are right, the remaining 4 are false positives.   In my test lab it found 3 out of 7, Routers /Switches...

With the start of a new year, it is that time again to support the System Management Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). Why do I do it? Well as a past User Group leader for www.OWSUG.ca , I know...

select     R.*  from      SMS_R_System R where     R.SystemGroupName != "GARTEK\\Domain Admins"     and R.ResourceId not in (    select                        ...

SELECT     DisplayName0,     Count(*) AS 'Count',     Publisher0,     @CollID as CollectionID FROM     v_Add_Remove_Programs arp     JOIN v_FullCollectionMembership...