SQL Admin
How to Trace Deadlocks:SQL Management Studio >> Tools >> SQL Profiler >> log in >>…
0 Comments
Dial Plans Decoded
() parenthesis enclose the dial plan | pipe means OR x represents a digit between…
0 Comments
Sync AD OU Containers with Group Memberships
Script to Add Group Membership:for /f "tokens=*" %A IN ('dsquery user %PATH_TO_OU%') DO dsmod user…
0 Comments
Registry Key to Reset Offline Cache
Symptom:File(s) and/or folder(s) is inaccessible from a certain machine when navigating toward the remote file…
0 Comments
How to Change iTunes Backup Location of Storage In Windows
Make a directory junction after moving the backup storage location robocopy "C:\Users\%USERNAME%\AppData\Roaming\Apple Computer\MobileSync" "D:\iphone_backups" /E…
0 Comments
How to Setup Snom Model M9r SIP Phone with ShoreTel
Ensure that ShoreTel requirements are met Each SIP extension needs 1 IP Phone and 1…
0 Comments
Increase the Disk Timeout On Windows Servers
Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\disk]"TimeOutValue"=dword:0000003cChange timeout value to 10 minutes:"TimeOutValue"=dword:00000258
0 Comments
PowerShell Commands to Install the NTFSSecurity Module
Background information:- NTFS code is hosted on Github: https://codeload.github.com/raandree/NTFSSecurity/zip/refs/heads/master- Find module path with this command:…
0 Comments
VMWare Networking Stuff
ManagementMTU: 1500 VM NetworkMTU: Default (1500) vMotionMTU: 1500vMotion must be selected on the vMkernel iSCSI…
0 Comments
FTP On Upload Email
# Connection details# If your SMTP server does not support SSL, remove the -UseSSL parameter…
0 Comments
Manual Sync for Office 365 Azure-AD Integration
1. Perform Prerequisites:* a. Install Dot Net Framework 4.5 )* b. Install Windows Management Framework…
0 Comments
Script to Push Files to Remote SFTP Server
# 1. Install WINSCP and include it in the %PATH% environmental variables# 2. Run this…
0 Comments
PowerShell Script to Clean Up Files Older than X Days
$purgePeriod = 30;$folders = '\\FILSERVER01\ORDERS\BACKUP','C:\SFTP_BACKUP';Get-ChildItem -path $folders | where {$_.Lastwritetime -lt (date).adddays(-$purgePeriod)} | remove-item;
0 Comments
PowerShell Script to Read/Parse XML Files in a Directory
# This script is to be set on the FTP server or $folder = '\\FTPSERVER05\SFTP\EDI\INCOMING';$files…
0 Comments
ARP MAC to IP Resolution
If entry already exists on the ARP table:arp -a | find "XX-XX-XX-XX-XX-XX"If entry does not…
0 Comments
PowerShell Script to Send Email
Use this newer method: https://blog.kimconnect.com/powershell-script-to-send-emails/ ### Variables section ###$fromaddress = "[email protected]"$toaddress = "[email protected]"$bccaddress = ""$CCaddress…
0 Comments
HP Procurve Cheat Sheet
Steps (9 total) 1. Config Files and Flash Files #show config --- Show config file#show…
0 Comments
Script to Purge Stuck Print Jobs
Create a Task Scheduler:- Program to run: powershell.exe- Argument: -ExecutionPolicy Bypass c:\scripts\clearStuckQueue.ps1- Trigger: daily, repeat…
0 Comments
Multiple Spanning Tree on Cisco
Telnet to CORE1:sys #enter system configstp region-configurationregion-name HQrevision-level 1instance 1 vlan 1 2 15instance 2…
0 Comments
Office 365 Rules
Block Executables: https://support.office.com/en-us/article/Blocked-attachments-in-Outlook-434752e1-02d3-4e90-9124-8b81e49a8519?CorrelationId=66e06c24-0d68-47c1-a503-5b4e30bc1c8a&ui=en-US&rs=en-US&ad=US&ocmsassetID=HA102749484#_Attachment_file_types Reject large files: Sender is located Outside the organization The message size is…
0 Comments