Nov 13, 2013, 5:39 PM
Had another project where I had to encode text as Base64 (in my case, it was to limit the character set used in the result). If you are adding this to a VBA project, place it in a module and add a reference to Microsoft XML 3.0
Nov 13, 2013, 5:22 PM
We had a need for a hashing function (mostly just to generate random looking data) in Excel. We ran across this one for SHA1 and though that it would be good to save it somewhere we could find it again.
Jun 7, 2013, 2:30 PM
As is often the case, especially with SCCM, version numbers of applications and files are stored as strings (i.e., '7.0.90'). Depending on the software publisher, the version number may or may not be easily sortable in SQL Server. I've created a function that can be used in an ORDER BY clause to facilitate sorting of version numbers.
Jun 6, 2012, 5:37 PM
In many places, SCCM uses a 16-character text string (actually a hexadecimal number) to represent one of the schedule token classes (SMS_ST_NonRecurring, SMS_ST_RecurInterval, SMS_ST_RecurMonthlyByDate, SMS_ST_RecurMonthlyByWeekday, and SMS_ST_RecurWeekly). Microsoft provides a WMI interface to translate between the text string and one of the SMS_ST_ WMI objects. Unfortunately, this interface is only accessible from the SCCM site server and it is not available to clients (who would not likely have the WMI access permission to the SMS_ScheduleMethods class). This post attempts to explain the string and provide methods to allow for its encryption and decryption.
Dec 16, 2011, 10:47 AM
If you have disabled an IPv6 tunnel using the netsh command-line tool, the IPv6 interface will be successfully removed. However, the client will continue to register that interface's IPv6 address with the DNS server until the server is rebooted.