October 2009 - Posts

How to Perform a Basic Software Audit (Query)
Saturday, October 31, 2009 8:36 PM

Quick follow up to How to Perform a Basic Software Audit

Do you want to know how many ARP entries you have?

How many page of paper you will get if you print all of the entries?

What about bundles of paper?

 

Use this query to help you determine this for you.

 

declare @ARP BIGINT
Set @ARP = (select count(*) from dbo.v_Add_Remove_Programs)

Select
'Number of ARP entries ' + convert(varchar(10), @arp),
'Number of pages '+ convert(varchar(10), sum(Round(@arp/80,0)+1)),
'Number of papper Bundles '+ convert(varchar(10), round(sum(@arp/40000.0),2))

by Garth Jones
Filed under: , , , ,
What Virtual Labs, Labcasts, and Webcasts are there to help you with Preparing for Microsoft System Center Configuration Manager 2007 Exam (70-401)
Tuesday, October 27, 2009 8:51 AM

Based on the Microsoft Skills Measured web page for 70-401, here is a list of items that can help you with your studying for the exam.

 

Deploying a System Center Configuration Manager 2007 (SCCM) Server (9 percent)

· Set up and configure an Active Directory schema.

· Migrate from an SMS 2003 hierarchy to SCCM 2007.

· Configure an SCCM hierarchy.

· Set up and configure security accounts.

TechNet Virtual Lab: Deploying System Center Configuration Manager (SCCM) 2007

TechNet Virtual Lab: Upgrading SMS 2003 SP2 to System Center Configuration Manager (SCCM) 2007

TechNet Virtual Lab: Upgrading from Microsoft Systems Management Server 2003 to System Center Configuration Manager 2007

TechNet Virtual Lab: Introduction to System Center Configuration Manager (SCCM) 2007

TechNet Virtual Lab: Introduction to System Center Configuration Manager (SCCM) 2007

How to Extend the Active Directory Schema for SMS 2003

Screencast (Part 2 of 4): Master Your Environment with System Center Configuration Manager 2007

 

Configuring an SCCM Infrastructure (19 percent)

· Configure client agents.

· Configure site boundaries.

· Configure core site system roles.

· Configure discovery methods.

· Configure client installation.

· Configure SCCM infrastructure for Internet-based client management.

TechNet Virtual Lab: Deploying System Center Configuration Manager (SCCM) 2007

TechNet Virtual Lab: Configuring Configuration Manager 2007 Security including PKI

 

Managing Resources (14 percent)

· Build an SCCM collection by using queries.

· Meter software usage.

· Manage assets.

· Manage inventory flow.

· Manage client agents.

TechNet Virtual Lab: Generating Asset Intelligence Data with Configuration Manager 2007

Configuration Manager 2007: Collections

How to create a Query and Modify (SMS 2003)

How to Create Collections based on Active Directory Groups (SMS 2003)

 

Distributing Applications (17 percent)

· Manage packages.

· Manage programs.

· Manage advertisements.

· Schedule distribution.

· Track success and failure rates for distribution.

· Manage distribution points.

TechNet Virtual Lab: Implementing Branch Distribution Points in System Center Configuration Manager (SCCM) 2007

TechNet Virtual Lab: Implementing Maintenance Windows for Software Distribution in System Center Configuration Manager (SCCM) 2007

Step by Step: Creating Packages, Collections & Advertisements (SMS 2003)

 

Deploying Operating Systems (13 percent)

· Capture a reference computer image.

· Manage task sequences.

· Configure site system roles related to deploying operating systems.

· Deploy operating system packages.

· Customize user state migration.

· Deliver applications.

Zero Touch Vista deployments in Belfast

SCCM2007 and Microsoft Deployment Toolkit Setup and Config

TechNet Webcast: Automated Windows Server 2008 Imaging and Deployment Using the Microsoft Deployment Accelerator (Level 300)

 

Securing a Network Infrastructure (13 percent)

· Configure Network Access Protection (NAP).

· Maintain NAP.

· Migrate from Inventory Tool for Microsoft Update (ITMU) to Windows Software Update Services (WSUS).

· Deploy software updates.

· Manage vulnerability compliance.

TechNet Virtual Lab: Managing Custom Application Updates using Systems Center Configuration Manager (SCCM) 2007

TechNet Virtual Lab: Managing Microsoft Updates with System Center Configuration Manager (SCCM) 2007

Introduction to Network Access Protection” white paper Webcast updated

Network Access Protection Part 2

Network Access Protection with 802.1x (Part 1)

 

Managing and Maintaining an SCCM Infrastructure (15 percent)

· Manage system health.

· Configure automatic maintenance tasks.

· Create custom reports.

· Maintain clients.

· Manage systems by using configuration management.

