Chris Stauffer at myITForum.com

You want me to do What?

Syndication

News

Links to blogs i like

Links

July 2007 - Posts

FireFox was updated yesterday.

What's New in Firefox 2.0.0.6

Posted by cstauffer | with no comments
Filed under:

 Looks like lots of good info in this edition.

thanks Rod T. for bringing this to my attention.

 http://www.microsoft.com/technet/technetmag/issues/2007/08/

 

System Center

SMS Evolved: A Powerful New Solution to Manage Your Systems

Systems management is about to get a lot easier. Take a guided tour of System Center Configuration Manager 2007 and see how it can simplify key tasks, such as deploying software updates, managing mobile devices, and maintaining system configurations.

John Orefice

Deploy Apps and Updates to Your Branch Offices

Branch distribution points, one of the new features in Configuration Manager 2007, might appear at first to be a fairly minor addition. But if you take a closer look, you'll find that it offers new, indispensible capabilities for managing software distribution to branch offices.

Steve Rachui

Getting Started with System Center Essentials 2007

Designed specifically for midsized businesses, System Center Essentials offers a unified solution for monitoring, managing, and troubleshooting systems. Here's a detailed guide to installing and configuring Essentials 2007 for your network.

David Mills

Keep an Eye on Your Servers with Operations Manager 2007

Operations Manager 2007, the newest incarnation of MOM, introduces some major improvements, including new management interfaces, better reporting, support for line-of-business applications, new security options, and more.

Pete Zerger

Migrating from MOM to Operations Manager 2007

Ready to make the switch to Operations Manager 2007? Due to architectural changes, there's no simple in-place upgrade path from a previous version of MOM. Instead, follow one of the migration plans presented here.

Andy Dominey

Take Your Apps Virtual with Microsoft SoftGrid

Virtualized applications offer numerous benefits, from improved user experience to simplified system administration. Get a detailed overview of how Microsoft SoftGrid delivers virtual applications, how it can fit into your infrastructure, and how it can save your company time and money.

Ahmer Sabri and Kedar Shah

Just got this from my TAM. Thanks John

Product and Service Pack Highlights Key Products Transitioning: Service Packs Going Out of Support

SQL Server 2000 Service Pack 3aSupport Ended July 10, 2007, Custom Support available
On July 10, 2007, SQL Server 2000 Service Pack 3a (SP3a) transitioned out of support. SQL Server 2005 Service Pack 0Support Ended July 10, 2007
SQL Server 2005 Service Pack 0 (SP0) transitioned out of support on July 10, 2007. Microsoft recommends customers upgrade to Service Pack 1. Please note that Custom Support will not be available.Exchange Server 2003 Service Pack 1Support Ends January 8, 2008
Support for Exchange Server 2003 Service Pack 1 (SP1) will end on January 8, 2008.  Customers currently on Service Pack 1 should consider migrating to Service Pack 2.
Posted by cstauffer | 2 comment(s)

I have seen a lot of requests lately for reports that give info about boundaries and Protected DPs. Here is a MOF that has all of the reports that I use for these questions. They could probably be refined a little more but they should get you started.

Posted by cstauffer | with no comments

I was asked to make a report that would show how many machines each agency has. As you know if you have read my blog before you know, I have about 45 agencies across 35 different sites and 5-7 domains. In order to keep everything straight I have a master collection that contains a collection for each agencies. These collections are based on OU's, Machine name policy and Domain if necessary. I never use Site code because of how things are laid out.

 

So the Collections look like this

 

All Commonwealth Agencies

--> Aging

-->DPW

-->DOH

-->etc....

 

Anyway the problem we have like most large Sites is that agencies don't always clean up AD like they should so there are always machines that no longer exist still in AD. The solution was to have the report only count the machines that where in each of the above collections that have reported to SMS though a hardware scan in the last X days. I was going to go with 60 days but the problem is that some laptops at some agencies aren't turned on every 60 days heck I have see where some went 120 days or more. Yeah I asked the same question "Then why do they have a laptop?" . But politics prevail. Anyway I wanted to be able to add a variable to the report so that the person running the report could put in any number of days they wanted. This way they could run the report against multiple day counts and compare the numbers to try and get a more accurate count of resources.

 

