CJSmith dot me

I dump stuff I find useful here

In VBA strip out characters which cause TSQL to fail

Published / by Chris Smith / Leave a Comment

A simple way to strip out characters which can cause TSQL Code to break. Assumes the SQL commannd is in sqlstatement and you are passing a variable in me.comment, before executing the code.

Sage EDI IN Intermediary Email

Published / by Chris Smith / Leave a Comment

I have found users don’t always read the logs from the Adaptus EDI Module anymore in Sage Line 500. There are a few reasons why orders get stuck, the most common is a customer has sent a duplicate EDI file although one was caused by incorrect product supersession setup causing an endless loop.

Maintain regtrans-ms and blf files generated by Georgia UTS sessions

Published / by Chris Smith / Leave a Comment

A little script I schedule for servers using Georgia UTS. Below I use Robocopy to move files older than 3 days, to avoid anyone currently logged in. For me I expect users to be logged on for no more than a day, active user files should therefore be untouched.

Disable Powerpoint 2016 extended display mode

Published / by Chris Smith / Leave a Comment

Credit: http://tips.timscomputer.com/disable-powerpoint-2013-extended-display-mode-via-registry/ Disable the extended display mode upon login, same as the link just modified the version from 15 to 16 Run the following as a batch file upon login

Windows 2008: Task Scheduler causes account lockout when policy locks account after one attempt

Published / by Chris Smith / Leave a Comment

I encountered a very odd issue where I was attempting to amend a scheduled task on a Windows 2008 R2 server. When attempting to amend to a “service” account it locked out immediately. This account has a policy where it is locked out if the password is incorrect once. After several attempts and having to […]

Remotely remove a broken user profile from another computers registry when the user folder is deleted

Published / by Chris Smith / Leave a Comment

I recently had an issue where someone had deleted my admin user profile from a remote server by deleting its folder. The logon then failed as Windows still expected the folder to be there, as obviously the registry entries were not removed. Rather than manually checking HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList for the SID and then removing it […]

Using current versions of Syncplify.me Server! as a Cisco UC Backup Server

Published / by Chris Smith / Leave a Comment

For anyone who has had the annoyance of trying to backup a Cisco Unity Communications based server to a Windows based server, you will know how annoying it can be. I recommend Syncplify.me Server! and it has a how to for its older version of Server!. They have obviously changes it to a web based […]

Amend an SCCM NTFS USB flash drive for the Microsoft Surface 3 (Non Pro)

Published / by Chris Smith / Leave a Comment

Microsoft Surface 3’s for some reason don’t support mounting USB Flash drives mounted as NTFS from its UEFI/BIOS and have to be FAT32. Either reformat the USB flash drive as Fat32 and copy back the image (Windows Command Line currently only supports FAT32 to NTFS conversion, not the other way around), third party software needs […]