{"id":3608,"date":"2013-11-10T15:26:26","date_gmt":"2013-11-10T09:56:26","guid":{"rendered":"http:\/\/JitendraZaa.com\/blog\/?p=3608"},"modified":"2013-11-10T15:26:26","modified_gmt":"2013-11-10T09:56:26","slug":"who-has-downloaded-my-chatter-files","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/who-has-downloaded-my-chatter-files\/","title":{"rendered":"Who has Downloaded My Chatter Files ?"},"content":{"rendered":"

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 \u00a0has downloaded Chatter File from Organization.<\/span><\/p>\n

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.<\/p>\n

In CRM Content, You can see name of users like below image :<\/p>\n

\"Salesforce<\/a>
Salesforce Content File Downloaded information<\/figcaption><\/figure>\n

But, What if file is not in CRM Content ? It is shared as part of Chatter ?<\/p>\n

Open your chatter file, Which you want to track and click on “Show All Version”.<\/p>\n

\"Chatter<\/a>
Chatter File Show All Version<\/figcaption><\/figure>\n

Copy URL of all Versions Some Where, like in Notepad by clicking on icon and “Right Click \u2013 Copy URL”<\/p>\n

\"Copy<\/a>
Copy Chatter File URL<\/figcaption><\/figure>\n

URL will look like :
\nhttps:\/\/shivasoft — .ap1.content.force.com\/sfc\/servlet.shepherd \/version\/download\/06890000000q6pp<\/strong><\/span>?asPdf=false&operationContext=CHATTER<\/a><\/p>\n

Now, Get ID from these URLS. In Our case we have 2 versions so we have 2 Ids.<\/p>\n

Use below SOQL either in Dataloader or Developer Console :<\/p>\n

SELECT ContentVersionId, Field, CreatedById,CREATEDDATE FROM\u00a0ContentVersionHistory<\/strong> WHERE ContentVersionId IN (‘06890000000ox07′,’06890000000q6pp’<\/strong> ) AND Field=’contentVersionDownloaded<\/strong>‘<\/p><\/blockquote>\n

As you can see, We are using ContentVersionHistory<\/strong> table to extract file downloaded information.<\/p>\n

\"Salesforce<\/a>
Salesforce SOQL Developer Console Output<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

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 \u00a0has downloaded Chatter File from Organization. There is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[9],"tags":[55,56,62,63,77,331,185],"class_list":["post-3608","post","type-post","status-publish","format-standard","hentry","category-salesforce","tag-chatter","tag-chatter-files","tag-content","tag-contentversionhistory","tag-developer-console","tag-salesforce","tag-soql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":4942,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-winter-16-top-features\/","url_meta":{"origin":3608,"position":0},"title":"Salesforce Winter 16 – Top features","author":"Jitendra","date":"October 28, 2015","format":false,"excerpt":"You can watch recording of my live stream channel as well to know more on Winter 16 features.\u00a0Powerpoint presentation used in livestream can be accessed from here. 1. Object Manager Objects are objects, even if they are standard or custom objects. Salesforce simplified navigation to access Objects, we can access\u2026","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Setup Audit Trail - Salesforce Winter 16","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Setup-Audit-Trail.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Setup-Audit-Trail.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Setup-Audit-Trail.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Setup-Audit-Trail.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":4136,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-spring-15-some-highlighted-features\/","url_meta":{"origin":3608,"position":1},"title":"Salesforce Spring 15 – some highlighted features","author":"Jitendra","date":"December 28, 2014","format":false,"excerpt":"Download PDF version of release notes from here. 1. Import Account \/ Contact from 16 different sources (previously generic csv was only option to import). 2. Salesforce Analytics Query language (SAQL) We already know about SOQL and SOSL. This is new Query language for Analytics cloud to enable ad hoc\u2026","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Case Macro - Spring 15","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2014\/12\/Case-Macro-Spring-15.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2014\/12\/Case-Macro-Spring-15.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2014\/12\/Case-Macro-Spring-15.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2014\/12\/Case-Macro-Spring-15.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":3660,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/chatter-collaboration-in-cloud\/","url_meta":{"origin":3608,"position":2},"title":"Chatter – Collaboration in Cloud","author":"Jitendra","date":"January 10, 2014","format":false,"excerpt":"Few Years back, When Chatter was introduced in Salesforce there were many critics on this product. Many Experienced analyst suggested that why do we need Social application inside enterprise application ? Today, I can't even imagine Salesforce without Chatter. Its more than just Social, Its all about Communication in Team,\u2026","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Developing Applications with Salesforce Chatter","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2014\/01\/Developing-Applications-with-Salesforce-Chatter.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":4618,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/most-frequently-used-code-snippets-for-salesforce-developers-faq-part-21\/","url_meta":{"origin":3608,"position":3},"title":"Salesforce Developers interview questions – Most commonly used code snippets – part 21","author":"Jitendra","date":"July 7, 2015","format":false,"excerpt":"Salesforce interview questions - Most frequently used Apex and visualforce code used by Salesforce developers like \"How to query and abort scheduled job using Apex\", \"Defining VF page as HTML5\", \"Visualforce page as JSON\" , \"Handling colon in element Id for Jquery\" , \"Chatter using Apex\" and many more.","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6581,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/comparing-between-attachment-document-content-library-and-files-in-salesforce\/","url_meta":{"origin":3608,"position":4},"title":"Summary of Attachment, Document, Content Library and Files in Salesforce","author":"Jitendra","date":"July 24, 2018","format":false,"excerpt":"Comparing between Attachment, Document, Content Library and Files in Salesforce","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":31003,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-shield-platform-encryption-complete-guide-setup\/","url_meta":{"origin":3608,"position":5},"title":"Salesforce Shield Platform Encryption: Complete Guide 2026 | Setup, Best Practices & Implementation","author":"Jitendra Zaa","date":"January 7, 2026","format":false,"excerpt":"Master Salesforce Shield Platform Encryption: Complete guide on setup, BYOK, field selection, Classic vs Shield comparison, and best practices.","rel":"","context":"In "Experience"","block_context":{"text":"Experience","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/experience\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/01\/salesforce-shield-platform-encryption-guide-featured-1.png?fit=1200%2C574&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/01\/salesforce-shield-platform-encryption-guide-featured-1.png?fit=1200%2C574&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/01\/salesforce-shield-platform-encryption-guide-featured-1.png?fit=1200%2C574&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/01\/salesforce-shield-platform-encryption-guide-featured-1.png?fit=1200%2C574&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2026\/01\/salesforce-shield-platform-encryption-guide-featured-1.png?fit=1200%2C574&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/3608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=3608"}],"version-history":[{"count":0,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/3608\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=3608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=3608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=3608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}