But alas I had a problem, when ever I added the variable to the report, I would get this error:

 

****************************************************

An error occurred when the report was run. The details are as follows:
Invalid operator for data type. Operator equals minus, type equals varchar.

  Error Number:   -2147217900   
  Source:   Microsoft OLE DB Provider for SQL Server   
  Native Error:   403  

 **********************************************************************

 

 

I asked the Guys on the email list what I could do to solve this problem. It turns out that I needed to declare the variable as an integer. Once this was done the report worked.

Michael A Dougherty told me to try this:

WHERE    (v_GS_WORKSTATION_STATUS.LastHWScan >= DATEADD([DAY], - CONVERT(int, @days) , GETDATE()))

Here is the report before the changes that was failing:

******************************************************
SELECT    v_Collection.Name AS Department
, COUNT(v_FullCollectionMembership.Name) AS 'Machine Count'
FROM        v_CollectToSubCollect INNER JOIN
             v_Collection ON v_CollectToSubCollect.subCollectionID = v_Collection.CollectionID INNER JOIN
            v_FullCollectionMembership ON v_Collection.CollectionID = v_FullCollectionMembership.CollectionID INNER JOIN
            v_R_System ON v_FullCollectionMembership.ResourceID = v_R_System.ResourceID INNER JOIN
            v_GS_WORKSTATION_STATUS ON v_R_System.ResourceID = v_GS_WORKSTATION_STATUS.ResourceID
WHERE    (v_CollectToSubCollect.parentCollectionID = 'PAC0004A')
 and (v_GS_WORKSTATION_STATUS.LastHWScan >= DATEADD([DAY], - @days , GETDATE()))
GROUP BY v_Collection.CollectionID
, v_Collection.Name
 
    
ORDER BY v_Collection.Name

****************************************************
 
 Here is the working Report:

Note: I also attached the working MOF file to this post.

****************************************************

SELECT     v_Collection.Name AS Department, COUNT(v_FullCollectionMembership.Name) AS 'Machine Count'

FROM         v_CollectToSubCollect INNER JOIN

             v_Collection ON v_CollectToSubCollect.subCollectionID = v_Collection.CollectionID INNER JOIN

             v_FullCollectionMembership ON v_Collection.CollectionID = v_FullCollectionMembership.CollectionID INNER JOIN

             v_R_System ON v_FullCollectionMembership.ResourceID = v_R_System.ResourceID INNER JOIN

             v_GS_WORKSTATION_STATUS ON v_R_System.ResourceID = v_GS_WORKSTATION_STATUS.ResourceID

WHERE     (v_CollectToSubCollect.parentCollectionID = 'PAC0004A')

 and (v_GS_WORKSTATION_STATUS.LastHWScan >= DATEADD([DAY], - CONVERT(int, @days) , GETDATE()))

GROUP BY v_Collection.CollectionID

, v_Collection.Name

 

   

ORDER BY v_Collection.Name

********************************

Hope this helps someone else.

Posted by cstauffer | with no comments

 This little tool has been around for over a year but it is so usefull. This tool came in handy today when we had to add several DP's to one of the Sites.

Hope someone else finds it handy :-)

http://www.myitforum.com/articles/8/view.asp?id=8904

 Download the utility here:

http://www.myitforum.com/inc/arts/11208Setup.zip

 

 

 

 

 

Posted by cstauffer | with no comments
Filed under:

We found a problem with SP3 last week and was planning on contacting Premier support about it once the Furlough was over. Not allowed to contact them at the moment.  DOH and I spent the better part of 4 hours trying to resolve this problem. But it looks like we where not the only ones to have this issue. I didn't see this problem in the lab. My guess is because of the size of the DB.

