DotVBS | Windows Systems Management

How to Troubleshoot SMS Client Install Errors

2008-11-06T13:59:00.000-08:00

Often time, I'm asked how to troubleshoot SMS client installation errors. First thing I would recommend is to check WMI by running wmidiag.vbs on the troubled computer, be sure to run it under admin context. The beauty of wmidiag is, it tells you how to fix the problem. Secondly, if WMI is fine, look through the installation or client logs.

SMS SQL for Last Hardware Inventory

2008-08-05T20:33:00.000-07:00

The following SQL Query will return last HW Inventory date for a specific computer. Code is based on the client health queries by Paul Thomsen. -- Last hardware inventory select Name0, LastHWScan as 'HW Inventory' from v_R_System sys full join v_RA_System_SMSAssignedSites ass ON ass.resourceID=SYS.resourceID full join v_GS_WORKSTATION_STATUS WS ON WS.resourceID=sys.resourceID where

SMS SQL for Last Discovery

2008-08-01T21:31:00.000-07:00

The following SQL Query will return last discovery date for a specific computer. Code is based on the client health queries by Paul Thomsen.-- Last discovery dateselect Name0, AgentTime as 'Discovery'from v_R_System sys full join v_RA_System_SMSAssignedSites ass ON ass.resourceID=SYS.resourceID full join (select ResourceId, MAX(AgentTime) as AgentTime from v_AgentDiscoveries where agentname<>'SMS

VBScript to Set SMS Client Cache Location

2008-07-24T17:05:00.000-07:00

Need to set the SMS Client Cache Location? Well it's pretty easy, here's a basic VBScript to help you get started. This will set the Advanced Clients Cache Location, just be careful to set it correctly. Test, Test, Test! I'd suggest an SMS Package with different cache locations passed via command line (in seperate programs) for maximum flexibility. ---- Begin VBScript ----On Error Resume NextDim

SMS SQL for Duplicate Collection Names

2008-07-23T21:49:00.000-07:00

Recently, I've found many collections with duplicate names. The dupes can cause problems when managing those collections. I quickly created the following SQL to find the offending collections.-- This SQL query will show collections with duplicate names.Select parentCollectionID, ParentCollection.Name, v_Collection.CollectionID, v_Collection.Name from v_Collectionleft outer

SMS 2003 Error 10035, What to Do

2008-07-05T08:17:00.000-07:00

Error 10035, or Waiting for Content, seems to be one of the most frequent errors people encounter. Clients often generate this error even when they succeeed. When things go bad, it's important to understand how to troubleshoot error 10035, and know how to fix it.How to troubleshoot 10035 Waiting for Content ErrorsList of Status Message IDs

SMS SQL for Program Failed Run Time Exceeded 10070

2008-07-05T08:11:00.000-07:00

To create a query or collection of SMS clients which return a status of 10070, or program failed due to the runtime being exceeded, use the following WQL (replace advertID with your advertisement ID): select stat.*, ins.*, att1.*, att1.AttributeTime from SMS_StatusMessageasstat left joinSMS_StatMsgInsStrings as ins on stat.RecordID = ins.RecordID left joinSMS_StatMsgAttributes as att1on

SMS "Program failed (run time exceeded)" 10070

2008-07-05T08:05:00.000-07:00

When a program fails due to error 10070, it does so because the Run Time was Exceeded. SMS Allows a program to run for 12 hours, afterwhich it will issue the failed status message if the program hasn't completed successfully.Note: The Maximum allowed run time within program properties is generally a guide for users running the program themselves, and is not enforced.

Rename an SMS Site

2008-06-18T13:56:00.000-07:00

Not long ago, I had to rename an SMS Site, here are the steps I used, from Jase T. Wolfe's blog.If an SMS Primary Site server, stop the SMS_SITE_COMPONENT_MANAGER, SMS_EXECUTIVE, SMS_SERVER_LOCATOR_POINT, and SMS_SQL_MONITOR services.If an SMS Secondary Site server, stop the SMS_SITE_COMPONENT_MANAGER and SMS_EXECUTIVE services.Open the "\SMS\inboxes\sitectrl.box\sitectrl.ct0" site control

Scriptomatic Becomes Self Aware

2008-06-18T13:52:00.000-07:00

Well, not quite, but the scripting guys would prob add that feature if they could. The script-o-matic is a priceless tool that helps create a variety of scripts. Including making WMI easy for the WMI Challenged.Download Scriptomatic from Microsoft.

SQL 2000 Support End is Near

2008-06-18T13:48:00.000-07:00

Have you upgraded your SMS SQL 2000 installations yet?With the end of SQL 2000 support just around the corner, now is a good time to move if you havn't already. Check out Brian Tucker's blogcast on upgrading.

SMS System Health: SQL Performance Counters

2008-06-18T13:45:00.000-07:00

When examining your SMS Systems health, a few good counters to look at include the following: Memory Physical Disk Processor Access Methods Buffer Manager Cache Manager Databases General Stats Latches Locks Memory Manager SQL Stats SQL Settable Also take a look at the SMS operations Guide, which talks about the cache hit ratio.

SQL Reporting Services and SCCM R2

2008-06-12T23:27:00.000-07:00

I can't wait to try out reporting services in SCCM R2, for those of you with very large SMS and SCCM installations, this will hopefully bring a bit of relief from the old ASP SMS Web Reporting. One particular feature I'm eager to try out, is the conversion tool which will convert SMS Web Reports into Reporting Services Reports.Get the SCCM R2 Beta from Microsoft Connect

Configuration Manager 2007 Videos

2008-02-12T09:32:00.000-08:00

Check out the SCCM 2007 videos on the Blogcast Repository.

SMS Client Health Monitor Tool: Inactive

2008-02-02T19:49:00.000-08:00

Brian Tucker demonstrates how to find inactive clients in SMS 2003 using the Client Health Monitoring Tool.

SMS WQL for All Clients where Last Status is Waiting for User Condition

2008-02-02T19:45:00.000-08:00

select sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client from SMS_R_System as sys join SMS_ClientAdvertisementStatus as stat on sys.ResourceID=stat.ResourceIDwhere stat.AdvertisementID='advertisementID' and stat.LastStatusMessageID=10036--10036 is Waiting for User Condition, replace advertisementID with your advertisement ID.

SMS "Waiting for User Condition" 10036

2008-02-02T19:39:00.000-08:00

Status Message ID 10036, or "Waiting for User Condition" can occasionally grind advertisements to a halt. Make sure the environment and user condition settings for a particular program have been configured appropriately and are not excluding a large portion of your intended audience.Related ArticlesSMS WQL for All Clients where Last Status is Waiting for User Condition SMS Status Message ID's

SMS "Waiting for content" 10035

2008-02-02T19:29:00.000-08:00

Status Message ID 10035, or "Waiting for content" is a common error which can drive you up the wall when testing a package deployment.Have you checked your site boundaries? Often a client is located in a IP Subnet which hasn't been configured within Site or Roaming Boundaries.Has the software been deployed to the clients local DPs? Check the reports and console, make sure the package has been

SMS SQL for Collections with Duplicate Names

2008-02-02T19:21:00.000-08:00

/* The following SQL will display any collections which appear to have a duplicate name. In some cases this may be normal, however this is a good way to find problems and inconsistencies.*/SELECT col.[CollectionID],[Name],[parentCollectionID],[Comment],[OwnedByThisSite],[ReplicateToSubSites],[LastChangeTime],[LastRefreshTime],[RefreshType],[CurrentStatus],[MemberClassName],[

Response_Buffer_Limit_Exceeded

2008-01-23T20:44:00.000-08:00

With large SMS Systems, it's common to exceed the response buffer limit when running certain SMS Web Reports.Microsoft provides this article regarding the problem.http://support.microsoft.com/kb/925764To max out the buffer, basically set the aspbufferinglimit to -1

SMS WQL for All Clients where Last Status is Time Exceeded

2007-09-29T16:52:00.000-07:00

select sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client from SMS_R_System as sys join SMS_ClientAdvertisementStatus as stat on sys.ResourceID=stat.ResourceIDwhere stat.AdvertisementID='advertisementID' and stat.LastStatusMessageID=1007010070 is Time Exceeded, replace advertisementID with your advertisement ID.

SMS Status Message IDs

2007-09-29T16:51:00.001-07:00

10050 Cache too small10061 Download failed (retrying)10003 Failed (bad environment)0 No messages have been received10054 Not enough space in cache10045 Not enough space in cache10034 Program cancelled by user10022 Program completed successfully (reboot pending)10009 Program completed with success10008 Program completed with success10004 Program

Potential Bug with Delete Programs Wizard?

2007-09-06T10:24:00.000-07:00

It appears there may be a bug with the SMS 2003 SP2 Delete Programs Wizard. When deleting a program, the wizard shows you advertisements which have the same program name as the program you are deleting, regardless of the package name, or dependancies, etc. Here's the test:Build two packages with the same program name Advertise both programs Delete one of the programs Do both advertisements show

Removing the SMS Clients two minute wait for Policy Processing

2007-09-05T12:02:00.000-07:00

Removing the SMS Clients two minute wait for Policy Processing is often needed in your test, packaging, or development environments. Recently one of our developers indicated that 2 minutes adds up to a lot of waiting during test cycles. Considering a lot can happen in "two minutes" I remembered finding something about this very issue.On the 1e blog, Phil Wilcock outlines a process developed by

Create tutorials and how to videos with Windows Media Encoder

2007-08-29T23:22:00.000-07:00

Many have asked how we create tutorials and how to videos for SMS and general Windows Topics. Primarily, we use Microsoft Windows Media Encoder, a free Microsoft product. Media Encoder captures screen and microphone input to a WMV file for later distribution or editing. I find that a little editing can go a long way in terms of speeding up demos and how to videos. There's no need to make viewers

Understanding WQL for Collections and Queries

2007-08-23T09:16:00.000-07:00

There are two main references we have for WQL related to SMSMicrosoft SQL MSDN ArticleSMS 2003 SDKThe SDK brings a little more to the party and has excellent documentation on the SMS Classes which you can use in WQL to construct collections and queries.

Map out your SMS Hierarchy

2007-07-27T13:15:00.000-07:00

Jeff Tondt from Microsoft has a sweet utility to map out your SMS hierarchy.

Mandatory Advertisement Time Problems

2007-07-27T12:58:00.000-07:00

When having trouble with Advertisement times, a good place to start is Microsoft KB Article 826854. The article includes some common things to look for such as making sure the client computers time is in sync with the server. Incorrect time settings on a computer can easily change the behavior of the SMS client. Additionally, SMS Client logs such as execmgr.log located in the %windir%\system32\

Managing a Microsoft Infrastructure

2007-07-27T12:57:00.000-07:00

Microsoft has put together a set of online resources to help anyone who manages a Microsoft Infrastructure. Webcasts, Virtual Labs, and Podcasts are all at your fingertips.

Windows Installer Error Messages

2007-07-25T17:20:00.000-07:00

Many times SMS Advertisement fail but the cause is not SMS related, but rather is an MSI specific or client side problem. One such common problem is Error 1601 or out of disk space.Windows Installer Error Messages

Free Training! TechNet Virtual Labs

2007-07-13T12:34:00.000-07:00

Lack of training got you down? Take a look at our many posts on training resources.Microsoft offers free virtual labs online for System Center (SMS) and other Microsoft technologies. Many of the labs are setup to be 30 - 90 minutes depending on the type of Lab and excersizes. All the latest technologies in systems management are at your fingertips, don't wait!Virtual Labs may be blocked by your

Free Training! Microsoft SMS Webcasts

2007-07-13T12:29:00.000-07:00

As we discussed in our previous Free Training post on SMS Scripting Excercises from MMS 2005, theres a wealth of free training out there.Microsoft provides many webcasts on topics ranging from building your SMS hierarchy, modifying the SMS_DEF.MOF, or patching your computers. Take this oportunity to update your skills and keep up with the latest tips and tricks!ResourcesSMS 2003 Webcast Series

Command Line for Quick Remote Desktop Connection

2007-07-13T12:25:00.000-07:00

For quick access to your SMS server, you can use the command line mstsc /v:servername instead of looking for the remote desktop connection icon. To connect to the console session, add the console switch mstsc /v:servername /console.

VBScript using WMI to show temperature probe and fan information

2007-07-02T21:40:00.000-07:00

----Begin VBScript----Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")Set colItems = objWMIService.ExecQuery("Select * from Win32_TemperatureProbe",,48)'Loop through the collectionFor Each objItem in colItems'Echo out the properties for each itemWscript.Echo "Name: " & objItem.NameWscript.Echo "Availability: " & objItem.AvailabilityWscript.Echo "Caption: " & objItem.CaptionWscript.Echo "

SMS SQL for Count of Status Messages

2007-06-21T14:59:00.001-07:00

The following SQL query returns a count of status messages by year, month, day, hour. The dateadd function subtracts 3 days from todays date, giving us counts for the last 3 days.----Begin SQL------Count of Status Messages Broken Down by Year, Month, Day, HourSelect Datepart(yy,time), Datepart(mm,time), Datepart(dd,time), Datepart(hh,time), Count(*)FROM StatusMessagesWhere Time > dateadd(dd, -3,

SMS SQL for Oldest and Newest Inventory Dates

2007-06-18T22:49:00.000-07:00

Three simple little queries to show you both the oldest and newest date for your clients hardware and software inventory.----Begin SQL----SELECT Min(LastHWScan),Max(LastHWScan)From v_GS_WORKSTATION_STATUSSelect Min(LastScanDate),Max(LastScanDate)From v_GS_LastSoftwareScanSelect Min(LastCollectedFileScanDate),Max(LastCollectedFileScanDate)From v_GS_LastSoftwareScan----End SQL----

SMS SQL to show Heartbeat Discovery times

2007-06-18T22:45:00.000-07:00

Some simple SQL to show quick status on heartbeat discovery for all your SMS clients.----Begin SQL----select AgentName, DatePart(dd, AgentTime) 'Day',DatePart(hh, AgentTime) 'Hour' ,Count(*) 'Count'from v_AgentDiscoveriesWhere AgentName = 'Heartbeat Discovery' and AgentTime > '2007-06-18'Group by AgentName, DatePart(dd, AgentTime),DatePart(hh, AgentTime)Order By AgentName, DatePart(dd, AgentTime)

SMS SQL to show Last HW Scan by Day & Hour

2007-06-18T22:41:00.000-07:00

A quick and dirty query to show status of your hardware scan for the last few days, add a darepart yy for year and mm for month if you are looking back more than just the current month.----Begin SQL----SELECT DatePart(dd,HWSCAN.LastHWScan), DatePart(hh,HWSCAN.LastHWScan), Count(*)From v_GS_WORKSTATION_STATUS HWSCANWhere LastHWScan > '2007-06-01'Group By DatePart(dd,HWSCAN.LastHWScan), DatePart(hh

SMS 2003 Script Repository

2007-06-09T11:57:00.000-07:00

Looking for SMS 2003 script samples? Check out Microsoft's SMS 2003 Script Repository.Client Scripts show you how to Create a Discovery Data Record, List the Size of the Advanced Client Cache, Retrieve Updated Machine Policy, Retrieve Updated User Policy, Run Available Scripts on SMS Clients, or Start the SMS 2003 Hardware Inventory Cycle.SMS 2003 Site Server scripts show you how to Connect to an

SMS Copy Paste Script on myITForum

2007-05-18T22:52:00.000-07:00

MyITForum has a wealth of Systems Management information. The SMS 2003 section includes many scripts which cut down on labor associated with managing your hierarchy.The SMS Administrator Console add-on SMSCopyPaste allows you to copy and paste SMS collections, packages, programs and advertisements on your site server or from one site to another.

Changing the size of your distribution manager logs in SMS 2003

2007-03-27T18:21:00.000-07:00

When having distribution manager issues with your sites or distribution points, you may need to increase the distribution manager log size.Using RegEdit, open HKLM\Software\Microsoft\SMS\Tracing\SMS_Distribution_ManagerEdit the MaxFileSize (default is about 2.5 MB).Note how far back your log goes, and do some simple math to figure out how big to make it. If your current log is a day worth of

Need to pop a notification to your users via SMS?

2007-03-10T11:06:00.000-08:00

Software Notification Popup is a sample VBScript to show your users a popup notification.

Replacing your SMS 2003 Site, or just need to export objects?

2007-02-08T23:07:00.000-08:00

Export SMS Queries and Packages posted on MyITForum, demonstrates how to use scripting when replacing your SMS sites.

Stop! Create a restore point before you mess with that system!

2007-01-10T05:09:00.000-08:00

Managing Windows XP systems is not without its pitfalls. When you are making changes to your systems, what steps are you taking to ensure you have the ability to rollback your change?Windows XP Restore Point lets you create a restore point. Don't necessarily need to use this with SMS, however with a large infrastructure, automated delivery is a must!

SMS SQL for Metering Data

2006-12-02T00:33:00.001-08:00

Shows you the computer, file name, file path, usage count, and last usage. Must have metering enabled, with some valid rules defined.----Begin SQL----SELECT SYS.Netbios_Name0, SF.FileName, SF.FilePath,MUS.UsageCount, MUS.LastUsageFROM v_MonthlyUsageSummary MUS INNER JOIN v_R_System SYSON MUS.ResourceID = SYS.ResourceID INNER JOIN v_GS_SoftwareFile SFON MUS.FileID = SF.FileIDORDER BY

SMS SQL for Computers and their Advertisement Status

2006-12-02T00:33:00.000-08:00

Computers and their Advertisement Status----Begin SQL----SELECT SYS.Netbios_Name0, ADV.AdvertisementID, ADV.AdvertisementName,COL.Name AS TargetedCollection, CAS.LastStatusMessageIDNameFROM v_ClientAdvertisementStatus CAS INNER JOIN v_R_System SYSON CAS.ResourceID = SYS.ResourceID INNER JOIN v_Advertisement ADVON CAS.AdvertisementID = ADV.AdvertisementID INNER JOINv_Collection COL ON

SMS SQL for Distribution Point Status and Package Views

2006-12-02T00:31:00.000-08:00

Shows install status for a specific package on your distribution points. Replace package id '00000000' with your package ID.----Begin SQL----SELECT PCK.SourceSite, DPS.PackageID, PCK.Name, DPS.ServerNALPath,DPS.InstallStatusFROM v_PackageStatusDistPointsSumm DPS INNER JOIN v_Package PCKON DPS.PackageID = PCK.PackageIDWhere PCK.PackageId = '00000000'ORDER BY DPS.PackageID----End SQL----

SMS SQL for Joining Status Message and Attribute Views

2006-12-02T00:30:00.000-08:00

Simple query joining status message and attribute views.----Begin SQL----SELECT SM.MachineName, SM.Component, SM.MessageID,COUNT(*) AS 'Count', SMA.AttributeValueFROM v_StatusMessage SM LEFT OUTER JOIN v_StatMsgAttributes SMAON SM.RecordID = SMA.RecordIDGROUP BY SM.Component, SM.MessageID, SM.MachineName, SMA.AttributeValueORDER BY SM.Component, SM.MessageID----End SQL----

SMS SQL to show AD Sites for your Distribution Points

2006-10-27T17:36:00.000-07:00

Shows you AD Sites for your Distribution Points.----Begin SQL----Select SiteCode 'SMS Site', name0 'Name', AD_Site_Name0 'Servers Physical AD Site', IP_Addresses0 'Servers IP' from dbo.v_R_Systemjoin v_SystemResourceListon name0 = servernameleft outer join dbo.v_RA_System_IPAddresseson v_R_System.resourceid=v_RA_System_IPAddresses.resourceidwhere RoleName = 'SMS Distribution Point'order by

SMS SQL to See the Size of a Table

2006-10-04T22:45:00.000-07:00

The following will show you the size of your software inventory table. Change the table name to view other table sizes. Replace yourSMSdbName with the name of your SMS database.----Begin SQL----EXEC sp_spaceused N'yourSMSdbName.dbo.SoftwareInventory';----End SQL----

Setting up a Role in SMS for Specific Collections

2006-09-30T17:30:00.000-07:00

SMS Rights are a pain to work with. (don't think so? Well then stop reading!) For instance, Giving a user or group rights for specific collections, becomes a tricky situation (I say this because rights are not inherited, so when you try to create roles with less than super admin access, it gets sticky.Role for a specific collection, or set of collections.Assign class rights for the following:

SQL Function to take an IP and return the class B

2006-09-21T23:15:00.000-07:00

Creates a SQL function to take an IP and return the class B. There's probably a better way to do this, if you've got one, I'd love to see it. Comment out the second "Set @returnIp" to return a Class C.----Begin SQL----SET QUOTED_IDENTIFIER OFFGOSET ANSI_NULLS OFFGOCREATE FUNCTION dbo.getClassB(@Ip varchar(16))RETURNS varchar(16) ASBEGINDeclare @returnIp varchar(16)Set @returnIp = Reverse(Right(

VBScript to Show Patch Status on a Windows Client using Win32_PatchState_Extended

2006-09-20T10:32:00.000-07:00

There are many Win32 classes in Windows Management Instrumentation (WMI). The following vbscript shows you patches and their status from the Win32_PatchState_Extended Class. You can also use this same code and query the Win32_PatchState class, however it's no longer used for the new Microsoft Scan tool (it uses PatchState_Extended). ---- Begin VBScript ----'On Error Resume NextDeclare CountSet

SMS SQL to view the Database Schema

2006-09-14T19:18:00.000-07:00

Microsoft doesn't support direct access to the SMS Database, however from time to time you may need to query the db directly from SQL. To view the schema, the following SQL comes in handy.---- Begin SQL------This query will show all the views in the SMS dbSELECT TABLE_NAMEFROM INFORMATION_SCHEMA.VIEWSWHERE TABLE_SCHEMA = 'dbo'----End SQL----

VBScript to query WMI for Chassis Type

2006-09-08T17:49:00.000-07:00

Use Chasis type when you need to figure out what kind of computer it is, laptop, desktop, pizza box, lamp, etc.Sure, you can definately build an SMS Collection based on inventory using the chassis type. Then you can manage your laptops differently, and with download execute, proper cache management, and a little bit of hot sauce, you've got some good eats.----Begin VBScript----strComputer = "."

SMS WQL for for Computers Pending a Reboot

2006-08-15T21:52:00.000-07:00

Collections seem to be on our mind, all the time, so here's another to help reboot those pesky non-rebooters. This WQL will give you all your reboot pending computers, so you can send them a reboot package. Ha! Take that, non-rebooters!----Begin WQL----Select SMS_R_System.ResourceID, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier,

Common SMS Audit Status Message IDs

2006-08-11T00:36:00.000-07:00

A couple of common SMS Audit Status Message IDs.30103 Session Release30007 Modify an Advertisement30102 Create a Session30010 Modify a DP30104 Update a collection30034 Modify Discovery Agent30000 Create a Package

VBScript to Set your SMS 2003 Advanced Client Site Code

2006-06-23T22:23:00.000-07:00

Simple script to change site code on a client.----Begin VBScript----On Error Resume Next'Your site code goes heresiteCode = "xyz"Dim oSMSClientSet oSMSClient = CreateObject ("Microsoft.SMS.Client")If Err.Number <> 0 ThenWScript.quitEnd IfoSMSClient.SetAssignedSite siteCodeSet oSMSClient=Nothing----End VBScript----

SMS and Corrupted IIS Metabase

2006-06-20T21:31:00.000-07:00

I've had to use a little known SMS Corrupted Metabase fix on many occasions, thanks to Marcus Oh and his SMS (and other stuff) blog.

VBScript to check if the SMS service is Installed

2006-06-17T08:49:00.000-07:00

Recently I wsa asked how to check if SMS is installed, while there are many ways to do this, I wanted to look for the CCMExec service. This way if SMS is installed by its WMI classes are not there, we still get a true. Alternatives could be to look for the SMS WMI Classes or Add/Remove programs. ----Begin VBScript----IF IsSMSInstalled = True Then WScript.Echo "You have SMS Installed"Else

VBScript to enable BITS

2006-05-24T22:17:00.000-07:00

Sometimes people like to turn off BITS as a security lockdown. When that happens SMS can have issues. Here's a quick and dirty script sample to do the job.----Begin VBScript----On Error Resume NextFor i = 1 to 30If Len(i) = 1 then number = "0" & iIf Len(i) = 2 then number = icomputerName = "name of your computer"Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" &

VBScript to Set SMS Client Cache Size

2006-05-02T22:26:00.000-07:00

Simple VBScript for setting the client cache size.----Begin VBScript----On Error Resume Next' Declare VariablesDim checkCacheValueDim setCacheValue' Set the Cache Size to check for (less than or equal to)checkCacheValue = 1024' If less than or equal to the checkCacheValue' set the Cache Size to thissetCacheValue= 1024Dim oUIResourceMgrDim oCacheSet oUIResourceMgr = CreateObject("

An SMS package doesn't appear on a lower level DP, what do you do?

2006-05-02T18:30:00.000-07:00

A few things to try...Make sure you've selected the DP to receive the packageCheck the status messages (SMS_DISTRIBUTION_MANAGER is one component to check)Check the logs on the SITE server (sms\logs\distmgr.log)

Updating your SMS_DEF.MOF

2006-04-30T21:57:00.000-07:00

Theres a good TechNet webcast covering updates to your SMS_DEF.MOF.Basically, you update the file and drop it into sms\inboxes\clfiles.src\hinvSMS will processes the file and your clients will get updated policy, depending on your policy update cycle. If set to an hour, expect new inventory to start coming in within a few hours.

SQL unattended pops a dialog!

2006-03-03T22:12:00.000-08:00

How nice of SQL 2000 to pop a dialog during an unattended install.How to Suppress the Appshelp Message in an Unattended Installation

Free Training! SMS Scripting Excercises from MMS 2005

2005-09-22T18:15:00.000-07:00

Microsoft provides quite a bit of free SMS training online such as SMS Scripting: MMS Lab Exercises. While attending MMS is not free, these exercises are!VBScripts can help you with just about any SMS related tasks. The MMS 2005 Lab exercises were designed to teach some common solutions to the daily chores for SMS Administrators.After running through the lab, you will be able to connect to the

SUS and SMS?

2005-02-11T21:08:00.000-08:00

Many questions and concerns seem to arise around SMS and SUS. While the two can overlap, its important to understand their similarities and their differences.SUS and the Automatic Update ServiceThe SUS Client is built into WindowsConfiguration is done with the registryAutomatic Update ServiceUsed by both SUS and Windows Update for automatic installs Can be configured by users to download and

SQL To Return Identity when Inserting

2001-08-15T22:56:00.000-07:00

When inserting an identity value, use @@Identity to return the id. Replace myTable with you table name, myField with your field name, myValue with a valid value for your field. Make sure you have an identity row defined and set to auto. @@Identity will return the ID inserted into that row.----Begin SQL----Insert into myTable (myField)Values (myValue); Select @@Identity----End SQL----