September 2008 - Posts

Find all PCs with out any v_gs_Computer_System data
Tuesday, September 30, 2008 4:36 PM

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

by Garth Jones
Filed under: , , ,
TechDays - Ottawa
Monday, September 29, 2008 3:15 PM
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}

image001 

 

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 of travel by bringing the Tech·Ed experience to your city with Tech·Days 2008.
Check out the sessions.

With Birds-of-a-Feather lunches, and a customizable schedule from up to forty 200+ level sessions, you can connect with Microsoft experts, consultants and your peers while strengthening highly specific skills such as:

  • planning for Server Virtualization;
  • applying Workload Resource Governance on SQL Server® 2008;
  • building rich Internet applications using the Silverlight™-based platform; and a lot more.

PLUS, put your knowledge to work after the event with a FREE Tech·Days Learning Kit—with an approximate value of $1,000, plus bonus offers!

» BUY A TICKET TO THE EVENT IN YOUR CITY NOW.

 

DATE

CITY

VENUE

 

October 29/30

Toronto

Toronto Congress Centre

BUY NOW

November 6/7

Montreal

The Palais des Congrès

BUY NOW

November 27

Ottawa

Marriott Hotel

BUY NOW

December 4

Winnipeg

Delta Hotel

BUY NOW

December 10/11

Calgary

Calgary Stampede Roundup Centre

BUY NOW

December 17

Halifax

Halifax World Trade Centre

BUY NOW

January 21/22

Vancouver

Vancouver Convention Centre

BUY NOW

image005

Save up to $250 when you register before October 15, 2008.
Don't miss out

image006

All attendees will receive a Tech·Days Learning Kit with an approximate value of

$1,000,

PLUS BONUS OFFERS


image009

  » LEARN MORE ABOUT THE KIT

Who should attend:

Software Developers

Web Developers

IT Professionals

Consultants

Project Managers

Testers

IT Generalists

Network Infrastructure Specialists

 

Highlighted technologies:

Virtualization and Windows Server® 2008

Microsoft® SQL Server® 2008

Microsoft® System Center Virtual Machine Manager

Microsoft® Visual Studio® 2008

Microsoft® BizTalk® 2008



 

 

70-640 Week 18
Monday, September 29, 2008 8:38 AM

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  

70-640 Week 18 Q&A
Monday, September 29, 2008 8:14 AM

What is CRL?

Find computers by BIOS serial number
Sunday, September 28, 2008 12:22 PM

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>

by Garth Jones
Filed under: , , ,
70-640 Week 17 Q&A Answer
Friday, September 26, 2008 8:31 AM

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

Simple ARP report
Thursday, September 25, 2008 12:06 PM

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

by Garth Jones
Filed under: , , ,
2008 IMPACT Awards Finalists
Thursday, September 25, 2008 10:13 AM

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!!!

How to fake maintenance windows in SMS 2003
Thursday, September 25, 2008 10:04 AM

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

image

 

image

by Garth Jones
Filed under:
Resently Installed Programs
Thursday, September 25, 2008 7:53 AM

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

by Garth Jones
Filed under: , , ,
WQL - PCs with more that 2 GB free on C:
Wednesday, September 24, 2008 4:56 PM

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

by Garth Jones
Filed under: , , ,
IP History
Wednesday, September 24, 2008 4:04 PM

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

by Garth Jones
Filed under: , , ,
What is Goal 8?
Wednesday, September 24, 2008 12:46 PM

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? 70-400, 646, 647, I’m toying with 70-656 exam too, 402 (if released), and 403 (when).

 

I am leaning towards 70-400 or 70-646.

Why 70-400 because I need to update my lab from MOM 2k5 to OpsMgr 2k7, this is a good excuse to do so.

Why 70-646 because I already have the MS press book and I have started to read it a bit.

 

So what do you think?

 

And yes the 15 exam goal was not the original goal, the goals were:

  1. ConfigMgr Exam and the TS: Windows Vista, Configuring exam (70-401 & 70-620)
  2. Add the Supporting and Troubleshooting Applications on a Windows Vista Client for Enterprise Support Technicians (70-622) to get MCITP: Enterprise Support Technician which allowed me to get my MCT
  3. But then I need to upgrade to MCSE so that I could teach the one class I wanted to teach Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 (6451A aka 70-401 exam) (70-290, 291, 293, 294 and 298) I got my MCSA Win2k3 at this point.
  4. Before completing Goal 3, I was asked to pass TS: Deploying and Maintaining Windows Vista Client and 2007 Microsoft Office System Desktops (70-624) for some contract work so I put 624 before 298
  5. Back to Goal 3 (70-298) and my MCSE for Win2k3
  6. After goal 3 was done it make seen to work on TS: Upgrading Your MCSE on Windows Server 2003 to Windows Server 2008, Technology Specialist (70-649)
  7. Since I bought a new server (new to me that is, I’m not that rich) I decide to do the TS: Windows Server Virtualization, Configuring (70-652) next
  8. Should it be 70-400, 70-646 or other and why?

