DotVBS | Windows Systems Management

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_Collection left outer join v_CollectToSubCollect on v_Collection.collectionid=v_CollectToSubCollect.subcollectionid left outer join v_Collection ParentCollection on v_CollectToSubCollect.parentCollectionID = ParentCollection.collectionid where v_Collection.Name in (Select Name from v_Collection Group By Name Having Count(*)>1) 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." ...

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 Errors List of Status Message IDs 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 n...

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 stat.RecordID = att1.RecordID inner join SMS_StatMsgAttributes asatt2 onstat.RecordID = att2.RecordID where stat.ModuleName = "SMS Client" and stat.MessageID =10070 and att2.AttributeID = 401 and att2.AttributeValue = "advertID" 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 f...

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. 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...

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 file. Search for the section "BEGIN_SITE_DEFINITION". Within this section, locate the third value, which is the site name. Change this value to the new site name, leaving the brackets intact. Do not change any other values. Save the "\SMS\inboxes\sitectrl.box\sitectrl.ct0" site control file. Open RegEdit and find HKLM\Software\Microsoft \SMS\Identification. Change the Site Name value to the new site name. Done! About the Author Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specia...

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 . 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.

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 . 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.