Posts

SMS Copy Paste Script on myITForum

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

Changing the size of your distribution manager logs in SMS 2003

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_Manager Edit 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 activity, and you need 3 days. I suggest making it around 10 MB. 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 ...

Need to pop a notification to your users via SMS?

Software Notification Popup is a sample VBScript to show your users a popup notification. 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.

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

Export SMS Queries and Packages posted on MyITForum , demonstrates how to use scripting when replacing your SMS sites. 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.

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

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

SMS SQL for Metering Data

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.LastUsage FROM v_MonthlyUsageSummary MUS INNER JOIN v_R_System SYS ON MUS.ResourceID = SYS.ResourceID INNER JOIN v_GS_SoftwareFile SF ON MUS.FileID = SF.FileID ORDER BY SYS.Netbios_Name0, SF.FileName, SF.FilePath ----End SQL---- 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 ...

SMS SQL for Computers and their Advertisement Status

Computers and their Advertisement Status ----Begin SQL ---- SELECT SYS . Netbios _Name0, ADV. AdvertisementID , ADV. AdvertisementName , COL.Name AS TargetedCollection , CAS . LastStatusMessageIDName FROM v_ ClientAdvertisementStatus CAS INNER JOIN v_R_System SYS ON CAS . ResourceID = SYS . ResourceID INNER JOIN v_Advertisement ADV ON CAS . AdvertisementID = ADV. AdvertisementID INNER JOIN v_Collection COL ON ADV. CollectionID = COL. CollectionID ORDER BY SYS . Netbios _Name0, ADV. AdvertisementID ----End SQL ---- 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 . ...