Disclaimer . . .

We DO NOT host or upload any of the videos or any other content that are available on this Weblog. We merely search on INTERNET and index popular files/links to other blogs /videos openly available to anyone. The most popular websites are YOUTUBE videos. These videos and other content are uploaded to the respective websites by their User Communities from all over the World and NOT by us. Please Contact Us through E-Mail, if you feel that any Content including Videos on this Weblog are objectionable or violating your copyrights. The objectionable content shall be promptly removed from our Weblog.


Jul 1, 2016

SharePoint - SQL query to find SSRS reports

Use database_name
SELECT [DirName],[LeafName]    
 FROM [dbo].[AllDocs] (nolock) where Extension='rdl'
GO

Note: You can replace file type from rdl to doc,docx, xlsx etc.. to find different documents with file types. You can modify query to count for total etc..
Create and build power shell commands for SharePoint
Powershell Command builder:

http://www.microsoft.com/resources/TechNet/en-us/Office/media/WindowsPowerShell/WindowsPowerShellCommandBuilder.html