Here is the legist of the problem. Once upgrading to SP3 Report number 97 no longer works due to a change in the Add Remove Programs View.

Looks like others have had this issue and a temp solution has been posted.

MyITForum post on problem:

http://www.myitforum.com/forums/post_SP3_issue-_sql_process_100%_/_slow_reporting/m_157335/tm.htm

Blog post on workaround:

http://blogs.technet.com/smsandmom/archive/2007/06/28/sms-2003-sp3-add-remove-programs-reports-may-cause-a-cpu-spike-and-or-sql-timeout.aspx

If you work for the Commonwealth Of Pennsylvania I will include a working MOF file for the replacement report in the July Newsletter.

Posted by cstauffer | 2 comment(s)
Filed under:

http://www.microsoft.com/downloads/details.aspx?FamilyID=173e6e9b-4d3e-4fd4-a2cf-73684fa46b60&DisplayLang=en

 

 

Posted by cstauffer | with no comments
Filed under:
Language(s): English.
Product(s): System Center.
Audience(s): IT Professional.
Duration: 60 Minutes
Start Date:
Monday, July 02, 2007 9:00 PM Pacific Time (US & Canada)
 

Event Overview

While Microsoft System Center Configuration Manager 2007 is very similar to Microsoft Systems Management Server in many regards, there are a few new issues you need to take into consideration when planning for and deploying System Center Configuration Manager 2007 effectively. In this session, we cover the prerequisites, in addition to the new setup process, site systems, and client deployment methods that you need to know about to execute a successful deployment.

Presenter: Wally Mead, Senior Program Manager, Microsoft Corporation

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032343569&EventCategory=5&culture=en-US&CountryCode=US

Posted by cstauffer | with no comments

This is from the webcast lastnight

http://www.microsoft.com/technet/prodtechnol/sms/smsv4/smsv4_help/955fec05-a9a2-42e6-a9fc-944095f7afc5.mspx?mfr=true

Posted by cstauffer | with no comments

Have you ever had an issue figuring out what verion of SQL you are running.

 

Here is the KB that tell you how to figure it out.

 

http://support.microsoft.com/kb/321185

 

 

 

Posted by cstauffer | with no comments
Filed under:

 An update is available that improves the stability of the Windows Management Instrumentation repository in Windows XP and Server 2003. This update has been available for a few weeks. There is now a KB article for it.

XP

http://support.microsoft.com/?kbid=933062

Server 2003

http://support.microsoft.com/kb/933061/

WMI improvements that Windows Vista includes have been ported to Windows XP and to Microsoft Windows Server 2003. You can use the update that is mentioned in this article to improve the stability of the repository on computers that are running Windows XP. This update helps increase the probability that the repository remains stable if you experience an unexpected problem in Windows.

Update for Windows XP
Download
Download the 933062 package now.

Windows Server 2003, x86-based versions

loadTOCNode(4, 'moreinformation'); DownloadDownload the WindowsServer2003-KB933061-x86-ENU.exe package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=94CE776E-A4DA-4937-B2FA-3EC16495222E)

Windows Server 2003, x64-based versions

loadTOCNode(4, 'moreinformation'); DownloadDownload the WindowsServer2003.WindowsXP-KB933061-x64-ENU.exe package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=7D75CC01-7673-4884-ADF8-6AFB7E598D42)

Windows Server 2003, Itanium-based versions

loadTOCNode(4, 'moreinformation'); DownloadDownload the WindowsServer2003-KB933061-ia64-ENU.exe package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=2DEBC154-21A3-49ED-8127-AE95A91D60A1)

Windows XP, x64-based versions

loadTOCNode(4, 'moreinformation'); DownloadDownload the WindowsServer2003.WindowsXP-KB933061-x64-ENU.exe package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=622DA17C-A212-475C-8E2B-7CB54BA95C1B)

Release Date: May 22, 2007

Posted by cstauffer | with no comments
Filed under: