What is the maximum name length for a document on Google Drive?

This is a question that most of the people ask, but when they are trying to search for answers it is most likely that they will not find some concrete information about it..

So the limitations for Google Drive: maximum characters name length 32767 characters.

Example:

I created a file name on Google Drive, that has a name of 11974 characters:
2
1However, if you are using Google Drive for Windows or Mac, or you are trying to download that file on one of your stations running Windows or Mac OS it will be automatically resized to around 240-260 characters, because the maximum length for this Operating Systems is 260 characters (including the file type, ex: .pdf / .docx / etc.).

As you can see in the example below, I downloaded the newly created document from Google Drive, and the MAC OS automatically resized the name accordingly to the Operating System’s limitations: 
3
4

So a complete table with maximum name length:
– Google Drive – maximum characters name length is 32767
– Windows OS  – maximum characters name length is 260
- Mac OS – maximum characters name length is 260

Critical problem with Litigation Hold detected in OWA – Exchange Server 2013 and Exchange Online (Office 365)

P5_400x225_Exchange-Online-Plan-1
Recently, a very important critical problem has been detected in the behaviour of litigation hold in Exchange Server 2013 and Exchange Online.

When a mailbox is enabled for litigation and holds a delegate of the mailbox is able to use OWA to permanently delete folders (and their items) from the mailbox, without them being preserved correctly by the litigation hold.

The issue impacts Exchange Online and all supported versions of Exchange Server 2013 on-premises. The bug does not exist when mailboxes are accessed via Outlook or other clients, only when accessed via OWA

Microsoft has released KB2996477 which also describes the issue:

This problem occurs when a user uses OWA to delete or move a folder from a delegated mailbox that is on hold to another mailbox if that mailbox is also open in OWA but is not on hold. The items are preserved according to the hold settings of the delegate’s own mailbox, not the settings of the delegated mailbox. The delegate can move or delete individual items inside a folder, and the items are preserved as expected.

Non-delegated scenarios, in which one user is the sole owner of a mailbox, are not affected by this issue. This problem also does not occur in the Outlook client.

There are 2 known solutions:

1. Put a hold on all users who are participating in delegated scenarios.

2. Disable OWA for users who have delegated access to their mailbox.

First, it’s worth verifying whether any mailboxes in your organization are enabled for litigation hold.

[PS] C:\>Get-Mailbox | where LitigationHoldEnabled

Name                      Alias                ServerName       ProhibitSendQuota
----                      -----                ----------       -----------------
Aurel Proorocu            aurel.proorocu       exch2013         Unlimited
IT Support                it.support           exch2013         Unlimited

If disabling OWA is a practical solution for your organization this can easily be performed, for example:

[PS] C:\>Get-Mailbox | where LitigationHoldEnabled | Set-CASMailbox -OWAEnabled:$false

Of course, if the mailboxes are under investigation it may not be wise to tip off the mailbox owner by disabling OWA. In that case enabling litigation hold for the other users with access to the mailbox would be the better approach.

Gmail – How to drag and drop attachments to your desktop

Gmail makes it easy to drag and drop attachments to your desktop or any other location.
This feature works with all supported browsers, but it is recommended to use Google Chrome. It works on both Mac & Microsoft operating systems.

You just have to click on the attachment, and then drag and drop it wherever you want and release the mouse (for large files, you may see a progress dialog).

blob1

Google emails go to Junk folder on Office 365

It seems that Microsoft and Google continue to tease each other…

As I discovered recently, if you share a file from Google Drive with someone that uses Office 365, the notification email will go directly into the Junk folder.

office365

Solution(s): 
– adding the respective domain on the Office 365 whitelist (ex. @domain-that-is-hosted-on-google-apps.com) 
– creating a contact on your Outlook Online with the senders address (ex. user@domain-that-is-hosted-on-google-apps.com) 

How to change the language of the GSA / Google Search Appliance

There are a few easy ways to change the language of the GSA:

1. If you are working with a remote client, and you don’t want to change the main language of the GSA, you can just open an “incognito window”, log on the GSA Server, and add:

&hl=en

or 

?hl=en

to the end of the URL. Example: 

http://gsa.admin.com/….&hl=en

2. For permanent language change, just change the language of your Internet Explorer.

 

 

 

How to import photos in Active Directory

AD
There is a minor schema modification required in order to enable the use of photos in AD. The change is to change the thumbnailPhoto attribute to make it replicate to the Global Catalog. If you do not have Exchange 2010 Service Pack 1 (SP1) installed (which automatically makes this Schema change), you do need to follow these steps: 

    • If you haven’t registered the Schema MMC snap-in on the server you want to make this change on, go ahead and do so using the following command: Regsvr32 schmmgmt.dll
    • Open an MMC console (Start/Run/MMC) and add the Schema snap-in.
    • In the Active Directory Schema snap-in, expand the Attributes node, and then locate the thumbnailPhoto attribute.
    • In the Properties page, select Replicate this attribute to the Global Catalog, and click OK.

Then you are ready to import photos into AD. This is done with a Powershell command, for example:

Import-RecipientDataProperty -Identity "Aurel Proorocu" -Picture -FileData ([Byte[]]$(Get-Content -Path "C:\pictures\AurelProorocu.jpg" -Encoding Byte -ReadCount 0))

The recommended thumbnail photo size is 96×96 pixels, and by default, the maximum size of photo that can be imported with the Import-RecipientDataProperty command is 10-KB. There are also options to force inclusion of the photo in the offline address book, see the ‘links for more information’ below on how to make those and other advanced changes related to AD photos.

Add created date and last modified time in a cell in Excel

If you want to add the last save time and/or creation date in Excel cells follow this steps (via VBA scripts):

date

1. Hold ALT + F11 keys, that will open the Microsoft Visual Basic for Applications window:

2. Click Insert > Module, and paste the following macro in the Module Window:

Sub Workbook_Open()
Range(“A1″).Value = Format(ThisWorkbook.BuiltinDocumentProperties(“Creation Date”), “short date”)
Range(“B1″).Value = Format(ThisWorkbook.BuiltinDocumentProperties(“Last Save Time”), “short date”)
End Sub

3. Press F5 key to run the macro.

Then it inserts the created date in Cell A1, and inserts the last modified date in Cell B1.
(you can modify the cells by simply editing the script and replacing A1,B1 with the desired cells)

Enjoy !