More free training for 70-652, 70-403, & 70-643
Tuesday, September 23, 2008 8:54 AM

 

Take Microsoft E-Learning Collection 6333: Exploring Microsoft Virtualization Technologies for free! Collection 6333 includes the following:

How would you like to become a Microsoft Certified Non-Professional?
Monday, September 22, 2008 10:48 AM

 

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

image

70-640 Week 17
Monday, September 22, 2008 8:36 AM

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  

70-640 Week 17 Q&A
Monday, September 22, 2008 8:32 AM

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

70-298 Section 13.2 Q&A Answer
Monday, September 22, 2008 8:04 AM

Name the 5 Authentication Methods for IIS.

Answer:

  • Anonymous
  • Integrated
  • Digest
  • Basic
  • .NET passport

70-298 Section 13.2 Q&A
Sunday, September 21, 2008 8:05 AM

Name the 5 Authentication Methods for IIS.

70-298 Section 13.1 Q&A Answer
Saturday, September 20, 2008 8:59 AM

In additional to traditional system backups what other items should be included for IIS?

Answer:

  • Backup web pages
  • Backup any databases
  • Backup metabase

70-640 Week 16 Q&A Answer
Friday, September 19, 2008 8:21 AM

When does WSRM polices kicks in?

Answer:

70% of CPU utilization is when WSRM kicks in.

70-298 Section 13.1 Q&A
Friday, September 19, 2008 8:00 AM

In additional to traditional system backups what other items should be included for IIS?

 

70-298 Section 12.2 Q&A Answer
Thursday, September 18, 2008 8:50 AM

Where is the GPO policy for Wireless networks located?

 

Answer:

The GPO policy for Wireless networks is located under Computer Configuration / Windows settings / Security Settings / Wireless Network (IEEE 802.11) Policies/

 

70-298 Section 12.2 Q&A
Wednesday, September 17, 2008 8:52 AM

Where is the GPO policy for Wireless networks located?

 

Maintenance Windows
Tuesday, September 16, 2008 1:43 PM

SELECT
COL.CollectionID,
COL.Name,
COL.Comment,
MW.Name,
MW.Description,
MW.StartTime,
MW.Duration,
MW.UseGMTTimes
FROM
dbo.v_Collection COL,
dbo.vMWS_ServiceWindow MW
WHERE
COL.CollID = MW.CollectionID

by Garth Jones
Filed under: ,
70-298 Section 12.1 Q&A Answer
Tuesday, September 16, 2008 8:43 AM

What is 802.11?

Answer:

A Standard for Wireless networks.

Microsoft Exam Questions
Tuesday, September 16, 2008 8:39 AM

Another questions that comes up in every study group session is, “What type of question can I expect?” I never been able to true explain what type of questions someone should expect on the exam.

I finally found a way to explain what type of questions you can expect on the exam. Here is a simulation of all the exam question types.

Hot area questions - This kind of question asks you to indicate the correct answer by selecting one or more elements within a graphic.

Active screen questions - This kind of question asks you to configure a dialog box by changing one or more elements.

Drag-and-drop questions - This kind of question asks you to drag source objects to appropriate targets within a work area.

Build list and reorder questions - This kind of question asks you to indicate the correct answer by building an answer list. In a build list and reorder question, you need to build a list by dragging the appropriate source objects to the answer list and then placing them in the correct order based on criteria defined in the question.

Create a tree questions - This kind of question asks you to create a tree structure. You indicate the correct answer by dragging source nodes to the correct locations in the answer tree. Nodes consist of text and a small icon.

Testlet exam format - The MCP program has developed types of questions for Microsoft Certification exams that are very different from other exam formats currently being used. We strongly urge MCP candidates to download the demo and try the testlet exam format to become familiar with this new exam format.

Simulation questions - This kind of question asks you to indicate the correct answer by performing specific tasks such as configuring and installing network adapters or drivers, configuring and controlling access to files, and managing hardware devices. Many of the tasks that systems administrators and systems engineers perform can be presented more accurately in simulations than in most traditional exam question types.

To try them out for yourself, check out this demo!

http://www.microsoft.com/learning/mcpexams/policies/innovations.mspx

 

BTW This simulation seem to be missing one type of exam question, “Multiple select check boxes” however this is one of the easiest questions to handle mostly because as part of the question (on the exam) MS tells you how many answers to select.

70-298 Section 12.1 Q&A
Monday, September 15, 2008 8:44 AM

What is 802.11?

70-640 week 16
Monday, September 15, 2008 8:35 AM

This weeks reading for the self study group is:

13.2 Proactive Directory Preformance Management 25 41
14.1 Understanding and Installing AD LDS 16  

70-640 Week 16 Q&A
Monday, September 15, 2008 8:23 AM

When does WSRM polices kicks in?