Who has Downloaded My Chatter Files ?

Salesforce is evaluating and enhancing the way we use Files with help of Content and Chatter Files. Customer might want to know that who has downloaded Chatter files on their Local System? In this article, I will explain a little hack on identifying name of Users, who  has downloaded Chatter File from Organization.

There is no Out of box functionality provided by Salesforce yet to view names of users, So we are gonna use either Dataloader or Developer Console, which in turn will use SOQL.

In CRM Content, You can see name of users like below image :

But, What if file is not in CRM Content ? It is shared as part of Chatter ?

Open your chatter file, Which you want to track and click on “Show All Version”.

Copy URL of all Versions Some Where, like in Notepad by clicking on icon and “Right Click – Copy URL”

URL will look like :
https://shivasoft — .ap1.content.force.com/sfc/servlet.shepherd /version/download/06890000000q6pp?asPdf=false&operationContext=CHATTER

Now, Get ID from these URLS. In Our case we have 2 versions so we have 2 Ids.

Use below SOQL either in Dataloader or Developer Console :

SELECT ContentVersionId, Field, CreatedById,CREATEDDATE FROM ContentVersionHistory WHERE ContentVersionId IN (‘06890000000ox07′,’06890000000q6pp’ ) AND Field=’contentVersionDownloaded‘

As you can see, We are using ContentVersionHistory table to extract file downloaded information.