![Harri Jaakkonen](https://i0.wp.com/www.cloudpartner.fi/wp-content/uploads/2021/09/harri_pic.jpg?fit=32%2C32&ssl=1)
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 =…
![Harri Jaakkonen](https://i0.wp.com/www.cloudpartner.fi/wp-content/uploads/2021/09/harri_pic.jpg?fit=32%2C32&ssl=1)
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…
![Harri Jaakkonen](https://i0.wp.com/www.cloudpartner.fi/wp-content/uploads/2021/09/harri_pic.jpg?fit=32%2C32&ssl=1)
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…
![Harri Jaakkonen](https://i0.wp.com/www.cloudpartner.fi/wp-content/uploads/2021/09/harri_pic.jpg?fit=32%2C32&ssl=1)
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…
![Harri Jaakkonen](https://i0.wp.com/www.cloudpartner.fi/wp-content/uploads/2021/09/harri_pic.jpg?fit=32%2C32&ssl=1)
This is how: select * from sys.sysdatabases where dbid>4 and [name] not like ‘$’
![Harri Jaakkonen](https://i0.wp.com/www.cloudpartner.fi/wp-content/uploads/2021/09/harri_pic.jpg?fit=32%2C32&ssl=1)
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…
![Harri Jaakkonen](https://i0.wp.com/www.cloudpartner.fi/wp-content/uploads/2021/09/harri_pic.jpg?fit=32%2C32&ssl=1)
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
![Harri Jaakkonen](https://i0.wp.com/www.cloudpartner.fi/wp-content/uploads/2021/09/harri_pic.jpg?fit=32%2C32&ssl=1)
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…
![Harri Jaakkonen](https://i0.wp.com/www.cloudpartner.fi/wp-content/uploads/2021/09/harri_pic.jpg?fit=32%2C32&ssl=1)
Open powershell and type: Get-Command Exsetup.exe | ForEach-Object {$_.FileVersionInfo}