Reasons to Upgrade from 5.5 to vCentre 6 and Plan to Upgrade

Parse Logs with Powershell

Get-Content -Path “C:\Logs*” | Select-String -Pattern “nameofthingtofind”

Olympus System Configuration Program Retention XML

Recently we had a task to update all the Finished folders in Olympus to remove old items old than 2 months. I tried to use the Group function of this software to deploy the settings however they weren’t taking. Instead of editing the individual users I wrote the following powershell to Edit each users XML configuration

Source code

$Files = Get-ChildItem \\folder\location
ForEach($file in $files) {
$xml = [xml](Get-Content $file.FullName)
$xml2 = $xml.Profile.TranscriptionInformation.FolderDesign.FolderList.Folder | Where-Object { $_.parent -eq '101' -and $_.type -eq '115'}
$xml2.Actions.Cleaning.fixed = [io.path]::GetFileNameWithoutExtension($file.Name)
$xml2.Actions.Cleaning.Enabled = '1'
$xml2.Actions.Cleaning.Period = '2'
$xml2.Actions.Cleaning.Unit = '1'
$xml2.Actions.Cleaning.Option = '2'
$xml.Save($file.FullName)
}

Tags: cleaned, Olympus System Configuration, powershell, retention, xml

HA unsuccessfully failed over VM on HOST in cluster vSphere HA will retry if the maximum number of attempts has not been exceeded. Reason: Operation timed out.

Recently during a Veeam backup HA kicked in due to a problem with VCenter and marked two machines as Invalid

•  Veeam started backup and created snapshot on affected VMs
• HA kicked in after VCenter Server failure
• Vcenter tried to move the machines after the HA event but they were locked by the snapshot Veeam had (the hypervisor has a lock because of the snapshot)
• Machine couldn’t move but Vmware removed them from inventory and tried to register them to another host, without success
• Machines marked as Invalid, Removing machines from Inventory and registering the machines manually did not work
• The machines are locked however still powered on and response

Fix to get VM’s registered on VCenter

• Stop any tasks (i.e. Veeam) that might trigger a snapshot on affected machines
• Temporarily disable DRS in the cluster (when we power up the machine we don’t want Vsphere to power it up on another host otherwise the lock will persists)
• Power affected VMs off gracefully from within the OS.
• Login to vcenter and select Host which failed and . Unregister “unkown” VM’s listed (these should be the actual Vms). Unregistering should remove the lock.
• Register the virtual machines using the vmx files in the datastore
• Check no snapshots are present, if yes delete or consolidate
• Power on Vm
• Re-enable DRS

Tags: HA unsuccessfully failed over VM on HOST in cluster vSphere HA will retry if the maximum number of attempts has not been exceeded. Reason, invalid, Operation timed out., register, snapshot, veeam, Vmware

Discovery Mailbox Search Exclude External Mail Export to PST

This Exports a report of emails and also a copy of all the emails to a mailbox ( Disovery ) you can do this via the Web Based Gui : https://youwebmaildomain/ecp/?rfr=owa with the right user permissions

Source code

New-MailboxSearch -Name "WeekendOutage-Search" -StartDate "1/1/2009" -EndDate "12/31/2009" -SourceMailboxes "Amit Tank" -TargetMailbox "Discovery Search Mailbox" -SearchQuery '"Weekend" and "Outage"' -MessageTypes Email -IncludeUnsearchableItems -LogLevel Full

But you cannot exclude emails from specific domains from this discovery search .e.g only sent from Externally. You can exclude Generic Keywords using NOT in the -SearchQuery but its generic to the email like the search Query above.

The New-MailboxExportRequest Should be able to do this but it doesn’t , just exports everything probably because the operator is too specific and doesn’t suport -notlike 🙁

Source code

New-MailboxExportRequest -Mailbox "Discovery Search Mailbox" -contentfiler{sender -ne "*@internaldomain.com"} -Filepath \\samba\share\withexchangepermissions\file.pst

But we can actually just delete all the Internal Mail using Search Mailbox

Source code

Search-Mailbox -Identity "Discovery Search Mailbox" -searchquery 'From:"@internaldomain.com"' -DeleteContent

Now we can just export this to a PST

Source code
   
