Category Archives: IT Related

Remove protection from protected excel spreadsheet

Remove protection – excel spreadsheet If you work in Office 2013 then open the protected spreadsheet and save as a 2000 – 2003 document Open the spreadsheet and follow these instructions: Press ALT+F11 to bring up the VB Window On the left double click on the “ThisWorkbook” link In the right pane paste the below code Sub PasswordBreaker() ‘Breaks worksheet password protection. Dim i As Integer, j As Integer, k… Read Article →

Dell MD3000i – Non Actionable Failed Drive – Solution

“Service action (removal) allowed: No” what that means is that the drive has most likely failed but it is continues to establish a connection with the MD.  What you can do is to manually fail the drive using SMcli but it may fail if the array already see the drive as failed . To manually set a physical disk to offline status you have to use SMcli, the command line… Read Article →

How to Reset Avaya 5610SW series phone

Follow the steps below to both clear and reset your Avaya 5610SW IP Phone. Maybe you need to clear the IP address or change the extension of the phone. Applies to 5610SW, 5621SW. Reset the settings on Avaya 5610SW A reset is like a soft reset. It wipes out the IP address, extension number, speed-dial, call logs, etc. Step 1 Press the * key when your phone is booting up… Read Article →

Avaya IP500 – Changing the level of log reporting on the Avaya Contact Store

Log file: cscm.log Naming convention: Current days file is cscm.log and previous days are date stamped. Levels supported: INFO, DEBUG, INFO, WARN, ERROR a) Permanently from next time service starts: 1. Edit the file (or create it if it does not exist) \properties\csipo.properties 2. Add the line log.level=DEBUG, replacing DEBUG with any of the levels supported as shown to the left. 3. Reboot the server or restart the ContactStore service… Read Article →

Add additional admin RDP session on Windows 2012 Server

Windows Server 2012 Has One RDP Session by Default   By default, Windows Server 2012 has one remote desktop session enabled. When another administrator logs into the server, the first admin is logged out. Also, Windows Server does not prompt an additional user that two sessions are already active and ask if you would like to disconnect one. The steps below remedy the issue. Log into the server and press Windows… Read Article →

Exchange 2010 – Forced update of the Offline Address Book (AOB)

Sometimes the outlook address book doesnt show a new user for days – heres how to force the issue On your exchange server open the exchange management shell copy the following commands in and execute one at a time Note: replace “yourmailserver” name Update-OfflineAddressBook -Identity “Offline Address Book” Update-FileDistributionService “yourmailserver” -Type “OAB” Get-ClientAccessServer | Update-FileDistributionService -Type “OAB” The above will force Exchange to rebuild and force replication of the OAB

Microsoft Outlook – How to solve issues with Outlook opening attachements

In any business you will have users creating and sending documents via E-mail which are named the same, these are opened daily which isn’t a problem, however when you open a document over and over again, the folder can not handle the same named document once there are over 99 versions in the folder. So to resolve any issue like this all you need to do is to go to the following link… Read Article →

Adobe Reader – Unable to Print

You may find a user can print from everything But Adobe Reader This is the fix disable “enable protected mode at start-up” in Adobe… Open Adobe Reader > edit > preferences > look down left side of page for Security(enhanced)… select… uncheck “enable protected mode at start-up”   …reboot Adobe This will solve it.

Windows Server 2008 – Files not showing in shares

Ive had some users report that once a file has been saved to a network share, other users cant see it for a unspecified period of time. It is an SMB2.0 issue it appears.  But disabling it, isn’t the right call.  You need to add some registry keys to force SMB2.0 to refresh the screen quicker.  Here are the keys: *as always, edit the registry at your own risk* HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Lanmanworkstation\Parameters… Read Article →

Watchguard – Mime type issue – Blocking

When a web server sends HTTP traffic, it usually adds a MIME type, or content type, to the packet header that shows what kind of content is in the packet. The HTTP header on the data stream contains this MIME type. It is added before the data is sent. Certain kinds of content that users request from web sites can be a security threat to your network. Other kinds of… Read Article →

Removing the “Safe to Remove Hardware” hotplug icon from VM

You can disable HotPlug capability using the vSphere Client Note: You can disable HotPlug capability for PCI devices such as e1000 or vmxnet2 NICs. To disable HotPlug capability using the vSphere Client: Connect to the ESXi/ESX host or vCenter Server using the vSphere Client. Power off the virtual machine. Right-click the virtual machine and click Edit Settings. Click the Options tab. Click General > Configuration Parameters > Add Row. Insert a new row with the name devices.hotplug and a value… Read Article →

Exchange 2010 – NTFS issue on VM Ware

The issue we have seen with exchange databases going offline or the issue of DB queues reporting corruption can be resolved very easily. Please follow the below instructions 1. Un-mount affected database in EMC > Organisation Configuration > Mailbox view 2. Right click affected DB > Properties > Maintenance Tab > tick “Don’t mount this database at start-up” and apply 3. Open Computer > Right click or the drive that… Read Article →

Remote HTTPS Listener for Dell Open Manage

Below is the PowerShell commands to enable remote management HTTPS listener which need to be done on all servers that will be managed by DELL OME Important note – Change the -DnsName to the name of the actual server $cert = New-SelfSignedCertificate -CertstoreLocation Cert:\LocalMachine\My -DnsName DnsName.contorso.com Export-Certificate -Cert $cert -FilePath C:\temp\cert New-Item -Path WSMan:\LocalHost\Listener -Transport HTTPS -Address * -CertificateThumbPrint $cert.Thumbprint –Force Get-ChildItem WSMan:\Localhost\listener New-NetFirewallRule -DisplayName ‘Windows Remote Management (HTTPS-In)’ -Name… Read Article →

Exchange 2010 – Public Folder – Send As

Configure Mailboxes Open Active Directory Users and Computers on the Exchange Server. Go to the View menu and choose Advanced. Right click on the mailbox you need to configure Send As on. Choose Properties. Click the Security tab. (This is visible only if you selected Advanced in Step 2). Click Add and select the users name that you want to give Send As permission to. Find Send As in the… Read Article →

DocQrules – Print Job Compression

DocQrules – Adding Printers with link compression Synopsis – When RDP’ing to your central site, remote site users print back to their remote site printers causing large MPLS bandwidth usage. This how-to explains in detail the method to compress > send > decompress print jobs to reduce the overall MPLS bandwidth usage by the print subsystem. Topology – Print Subsystem Install DocQrules on your local and remote print servers Configure the… Read Article →