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))
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.
· 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
How to Extend the Active Directory Schema for SMS 2003
Screencast (Part 2 of 4): Master Your Environment with System Center Configuration Manager 2007
· 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: Configuring Configuration Manager 2007 Security including PKI
· 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)
· 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)
· 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)
· 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)
· 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
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
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.
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'
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/
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!
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)
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!
It is amazing how the little things drive you nuts!