Garth Jones at myITforum.com

Tech-days Button

2008-10-10T20:22:52Z

As I posted the other day I will be speaking at Tech-days , Anyways each track is colour coded and both Brad and I will be presenting in the “Green” track in Ottawa. Why I’m on telling you this, well it is simple, when you arrive at Techdays you will be asked which Track button you would like to wear that day, this allows you to find others within same track. So remember that the " Green " track is the best track of them all! This is what the buttons look like at least for speakers....(read more)

MCITP: Windows Server 2008, Server Administrator

2008-10-10T19:02:06Z

Well this morning I did it. I became a MCITP: Windows Server 2008, Server Administrator , it helped that I have 20 hours last weekend while drive to/from a wedding in “ Soo ” to finish reading the 70-646 MS Press book! I also made a few more decision about exams. 70-089 , Well I’m already an MCSE and no client will ever ask if I have written and passed that exam so I am officially dropping this one from my list of exam to work on, there is no point. However if I am ever bored and have money “burning...(read more)

70-640 Week 19 Q&A Answer

2008-10-10T12:05:12Z

What AD RMS roles has read-only access to the AD RMS logs? Answer: The AD RMS roles with read-only access to the AD RMS logs is “AD RMS Auditors”...(read more)

List ARP by PCs with name like

2008-10-09T12:55:49Z

SELECT ARP.ProdID0, ARP.DisplayName0, ARP.Version0, CS.Name0 FROM dbo.v_Add_Remove_Programs ARP, dbo.v_GS_COMPUTER_SYSTEM CS WHERE ARP.ResourceID = CS.ResourceID AND CS.Name0 Like 'AB%'...(read more)

3 Free Exam Vouchers!

2008-10-09T12:46:49Z

Do you want 3 Free Exam vouchers? Well sign-up for the Beta Exam of 70-113 aka 70-640 and you could get 3 free exam vouchers. Here are the details. New Virtual Lab based Exam 70-113: TS: Windows® Server 2008 Active Directory, Configuring - Registration open till October 25th for testing!!!! Want to help us out with the new Virtual Lab based exams!!! This is NOT a normal beta exam and so make sure you read the information in BLUE below. This is a pilot to test the exam experience only. Still interested...(read more)

Successful Migration Techniques For Migrating To Microsoft Exchange Server 2007

2008-10-07T13:36:02Z

Microsoft Exchange Server 2007 provides many enhancements to help organizations better manage their email, extend their messaging platform with Unified Communications technologies, and provide greater reliability and security. IT Pros are challenged with upgrading or migrating their existing email platform to Exchange 2007, while at the same time being keenly aware of the fact that email is something that can never go down. This session will teach you the best practices to migrate to Exchange 2007...(read more)

Count of Max Run Time for Software Updates

2008-10-07T13:00:42Z

SELECT UI.MaxExecutionTime, Count(UI.MaxExecutionTime) FROM dbo.v_UpdateInfo UI GROUP BY UI.MaxExecutionTime ORDER BY UI.MaxExecutionTime...(read more)

List PSTs

2008-10-06T14:38:10Z

SELECT CS.Name0, CS.UserName0, SF.FileName, SF.FileSize, SF.FileModifiedDate, SF.FilePath FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_SoftwareFile SF, dbo.v_GS_SYSTEM SYS WHERE SYS.ResourceID = CS.ResourceID AND SF.ResourceID = CS.ResourceID AND SYS.SystemRole0='Workstation' AND SF.FileName Like '%.pst' Order By CS.Name0, SF.FileName...(read more)

70-640 Week 19

2008-10-06T12:39:30Z

This weeks reading for the self study group is: 16.2 Configuring and Using Directory Right Management Services 16 45 17.1 Understadnign Active Directory Federation Services 29...(read more)

70-640 Week 19 Q&A

2008-10-06T12:06:34Z

What AD RMS roles has read-only access to the AD RMS logs?...(read more)

70-640 Week 18 Q&A Answer

2008-10-03T12:12:00Z

What is CRL? Answer: Certificate Revocation List...(read more)

NoCount On

2008-10-02T21:00:33Z

Set nocount on CREATE TABLE #CDisk (resourceid varchar(64), size0 varchar(64), freespace0 varchar(64)) CREATE TABLE #DDisk (resourceid varchar(64), size0 varchar(64), freespace0 varchar(64)) CREATE TABLE #CPU1 (resourceid varchar(64), currentclockspeed0 int, maxclockspeed0 int) CREATE TABLE #CPU2 (resourceid varchar(64), currentclockspeed0 int, maxclockspeed0 int) INSERT INTO #CDisk select distinct vrs.resourceid, dsk.size0, dsk.freespace0 from v_R_system vrs inner join v_gs_logical_disk dsk on vrs...(read more)

Find all PCs with out any v_gs_Computer_System data

2008-09-30T20:36:02Z

Use this query to find all PCs that don't have any data within the v_GS_* views. Right John... :-) select R.Netbios_Name0, R.* from v_R_System r where R.ResourceID not in (select cs.resourceId from v_gs_computer_system cs) Order by R.Netbios_Name0...(read more)

TechDays - Ottawa

2008-09-29T19:15:12Z

v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Buy your ticket to our first Tech·Days training event in your city Tech·Days: The rich learning experience of Tech·Ed, without the travel. You've probably heard of Tech·Ed, the annual technology education and networking conference on Microsoft-based technologies. Perhaps you've even attended. Now, we're happy to help save you the time and expense...(read more)

70-640 Week 18

2008-09-29T12:38:05Z

