Add SIP address to all users in certain OU

This situation may come true if you have Onpremises Exchange and Online tenant Lync. Then you need to add a SIP address with the same name as the user is in the Online tenant. And here’s the script: $mailboxes =…

Continue Reading Add SIP address to all users in certain OU

Exchange 2010 sp3 RU5 and Online tenant Hybrid

We had a customer with multiple smtp domains at onpremise Exchange. 1. First you need to add them to authorized domains in Office 365 control panel. 2. Add the given txt -records to public dns. 3. Go back to Office…

Continue Reading Exchange 2010 sp3 RU5 and Online tenant Hybrid

Removing the Temporary Attribute from Multiple Files with Powershell

I found this one very helpful in debugging DFS replication with Autodesk generated files. Autodesk products stamp a temporary mark to files it generates. And this causes DFS to stop replicating them. Run this powershell oneliner to clear out the…

Continue Reading Removing the Temporary Attribute from Multiple Files with Powershell

Can’t change Office 2013 shortcut locations in the Office Customization Tool

Well this is annoying. When try to modify Skydrive or Lync shortcuts or even add a desktop shortcut they wont work. Hopefully there is a workaround for this. Add [ to Start In -box … like this: And you have…

Continue Reading Can’t change Office 2013 shortcut locations in the Office Customization Tool

How to display only user databases in SQL

This is how: select * from sys.sysdatabases where dbid>4 and [name] not like ‘$’

Continue Reading How to display only user databases in SQL

Find SQL-database backup dates

Type this query to find them:   SELECT T1.Name as DatabaseName, COALESCE(Convert(varchar(12), MAX(T2.backup_finish_date), 101),’Not Yet Taken’) as LastBackUpTaken, COALESCE(Convert(varchar(12), MAX(T2.user_name), 101),’NA’) as UserName FROM sys.sysdatabases T1 LEFT OUTER JOIN msdb.dbo.backupset T2 ON T2.database_name = T1.name GROUP BY T1.Name ORDER BY…

Continue Reading Find SQL-database backup dates

Remote powershell to Lync 2010 / 2013 FE

Connet session: $cred = Get-Credential domainusername $session = New-PSSession -ConnectionURI “https://LYNCFE.FQDN/OcsPowershell” -Credential $cred Import-PsSession $session Disconnect session: Get-PSSession | Remove-PSSession

Continue Reading Remote powershell to Lync 2010 / 2013 FE

What to do when VCenter start fails after demoting Domain Controller

MS SQL is the backend database, yes. If you have access to the DB server, the easiest way to view/modify the table is via MS SQL Server Management Studio. – Open MS SQL Server Management Studio and point it to…

Continue Reading What to do when VCenter start fails after demoting Domain Controller

Verify Exchange update rollup version

Open powershell and type: Get-Command Exsetup.exe | ForEach-Object {$_.FileVersionInfo}

Continue Reading Verify Exchange update rollup version