New-MailboxExportRequest -Mailbox "Discovery Search Mailbox" -Filepath \\samba\share\withexchangepermissions\file.pst

Tags: delete, Discovery Search Mailbox, exchange 2010, exclude, export to pst, external mail, New-MailboxExportRequest, powershell, pst, Search-Mailbox

OwnCloud Setup Increase File Upload size from 512mb

NB : Are you running a 32bit OS?

Source code

cat /etc/0s-release

If Pretty_Name = i586 it means you are, means your file size can only be 2Gigabytes which means you can only set your max filesizes below to 2000M (any more and you will get Unable to set upload directory)

Php.ini ( timeouts )

Source code

vi /etc/php5/apache5/php.ini

post_max_size = 2000M

upload-max-filesize = 2000M

max_execution_time = 300  

Increase File Upload Size
Go to /srv/www/htdocs/owncloud/ and edit .user.ini and  the .htaccess

upload_max_filesize=2000M
post_max_size=2000M

Restart Apache

Source code

systemctl restart apache2.service

Tags: exceeds the limit of bytes at Unknown#0, file limit, increase file size, opensuse, owncloud, post_max_size, Unable to set upload directory, upload_max_filesize

SQL

Shows all the databases of a server and the last time they were accessed

Source code

SELECT DatabaseName, MAX(LastAccessDate) LastAccessDate
FROM
    (SELECT
        DB_NAME(database_id) DatabaseName
        , last_user_seek
        , last_user_scan
        , last_user_lookup
        , last_user_update
    FROM sys.dm_db_index_usage_stats) AS PivotTable
UNPIVOT 
    (LastAccessDate FOR last_user_access IN
        (last_user_seek
        , last_user_scan
        , last_user_lookup
        , last_user_update)
    ) AS UnpivotTable
GROUP BY DatabaseName
HAVING DatabaseName NOT IN ('master', 'tempdb', 'model', 'msdb')
ORDER BY 2

Shows all the current database connections currently

Source code

SELECT @@ServerName AS server,NAME AS dbname,COUNT(STATUS) AS number_of_connections,GETDATE() AS timestampFROM sys.DATABASES sdLEFT JOIN sysprocesses sp ON sd.database_id = sp.dbidWHERE database_id NOT BETWEEN 1 AND 4GROUP BY NAMEORDER BY 3 

The error “[Microsoft][ODBC SQL Server Driver][SQL Server]A cursor with the name ‘Store’ already exists.”

When renaming a user in iManage/ Worksite the logs show

“[Microsoft][ODBC SQL Server Driver][SQL Server]A cursor with the name ‘Store’ already exists

The trigger in the DOCMASTER Table contains a cursor called Store which conflicts with the stored procedure. Choose modify on the trigger and do a search and replace Store another variable e.g. StoreTrigger. Execute the trigger after to save and try again

Tags: "[Microsoft][ODBC SQL Server Driver][SQL Server], imanage, Store, trigger, worksite

cannot find an overload for “delete” and the argument count 0

In Exchange EWS when trying to delete an item you get the following error : cannot find an overload for “delete” and the argument count 0 using

Source code

$item.Delete()

You need to give it a an enumeration e.g.

They can be found here : http://msdn.microsoft.com/en-us/library/microsoft.exchange.webservices.data.deletemode(v=exchg.80).aspx

Source code

$item.Delete([Microsoft.Exchange.WebServices.Data.DeleteMode]::HardDelete)

Tags: cannot find an overload for "delete", delete item, emueration, EWS

Add License failed: The license is not an upgrade license which is required since a base license is already installed

Upgrading a Citrix branch repeater ( Now called CloudBridge)  to the latest firmware requires the License currently installed to be in date and under maintenance. If you renew your Citrix Maintenance you need to re-download all your licenses and reupload them to the branch repeater before it accepts the new firmware file.

Upon reuploading one of the new License file to a branch repeater I was given the error

Add License failed: The license is not an upgrade license which is required since a base license is already installed

This required me to delete the current license from the Citrix Branch Repeater ( Warning this will disconnect accelerated connections so make sure you do this out of production hours ) and reupload the license.

Tags: Branch repeater, Citrix, CloudBridge, License, The license is not an upgrade license which is required since a base license is already installed