Setting OWA Region and Timezone for all users
paul | Thursday, 26 July 2018 | Office 365 | OWA

To stop users being prompted for their region and timezone when they first log into Outlook Web Access you can run the following powershell command to set the value for all mailboxes.

get-mailbox -resultsize unlimited | Set-MailboxRegionalConfiguration -Language 2057 -TimeZone "GMT Standard Time"

A list of country codes are here: https://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo(VS.71).aspx

 

The to check the correct value has been applied use the powershell command:

Get-MailboxRegionalConfiguration -id [email protected]

 

Only applies to current mailboxes not future ones.

Display Comments...
SSISDB becomes too large
paul | Thursday, 26 July 2018 | SQL Server | SSIS

On SQL Server the database SSISDB is created when Integration Services is installed. This holds the configuration for the SSIS instance, package information and records information about executions. By default it is configured to retain 365 days of data and 10 versions of projects. This may be fine for some SSIS instances but unnecessary for others - resulting in a very large database.

The current config can be listed by the following command:

SELECT * FROM [SSISDB].[internal].[catalog_properties]

Result:

property_name property_value
ENCRYPTION_ALGORITHM AES_256
MAX_PROJECT_VERSIONS 10
OPERATION_CLEANUP_ENABLED TRUE
RETENTION_WINDOW 365
SCHEMA_BUILD 11.0.7462.6
SCHEMA_VERSION 2
SERVER_LOGGING_LEVEL 1
SERVER_OPERATION_ENCRYPTION_LEVEL 2
VERSION_CLEANUP_ENABLED TRUE
 
Changing the config can be done with the following commands (changing the values to match your requirements).
 
EXEC  catalog.configure_catalog RETENTION_WINDOW, 90
EXEC  catalog.configure_catalog MAX_PROJECT_VERSIONS, 5
 
Once the values have been updated you can execute the job created to called "SSIS Server Maintenance Job" using the command below:
 
EXEC msdb.dbo.sp_start_job "SSIS Server Maintenance Job"
 
It may take a while to run if you have a lot of data to delete but should be scheduled to run daily to keep removing new data and keeping the database at a managable size.

 

Display Comments...

Error "WMI: 80041017: The query was not syntactically valid. -- PerfCounter: The specified object is not found on the system. (Performance Counter error 0xC0000BB8)" returned by PRTG WMI sensor. To fix:

  1. Open Admin command prompt on server being monitored
  2. Run command "lodctr /r"

Refresh the sensor and the data should load.

More info here:

https://kb.paessler.com/en/topic/9023-sensor-randomly-generates-80041017:-the-query-was-not-syntactically-valid-event

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/dd348620(v=ws.10)

Display Comments...
Cannot create Contact in Exchange Online
paul | Thursday, 21 June 2018 | Office 365 | Contact

When trying to create a new contact in Exchange Online it fails with the error below:

Cannot create Contact
 
error
The proxy address "SMTP:[email protected]" is already being used by the proxy addresses or LegacyExchangeDN of "joe.bloggs_domain.com#EXT#". Please choose another proxy address.( The "MailUser" with display name "Joe Bloggs" is already setup and using the same address.)
 
This is due to the email address already being used for a guest users account. Guest user account addresses are not displayed within Exchange Online. The only way to create the contact is currently to delete the guest account (which removes all their Sharepoint permissions) and then create the contact.
 
1. Delete the “guest user” MailUser object in Exchange Online 
Get-MailUser [email protected] | Remove-MailUser 
2. Create the MailContact 
3. Add the MailContact 
 
Then the user will have to be added to Sharepoint again and access configured to the sites they previously had access to.

 

Display Comments...
Emails missing from Shared Mailbox
paul | Wednesday, 20 June 2018 | Office 365 | Exchange

Users reporting email sent to Shared Mailbox missing when accessed from Outlook.

When a message is marked with sensitivity "Private" they are not downloaded to Outlook when accessing a Shared Mailbox with full access permission. This is due to being unable to select the view private option when adding full access permission in the Exchange admin center.

The workaround is to access the Shared Mailbox using Outlook Web Access or create a mail transport rule to remove the private flag before it is delivered to the mailbox.

Creating mail transport rule

  1. In Exchange Admin Center under "mail flow" select "Create a new rule..."
  2. In "Do the following..." select "Set the message header to this value..."
  3. Set the message header "Sensitivity" to the value "normal"
  4. Save it

 

Now emails that match the rule get the "Private" flag removed. Making them accessible from the Outlook client.

Display Comments...
Page 1 of 67 (335 Articles) << 1 2 3 4 5  Next >>