DotVBS | Windows Systems Management

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.ResourceID where stat.AdvertisementID='advertisementID' and stat.LastStatusMessageID=10070 10070 is Time Exceeded, replace advertisementID with your advertisement ID. About the Author Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specializing in PowerShell and Cloud Automation. He maintains DotVBS to preserve legacy knowledge for the "archaeologist admin." Ready to move from VBScript to the Cloud? Check out his book, Pro PowerShell for Amazon Web Services . Visit EmmanuelTsouris.com for his latest projects. As an Amazon Associate, I earn...

10050 Cache too small 10061 Download failed (retrying) 10003 Failed (bad environment) 0 No messages have been received 10054 Not enough space in cache 10045 Not enough space in cache 10034 Program cancelled by user 10022 Program completed successfully (reboot pending) 10009 Program completed with success 10008 Program completed with success 10004 Program failed 10007 Program failed 10006 Program failed 10057 Program failed (download failed - content mismatch) 10053 Program failed (download failed) 10058 Program failed (download/location failure) 10051 Program failed (no content) 10071 Program failed (retrying) 10072 Program failed (retrying) 10056 Program failed (retrying) 10070 Program failed (run time exceeded) 10021 Program failed (unexpected restart) 65535 Program received - no further status 10062 Program retrying (download/location failure) 10060 Program retrying (no content) 10005 Program sta...

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 in the wizard? Do both get advertisements get deleted? Only the correct advertisement is deleted, however the wizard can be misleading. About the Author Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specializing in PowerShell and Cloud Automation. He maintains DotVBS to preserve legacy knowledge for the "archaeologist admin." Ready to move from VBScript to the Cloud? Check out his book, Pro PowerShell for Amazon Web Servi...

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 Simon Burbidge from IE came up with . Basically, you modify the client with a mof which removes the 2 minute wait. Now your agent service will be able to process policy without waiting 2 minutes. Keep in mind, this is not a change for your entire infrastructure, but only in those rare cases you need to compress time a little and remove the SMS Clients two minute wait. Hey, in some cases 2 minutes can be a lifetime! :) Here's the process: 1. Open notepad (or your favorite text editor). 2. Create a text file called setwait . mof . 3. Select the text below, and past into your set...

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 wait when something is going on in the background, just cut the video and use a transition (like dissolve) between cuts. Audio is something I generally lay down as a guide the first time, then replace it with a better sweetened up voice over for the final cut. About the Author Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specializing in PowerShell and Cloud Automation. He maintains DotVBS to preserve legacy knowledge for the "archaeologist admin." ...

There are two main references we have for WQL related to SMS Microsoft SQL MSDN Article SMS 2003 SDK The 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. About the Author Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specializing in PowerShell and Cloud Automation. He maintains DotVBS to preserve legacy knowledge for the "archaeologist admin." Ready to move from VBScript to the Cloud? Check out his book, Pro PowerShell for Amazon Web Services . Visit EmmanuelTsouris.com for his latest projects. As an Amazon Associate, I earn from qualifying purchases at no cost to you.

Jeff Tondt from Microsoft has a sweet utility to map out your SMS hierarchy. About the Author Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specializing in PowerShell and Cloud Automation. He maintains DotVBS to preserve legacy knowledge for the "archaeologist admin." Ready to move from VBScript to the Cloud? Check out his book, Pro PowerShell for Amazon Web Services . Visit EmmanuelTsouris.com for his latest projects. As an Amazon Associate, I earn from qualifying purchases at no cost to you.