This weeks reading for the self study group is: 15.2 Configuring and Using Directory Certificate Services 28 55 16.1 Understanding and Installing Active Directory Rights 27...(read more)

70-640 Week 18 Q&A

2008-09-29T12:14:00Z

What is CRL?...(read more)

Find computers by BIOS serial number

2008-09-28T16:22:29Z

SELECT CS.Name0, CS.UserName0, BIOS.Manufacturer0, BIOS.SerialNumber0 FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_PC_BIOS BIOS WHERE CS.ResourceID = BIOS.ResourceID AND BIOS.SerialNumber0=<Enter Serial Number here>...(read more)

70-640 Week 17 Q&A Answer

2008-09-26T12:31:00Z

What versions of Windows 2008 can be used to publish PKI certs to AD? Windows 2008 Web Windows 2008 Web Core Windows 2008 Standard Windows 2008 Standard Core Windows 2008 Enterprise Windows 2008 Enterprise Core Windows 2008 Datacenter Windows 2008 Datacenter Core Answer Windows 2008 Enterprise Windows 2008 Datacenter...(read more)

Simple ARP report

2008-09-25T16:06:30Z

SELECT ARP.DisplayName0, ARP.ProdID0, ARP.Publisher0, ARP.Version0, Count(ARP.ProdID0) AS 'Count' FROM dbo.v_Add_Remove_Programs ARP GROUP BY ARP.DisplayName0, ARP.ProdID0, ARP.Publisher0, ARP.Version0 ORDER BY ARP.DisplayName0...(read more)

2008 IMPACT Awards Finalists

2008-09-25T14:13:06Z

Congratulations to CTE Solution for being a finalist in this year’s “Learning Solution of the Year” they have been truly extraordinary in helping out the user group, study groups and self-study groups! http://www.microsoft.com/canada/awards/finalists_2008.mspx Let’s hope that they win this year!!!...(read more)

How to fake maintenance windows in SMS 2003

2008-09-25T14:04:23Z

You can fake maintenance windows in SMS 2003 by setting the reoccurrence option and the advert expiry options. understand, t his will NOT stop an advert from going over its allot time!...(read more)

Resently Installed Programs

2008-09-25T11:53:36Z

SELECT CS.Name0, CS.UserName0, ISW.ProductName0, ISW.VersionMajor0, ISW.VersionMinor0, ISW.Publisher0, ISW.RegisteredUser0, ISW.InstallDate0, ISW.InstallSource0 FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_INSTALLED_SOFTWARE ISW WHERE ISW.ResourceID = CS.ResourceID ORDER BY ISW.InstallDate0 DESC, CS.Name0, CS.UserName0, ISW.ProductName0...(read more)

WQL - PCs with more that 2 GB free on C:

2008-09-24T20:56:03Z

select distinct SMS_R_System.Name, SMS_G_System_LOGICAL_DISK.* from SMS_R_System inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId where SMS_G_System_LOGICAL_DISK.FreeSpace > 2048 and SMS_G_System_LOGICAL_DISK.DeviceID = "C:" order by SMS_R_System.Name...(read more)

IP History

2008-09-24T20:04:12Z

SELECT CS.Name0, HNAC.TimeStamp, HNAC.DefaultIPGateway0, HNAC.DHCPServer0, HNAC.DNSDomain0, HNAC.DNSHostName0, HNAC.IPAddress0, HNAC.IPSubnet0, HNAC.MACAddress0, HNAC.ServiceName0 FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_HS_NETWORK_ADAPTER_CONFIGUR HNAC WHERE HNAC.ResourceID = CS.ResourceID and HNAC.DHCPEnabled0 = 1 and HNAC.IPAddress0 != 'NULL' and HNAC.IPAddress0 != '0.0.0.0' Order by CS.Name0, HNAC.TimeStamp...(read more)

What is Goal 8?

2008-09-24T16:46:27Z

Well, this morning I passed this exam 70-652 and this put me one step closer to becoming a "Microsoft Certified Non-Professional in AOS: Server Virtualization"! I hope they change the title of that certification! Well I have set a personal target of passing 15 exams by Dec 10th 2008, that date will be 1 year from when I started to updating my certifications to Win2k3 and Win2k8. So with one more to go to meet that target now the question is which exam of my remaining exams should I write...(read more)

More free training for 70-652, 70-403, & 70-643

2008-09-23T12:54:27Z

Free virtualization e-learning collection Take Microsoft E-Learning Collection 6333: Exploring Microsoft Virtualization Technologies for free! Collection 6333 includes the following: • Clinic 5935: Introducing Hyper-V in Windows Server 2008 • Clinic 6334: Exploring Microsoft System Center Virtual Machine Manager 2008 • Clinic 6335: Exploring Microsoft Application Virtualization • Clinic 6336: Exploring Terminal Services in Windows Server 2008...(read more)

How would you like to become a Microsoft Certified Non-Professional?

2008-09-22T14:48:04Z

lol sure I wouldn't mind becoming a How would you like to become a Microsoft Certified Non-Professional in AOS: Server Virtualization!...(read more)

70-640 Week 17

2008-09-22T12:36:55Z

This weeks reading for the self study group is: 14.2 Configruing and Using AD LDS 22 52 15.1 Understanding and Installing Active Directory Certificate Services 30...(read more)

70-640 Week 17 Q&A

2008-09-22T12:32:00Z

70-298 Section 13.2 Q&A Answer

2008-09-22T12:04:39Z

Name the 5 Authentication Methods for IIS. Answer: Anonymous Integrated Digest Basic .NET passport...(read more)