Browse by Tags

70-669 study guide material

While reading another forum this morning I found this tidbit. http://www.techexams.net/forums/virtualization/51260-70-669-resources.html

Posted to Garth Jones (Weblog) by Garth on 03-13-2010
Query for a portion of a NetBIOS Name

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

Posted to Garth Jones (Weblog) by Garth on 03-11-2010
ConfigMgr / SCCM Documentation Script v1.24

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

Posted to Garth Jones (Weblog) by Garth on 03-02-2010
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 how much it cost to host a small user group community...

Posted to Garth Jones (Weblog) by Garth on 01-07-2010
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 to Garth Jones (Weblog) by Garth on 01-04-2010
Null and Not like

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

Posted to Garth Jones (Weblog) by Garth on 12-31-2009
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 by R . Name0 , R . Operating_system_Name_And0

Posted to Garth Jones (Weblog) by Garth on 12-21-2009
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 R . Name0 , ...

Posted to Garth Jones (Weblog) by Garth on 12-04-2009
Servers Report Query

SELECT R.Netbios_Name0, os.Caption0, ARP.DisplayName0 As 'Softwarename', ARP.Publisher0 as 'Publisher', ARP.Version0 as 'version', ARP.ProdID0...

Posted to Garth Jones (Weblog) by Garth on 12-04-2009
System Center Configuration Manager 2007 with Service Pack 2 (x86) - DVD (English) is now available on TechNet.

The fully integrated ConfigMgr 2007 with SP2 is now available on TechNet. Now you can install with SQL 2008 from the start, no upgrading from SQL 2005.

Posted to Garth Jones (Weblog) by Garth on 12-04-2009

Page 1 of 30 (293 items) 1 2 3 4 5 Next > ... Last »