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-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-671
• 70-672
• 70-673
• A+
• Canada
• Code
• ConfigMGr
• EnergizeIT
• Enhansoft
• exam
• Flowcharts
• Fun Links
• Hyper-v
• Joke
• MCSE
• MDT
• MMS
• MOM
• MS Support
• MSN
• MVP
• myITforum
• OpsMgr
• Ottawa
• Podcast
• Q&A
• Rant
• SCCM
• SCE
• SCMDM
• SCSM
• SCVMM
• self-study
• SMS Installer
• SMSI
• SoftGrid
• SQL
• Study group
• System Center
• Training
• User Groups
• Virtual Server
• Vista
• VS 2008
• Windows 2003
• Windows 2008
• Windows 7
• WQL

• Office Count

  select     DisplayName0,     Version0,     Count(*) From     dbo.v_Add_Remove_Programs ARP Where     DisplayName0 like '%office%' Group by     DisplayName0... Posted Mar 01 2010, 03:45 PM by Garth with | with no comments Filed under: SQL, SMS, Code, ConfigMGr

• Customized Report "computers with specific software registered in Add Remove Programs"

  SELECT Distinct         sys.Netbios_Name0,     fcm.SiteCode,     sys.User_Domain0,     sys.User_Name0,     sys.Operating_System_Name_and0,    ... Posted Feb 14 2010, 10:35 AM by Garth with | with no comments Filed under: SQL, SMS, Code, ConfigMGr, SCCM

• 2010 myITforum Donation

  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... Posted Jan 07 2010, 01:39 PM by Garth with | with 2 comment(s) Filed under: SQL, SMS, Virtual Server, User Groups, Code, MOM, System Center, MS Support, Fun Links, WQL, ConfigMGr, 70-622, 70-293, self-study, VS 2008, Windows 2008, Training, OpsMgr, 70-299, 70-640, 70-643, 70-642, 70-401, 70-400, 70-620, 70-536, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, 70-624, Q&A, 70-298, Windows 2003, 70-649, 70-646, 70-647, 70-431, MCSE, Hyper-v, MDT, 70-635, 70-671, 70-672, 70-673, 70-631, 70-089, MMS, Enhansoft, myITforum, Rant, 70-236, 70-630, Windows 7, MSN, SCCM, SMSI, SMS Installer

• Collection Query - AD group membership & filter for Add\Remove Programs

  select     R.*  from      SMS_R_System R where     R.SystemGroupName != "GARTEK\\Domain Admins"     and R.ResourceId not in (    select                        ... Posted Jan 04 2010, 08:08 AM by Garth with | with no comments Filed under: SMS, Code, System Center, WQL, ConfigMGr, SCCM

• Null and Not like

  SELECT     DisplayName0,     Count(*) AS 'Count',     Publisher0,     @CollID as CollectionID FROM     v_Add_Remove_Programs arp     JOIN v_FullCollectionMembership... Posted Dec 31 2009, 08:51 AM by Garth with | with 1 comment(s) Filed under: SMS, Code, System Center, ConfigMGr, SCCM

• management nightmare

  SELECT Distinct R . Netbios_Name0 , ARP . DisplayName0 , OS . Caption0 FROM dbo . v_R_System R INNER JOIN dbo . v_GS_ADD_REMOVE_PROGRAMS ARP ON R . ResourceID = ARP . ResourceID INNER JOIN dbo . v_GS_OPERATING_SYSTEM OS ON OS . ResourceID = ARP . ResourceID... Posted Dec 23 2009, 02:31 PM by Garth with | with no comments Filed under: SQL, SMS, Code, ConfigMGr, SCCM

• OS version using v_R_System

  select R . Name0 , R . Operating_system_Name_And0 from dbo . v_R_System R Where r . ResourceId not in ( Select ResourceId from dbo . v_R_System R where r . Client_Version0 <> '' ) and R . Operating_system_Name_And0 <> '' order... Posted Dec 21 2009, 01:03 PM by Garth with | with 1 comment(s) Filed under: SMS, Code, System Center, ConfigMGr, SCCM

• Limiting to a Collection.

  SELECT Distinct R . Netbios_Name0 , ARP . DisplayName0 FROM dbo . v_R_System R INNER JOIN dbo . v_GS_ADD_REMOVE_PROGRAMS ARP ON R . ResourceID = ARP . ResourceID Inner Join dbo . v_FullCollectionMembership FCM ON R . ResourceID = FCM . ResourceID... Posted Dec 14 2009, 10:02 PM by Garth with | with no comments Filed under: SQL, SMS, Code, ConfigMGr, SCCM

• Why v_GS_OPERATING_SYSTEM.Caption0 is better than v_R_System.Operating_System_Name_and0

  Take the following query, if you only used v_R_System . Operating_System_Name_and0 then you would have no idea as to which PCs are installed with “Microsoft Windows 7 Ultimate" or “Microsoft Windows 7 Professional”.     Select      ... Posted Dec 04 2009, 10:04 AM by Garth with | with 1 comment(s) Filed under: SQL, SMS, System Center, WQL, ConfigMGr, SCCM

• Servers Report Query

  SELECT         R.Netbios_Name0,     os.Caption0,     ARP.DisplayName0 As 'Softwarename',     ARP.Publisher0 as 'Publisher',     ARP.Version0... Posted Dec 04 2009, 08:14 AM by Garth with | with 2 comment(s) Filed under: SQL, SMS, Code, System Center, ConfigMGr, SCCM

• List of all machines used by users in a certain AD group

  select distinct R.Name, SCU.TopConsoleUser from SMS_R_System R inner join SMS_G_System_SYSTEM_CONSOLE_USAGE SCU on SCU.ResourceID = R.ResourceId where SCU.TopConsoleUser in ( select      U.UniqueUserName      from ... Posted Nov 24 2009, 08:34 AM by Garth with | with 2 comment(s) Filed under: SMS, Code, ConfigMGr, SCCM

• List of PCs not listed v_R_System

  select       CS . name0 as 'PC name' ,       WS . LastHWScan as 'Last HW scan Date'         from       dbo . v_GS_COMPUTER_SYSTEM... Posted Nov 23 2009, 09:18 PM by Garth with | with 1 comment(s) Filed under: SQL, SMS, Code, ConfigMGr

• Attribute Reference Query

  select     SMS_R_System.ResourceId,     SMS_R_System.ResourceType,     SMS_R_System.Name,     SMS_R_System.SMSUniqueIdentifier,     SMS_R_System.ResourceDomainORWorkgroup,    ... Posted Nov 14 2009, 09:15 AM by Garth with | with no comments Filed under: SMS, Code, WQL, ConfigMGr, SCCM

• Find all non-client PCs

  :-) at the suggestion of a friend here is a query to find all non-client PCs. select                SMS_R_SYSTEM.ResourceID,               ... Posted Nov 10 2009, 09:37 AM by Garth with | with no comments Filed under: SMS, Code, WQL, ConfigMGr

• No HW inventory in the last 30 days.

  select     SMS_R_SYSTEM.ResourceID,     SMS_R_SYSTEM.ResourceType,     SMS_R_SYSTEM.Name,     SMS_R_SYSTEM.SMSUniqueIdentifier,     SMS_R_SYSTEM.ResourceDomainORWorkgroup,    ... Posted Nov 10 2009, 08:51 AM by Garth with | with no comments Filed under: SMS, Code, WQL, ConfigMGr