· Manage Wake on LAN.

TechNet Virtual Lab: Determining Client Health in Configuration Manager 2007 R2

TechNet Labcast On-Demand: Security Compliance Management Toolkit – Configure the Desired Configuration Management (DCM) feature

TechNet Labcast On-Demand: Security Compliance Management Toolkit – Use the Built-in and Customized Reporting Capabilities of Configuration Manager

TechNet Virtual Lab: Implementing Desired Configuration Management in System Center Configuration Manager (SCCM) 2007

 

Other Labs

TechNet Virtual Lab: Integrating Application Virtualization into Configuration Manager 2007 R2

TechNet Virtual Lab: Integrating SQL Server Reporting Services into Configuration Manager 2007 R2

TechNet Virtual Lab: Upgrading System Center Configuration Manager 2007 to Service Pack 1

How to Perform a Basic Software Audit
Monday, October 26, 2009 9:28 AM

Over on the Enhansoft Blog, we posted a blog on “How to Perform a Basic Software Audit”. This should help answer the question of how to perform a basic software Audit and why “I need a report of all software for all PCs” is a bad idea.

List Collections a PC belongs to
Thursday, October 22, 2009 2:34 PM

select
FCM.CollectionId,
C.Name
from
dbo.v_R_System r
join dbo.v_FullCollectionMembership FCM on R.ResourceID = FCM.ResourceID
join dbo.v_Collection C on C.CollectionID = FCM.CollectionID
Where
R.Name0 = 'ES-03'

Coffee Management Pack!
Thursday, October 22, 2009 8:29 AM

Now this is cool! I would have love this back when I had roommates!

http://blog.coretech.dk/opsmgr07/opsmgr-2007-r2-scom-coretech-coffee-monitor-management-pack-0001/

by Garth Jones
Filed under: ,
How Google Maps has out done Bing Maps! (in Ottawa)
Monday, October 19, 2009 2:10 PM

What Bing Maps sees.

http://www.bing.com/maps/?mkt=en-ca#JndoZXJlMT0xODAraG9sYW5kK2F2ZSZiYj00NS4yNjk3ODk0Mzg2NDQlN2UtNzUuNzYwMjgxMzMwNDgzMSU3ZTQ1LjI2Nzg2NjIwNjYzMDklN2UtNzUuNzYzNjE5NzEzNzUwNA==

What Google Sees.

http://maps.google.ca/maps?f=q&source=s_q&hl=en&q=150+Holland+Ave,+Ottawa,+Ottawa+Division,+Ontario&sll=45.324163,-75.712321&sspn=0.008449,0.022252&ie=UTF8&cd=1&geocode=Fa-5tAIdBW98-w&split=0&hq=&hnear=150+Holland+Ave,+Ottawa,+Ottawa+Division,+Ontario&ll=45.400936,-75.732644&spn=0.008437,0.022252&z=16&layer=c&cbll=45.401019,-75.732707&panoid=ILd5WdrsllLJTXZC1MoSzA&cbp=12,88.05,,2,-16.6

 

So what is the Foolish Chicken, Well this is great chicken and ribs place with fantastic desserts! Ellen and I try to go ever few weeks! If you are in Ottawa check it out!

by Garth Jones
Filed under:
Windows Messenger and Window 7
Monday, October 19, 2009 1:43 PM

So are you like me and don’t understand why MSN has to sit task bar taking up real estate? Well here is the answer to fix this big annoyance!

First browse to Messenger directory

32bit: C:\Program Files\Windows Live\Messenger

64bit: C:\Program Files (x86)\Windows Live\Messenger

Find msnmsgr.exe, right click and click Properties

Select the Compatibility tab

Select Run this program in compatibility mode for: Windows Vista (Service Pack 2)

clip_image002

Reboot

Once you reboot you might have to unpin it from the task bar but it will no longer sit on the taskbar!

Hooray for small miracles!

by Garth Jones
Filed under: ,
Windows 7 first impressions
Monday, October 19, 2009 1:26 PM
  • The upgrade from Vista is slow slow slow!
  • I’m not impressed that VMRCPlus can’t be run on Windows 7. I almost want to return to Vista just because of this one Program alone! However I have a note into the author at MS to see if/when there will be an update to VMRCPlus. I will hold out for a week to see how much this p1$$ me off, by not being able to work with my VMs. SCVMM will do the trick, but I don’t like that you can’t adjust the screen size on the fly.
  • What happened to my Quick Launch bar?
  • Why does MSN stay on my task bar when I’m signed in? I need/want the real estate for other things!
  • What happened to Texas Hold’em and Tinker?
  • I’m not finding it faster than Vista.

It is amazing how the little things drive you nuts!

by Garth Jones
Filed under: ,

This Blog

Syndication