European Sharepoint 2013 Hosting Blog

SharePoint 2013 Hosting – HostForLIFE.eu :: Restore SharePoint Item From Recycle Bin Using PowerShell

Apr 19th

Posted by Peter in European SharePoint 2013 Hosting

This blog may help you to restore multiple items from the SharePoint Recycle Bin by using PowerShell. Traditionally SharePoint has had the option to restore multiple files from the recycle bin but this will not help in all cases, because Microsoft recommends that only 200 items can be restored at a time.

Just consider, one user has deleted more than 20K documents accidently from SharePoint and they are trying to restore then from the recycle bin, but as per the Microsoft recommendation they can restore only 200 items at a time, so just calculate how long it will take to restore all 20K documents. I will take more than an hour to restore all deleted items.

So here we are going to restore the deleted items from the recycle bin using CSOM (Client -Side Object Model) with the help of PowerShell.

Let’s see the PowerShell Code, before that we need to download the SharePoint Online Client Components SDK from Microsoft.

First add the SharePoint Client dll’s for reference,

     Clear - Host  
    Add - Type - Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"  
    Add - Type - Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"#  
    Get the Site Collection URL  
    $SiteUrl = Read - host "Enter the Site URL"  
    #Get the Site Owners Credentials to connect the SharePoint  
    $UserName = Read - host "Enter the Email ID"  
    $Password = Read - host - assecurestring "Enter Password for $AdminUserName"  
    $Credentials = New - Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName, $Password)  
    # Once Connected, get the Site information using current Context objects  
    Try {  
        $Context = New - Object Microsoft.SharePoint.Client.ClientContext($SiteUrl)  
        $Context.Credentials = $Credentials  
        $Site = $Context.Site  
        $RecycleBinItems = $Site.RecycleBin  
        $Context.Load($Site)  
        $Context.Load($RecycleBinItems)  
        $Context.ExecuteQuery()  
        # The above code will help to retrieve all items from the recycle bin on below table format  
        $RecycleBinItems | Select Title, DeletedByEmail, DeletedDate, ItemType, ItemState | Format - Table - AutoSize  
        # You can export the List in CSV format using Out - file command  
    } catch {  
        write - host "Error: $($_.Exception.Message)" - foregroundcolor Red  
    }#Once exported, you can use below code to  
    import the CSV file and get the item restored one by one  
    $Location = Read - Host "Enter the CSV file path with filename and extension"  
    $file = Import - Csv $Location  
    $importitemcount = $file.Count  
    # using for loop to restore the item one by one  
    For($i = 0; $i - le $importitemcount; $i++) {  
        $itemsre = $file[$i].Title  
        $Restoreitem = $RecycleBinItems | Where - Object {  
            $_.Title - eq $itemsre  
        }  
        $Restoreitem | % {  
            $_.Restore()  
        }  
        $Context.ExecuteQuery()  
        Write - Host $itemsre "Restored" - ForegroundColor Yellow  
    }

Clear - Host

Add - Type - Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"

Add - Type - Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"#

Get the Site Collection URL

$SiteUrl = Read - host "Enter the Site URL"

#Get the Site Owners Credentials to connect the SharePoint

$UserName = Read - host "Enter the Email ID"

$Password = Read - host - assecurestring "Enter Password for $AdminUserName"

$Credentials = New - Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName, $Password)

# Once Connected, get the Site information using current Context objects

Try {

$Context = New - Object Microsoft.SharePoint.Client.ClientContext($SiteUrl)

$Context.Credentials = $Credentials

$Site = $Context.Site

$RecycleBinItems = $Site.RecycleBin

$Context.Load($Site)

$Context.Load($RecycleBinItems)

$Context.ExecuteQuery()

# The above code will help to retrieve all items from the recycle bin on below table format

$RecycleBinItems | Select Title, DeletedByEmail, DeletedDate, ItemType, ItemState | Format - Table - AutoSize

# You can export the List in CSV format using Out - file command

} catch {

write - host "Error: $($_.Exception.Message)" - foregroundcolor Red

}#Once exported, you can use below code to

import the CSV file and get the item restored one by one

$Location = Read - Host "Enter the CSV file path with filename and extension"

$file = Import - Csv $Location

$importitemcount = $file.Count

# using for loop to restore the item one by one

For($i = 0; $i - le $importitemcount; $i++) {

$itemsre = $file[$i].Title

$Restoreitem = $RecycleBinItems | Where - Object {

$_.Title - eq $itemsre

}

$Restoreitem | % {

$_.Restore()

}

$Context.ExecuteQuery()

Write - Host $itemsre "Restored" - ForegroundColor Yellow

}

By the same method, you can filter the recycle bin items by ItemName, DeletedBy, ItemState, ItemType like below, Just replace line number 26 from the above script:

$DeletedByUser = Get-Host “Enter the Deleted By user ID”
$DeletedByUser = $RecycleBinItems | Where {$_.DeletedByEmail -eq $DeletedByUserAccount} | Format-Table

SharePoint 2013 Hosting – HostForLIFE.eu :: Console Application To Fetch SharePoint List Data Using REST API With CAML Query In C# Managed Code

Apr 12th

Posted by Peter in Other Related Post

No comments

SharePoint 2013 has many restful APIs to fetch the data from lists. However, sometimes, we need to use a CAML query to filter out the data. SharePoint Rest API has an option to pass a CAML query as data to an API call. The below steps will help you to call a Rest API with CAML query filtering. In addition, this article will help you to understand how to call REST API POST methods in console applications using C# managed code. The below example calls a REST API to retrieve the data from Department SharePoint list. Department list has a Title column, which refers to the department name. CAML query will be used to filter the Department list data by Title (Department name).

REST endpoint /_api/web/lists/getbytitle(‘Department’)/GetItems CAML Query Structure CAML query structure should be strictly followed as below: <View><Query> <CAML_Query> </Query></View> Assembly References

Net: To make a request to a Uniform Resource Identifier (URI).
Web.Script.Serialization: For serialization and deserialization functionality
IO: For reading and writing streams.

Request Header for POST Request The API endpoint is of type POST. Hence, the REST header should be same as other post requests,

oWebRequest.Accept = “application/json;odata=verbose”;
oWebRequest.ContentType = “application/json;odata=verbose”;
oWebRequest.Headers.Add(“X-RequestDigest”, GetFormDigest());
oWebRequest.ContentLength = stringData.Length;

Steps Please follow the below steps to create a console application:

Open Visual Studio.

Select Console Application template and provide a suitable name.

Add required assemblies.

Add the below code in Program.cs file.

Run the code.

    using System;  
    using System.Collections.Generic;  
    using System.IO;  
    using System.Net;  
    using System.Web.Script.Serialization;  
      
    namespace ConsoleApp1  
    {  
        class Program  
        {  
           
            static void Main(string[] args)  
            {  
                string sConnStr = "<web_url>";  
                Uri oUri = null;  
                oUri = new Uri(sConnStr + "/_api/web/lists/getbytitle('Department')/GetItems");  
      
                string sResult = string.Empty;  
      
                string stringData = "{'query' : {'__metadata': { 'type': 'SP.CamlQuery' }, 'ViewXml':'<View><Query><Where><Eq><FieldRef Name =\"Title\"/><Value Type=\"Text\">HR</Value></Eq></Where></Query></View>'}}";  
      
                HttpWebRequest oWebRequest = (HttpWebRequest)WebRequest.Create(oUri);  
                oWebRequest.Credentials = CredentialCache.DefaultNetworkCredentials;  
                oWebRequest.Method = "POST";  
                oWebRequest.Accept = "application/json;odata=verbose";  
                oWebRequest.ContentType = "application/json;odata=verbose";  
                oWebRequest.Headers.Add("X-RequestDigest", GetFormDigest());  
                oWebRequest.ContentLength = stringData.Length;  
      
                StreamWriter writer = new StreamWriter(oWebRequest.GetRequestStream());  
                writer.Write(stringData);  
                writer.Flush();  
      
                WebResponse wresp = oWebRequest.GetResponse();  
                using (StreamReader sr = new StreamReader(wresp.GetResponseStream()))  
                {  
                    sResult = sr.ReadToEnd();  
                }  
            }  
            public static string GetFormDigest()  
            {  
                string sFormDigest = null;  
                string sConnStr = "<web_url>";  
                Uri oUri = null;  
                oUri = new Uri(sConnStr + "/_api/contextinfo");  
                  
                HttpWebRequest oWebRequest = HttpWebRequest.Create(oUri) as HttpWebRequest;  
                oWebRequest.UseDefaultCredentials = true;  
                oWebRequest.Method = "POST";  
                oWebRequest.Accept = "application/json;odata=verbose";  
                oWebRequest.ContentLength = 0;  
                oWebRequest.ContentType = "application/json";  
                string sResult;  
                WebResponse sWebReponse = oWebRequest.GetResponse();  
      
                using (StreamReader sr = new StreamReader(sWebReponse.GetResponseStream()))  
                {  
                    sResult = sr.ReadToEnd();  
                }  
      
                var jss = new JavaScriptSerializer();  
                var val = jss.Deserialize<Dictionary<string, object>>(sResult);  
                var d = val["d"] as Dictionary<string, object>;  
                var wi = d["GetContextWebInformation"] as Dictionary<string, object>;  
                sFormDigest = wi["FormDigestValue"].ToString();  
      
                return sFormDigest;  
      
            }  
        }  
    }

using System;

using System.Collections.Generic;

using System.IO;

using System.Net;

using System.Web.Script.Serialization;

namespace ConsoleApp1

{

class Program

{

static void Main(string[] args)

{

string sConnStr = "<web_url>";

Uri oUri = null;

oUri = new Uri(sConnStr + "/_api/web/lists/getbytitle('Department')/GetItems");

string sResult = string.Empty;

string stringData = "{'query' : {'__metadata': { 'type': 'SP.CamlQuery' }, 'ViewXml':'<View><Query><Where><Eq><FieldRef Name =\"Title\"/><Value Type=\"Text\">HR</Value></Eq></Where></Query></View>'}}";

HttpWebRequest oWebRequest = (HttpWebRequest)WebRequest.Create(oUri);

oWebRequest.Credentials = CredentialCache.DefaultNetworkCredentials;

oWebRequest.Method = "POST";

oWebRequest.Accept = "application/json;odata=verbose";

oWebRequest.ContentType = "application/json;odata=verbose";

oWebRequest.Headers.Add("X-RequestDigest", GetFormDigest());

oWebRequest.ContentLength = stringData.Length;

StreamWriter writer = new StreamWriter(oWebRequest.GetRequestStream());

writer.Write(stringData);

writer.Flush();

WebResponse wresp = oWebRequest.GetResponse();

using (StreamReader sr = new StreamReader(wresp.GetResponseStream()))

{

sResult = sr.ReadToEnd();

}

public static string GetFormDigest()

{

string sFormDigest = null;

string sConnStr = "<web_url>";

Uri oUri = null;

oUri = new Uri(sConnStr + "/_api/contextinfo");

HttpWebRequest oWebRequest = HttpWebRequest.Create(oUri) as HttpWebRequest;

oWebRequest.UseDefaultCredentials = true;

oWebRequest.Method = "POST";

oWebRequest.Accept = "application/json;odata=verbose";

oWebRequest.ContentLength = 0;

oWebRequest.ContentType = "application/json";

string sResult;

WebResponse sWebReponse = oWebRequest.GetResponse();

using (StreamReader sr = new StreamReader(sWebReponse.GetResponseStream()))

{

sResult = sr.ReadToEnd();

}

var jss = new JavaScriptSerializer();

var val = jss.Deserialize<Dictionary<string, object>>(sResult);

var d = val["d"] as Dictionary<string, object>;

var wi = d["GetContextWebInformation"] as Dictionary<string, object>;

sFormDigest = wi["FormDigestValue"].ToString();

return sFormDigest;

}

Code Explanation

The complete data to be passed in the request will be:
1. “{‘query’ : {‘__metadata’: { ‘type’: ‘SP.CamlQuery’ }, ‘ViewXml’:'<View><Query><Where><Eq><FieldRef Name =\”Title\”/><Value Type=\”Text\”>HR</Value></Eq></Where></Query></View>’}}”;

Form Digest need to be passed while calling post method. GetFormDigest() returns the required request digest.

Summary In this article, we have explored how to call SharePoint REST API with CAML query in C# console application. The CAML query can also be passed through the URL itself. However, this makes the API URL complicated and sometimes, restricts the length of the URL. The same code can be used in implementing custom APIs as well.

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Save Button On Custom SharePoint List Forms?

Apr 5th

Posted by Peter in European SharePoint 2013 Hosting

No comments

We have already discussed in our previous blog, how to make a custom list form using Sharepoint Designer. Now, we will create custom buttons that will save data to a Sharepoint list without writing any code in REST or JSOM. Now, go to Sharepoint Designer and open the custom new form that we have created from the forms gallery of the list in Sharepoint Designer as shown below.

Click on CustomNewForm.aspx and this would open the aspx code of the CustomNewForm in Sharepoint designer.

The custom new form looks like below in the browser.

As you can see, there are two Save Buttons on the form.

To remove the Save buttons on the top find the below piece of code,

<table>  
    <tr>  
        <td width="99%" class="ms-toolbar" nowrap="nowrap">  
            <IMG SRC="/_layouts/15/images/blank.gif" width="1" height="18" />  
        </td>  
        <td class="ms-toolbar" nowrap="nowrap">  
            <SharePoint:SaveButton runat="server" ControlMode="New" id="savebutton1" /> </td>  
        <td class="ms-separator"> </td>  
        <td class="ms-toolbar" nowrap="nowrap" align="right">  
            <SharePoint:GoBackButton runat="server" ControlMode="New" id="gobackbutton1" /> </td>  
    </tr>  
</table>

<table>

<tr>

</td>

<SharePoint:SaveButton runat="server" ControlMode="New" id="savebutton1" /> </td>

<SharePoint:GoBackButton runat="server" ControlMode="New" id="gobackbutton1" /> </td>

</tr>

</table>

And add the highlighted code as below.

<table>  

        <tr style="display:none">  
            <td width="99%" class="ms-toolbar" nowrap="nowrap">  
                <IMG SRC="/_layouts/15/images/blank.gif" width="1" height="18" />  
            </td>  
            <td class="ms-toolbar" nowrap="nowrap">  
                <SharePoint:SaveButton runat="server" ControlMode="New" id="savebutton1" /> </td>  
            <td class="ms-separator"> </td>  
            <td class="ms-toolbar" nowrap="nowrap" align="right">  
                <SharePoint:GoBackButton runat="server" ControlMode="New" id="gobackbutton1" /> </td>  
        </tr>  
    </table>

<table>

</td>

<SharePoint:SaveButton runat="server" ControlMode="New" id="savebutton1" /> </td>

<SharePoint:GoBackButton runat="server" ControlMode="New" id="gobackbutton1" /> </td>

</tr>

</table>

This will hide the above save button on the form so the new custom form looks like this.

Now add the following code to add the custom button and use OOTB Sharepoint functionality to save the data in the Sharepoint list.

<tr>  
    <td> <button type="button" value="Save And Exit" name="btnSave" onclick="javascript:{ddwrt:GenFireServerEvent('__commit;__redirect={/teams/******/Pages/Home.aspx}')};">Save And Exit</button> </td>  
</tr>

<tr>

</tr>

Now, the form will have a custom button Save and Exit which will save the data in a sharepoint list just like OOTB sharepoint button.

Advantages of custom Button

We can redirect the page anywhere we like after saving data in the list.
We can run custom code by calling a javascript function (Discuss in next blog) to run validations and set values based on button click which is not possible in PreSaveAction functionality (to be discussed in the next blog)
No need to write custom Rest or JSOM code to save data.

Hope this is helpful. Feel free to post comments if you have any query.

SharePoint 2013 Hosting – HostForLIFE.eu :: Export Only SharePoint Filtered List Items To Excel

Mar 29th

Posted by Peter in European SharePoint 2013 Hosting

No comments

This article demonstrates how to export SharePoint Filtered list items to Excel. SharePoint gives an option out of the box to export SharePoint views directly, however, if we apply any filter on the SharePoint view and then export the SharePoint list then instead of the filtered view we get all the results in the view in Excel. Hence, to just get those filtered items in Excel we add a content editor web part and link it with our code to export filtered items.

To export only filtered list items in a SharePoint view to Excel

Firstly create a .txt file and paste the following code in the txt file. You can name the file as ExportToExcel.txt.

<script src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-3.3.1.min.js"></script>  
<script>  
    function fnExcelReport() {  
        $('.ms-listviewtable').css({  
            'border-collapse': 'collapse',  
            'border': '1px solid #ddd'  
        });  
        $('.ms-listviewtable tr td').css({  
            'border': '1px solid #ddd'  
        });  
        var tab_text = $('.ms-listviewtable')[0].outerHTML;  
        debugger;  
        $(tab_text).find("tr td:first-child").remove();  
        tab_text = tab_text.replace(/<A[^>]*>|<\/A>/g, ""); //remove if u want links in your table  
        tab_text = tab_text.replace(/<img[^>]*>/gi, ""); // remove if u want images in your table  
        tab_text = tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params  
        var ua = window.navigator.userAgent;  
        var msie = ua.indexOf("MSIE ");  
        if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) // If Internet Explorer  
        {  
            txtArea1.document.open("txt/html", "replace");  
            txtArea1.document.write(tab_text);  
            txtArea1.document.close();  
            txtArea1.focus();  
            sa = txtArea1.document.execCommand("SaveAs", true, "ActionPoints.xls");  
        } else //other browser not tested on IE 11  
            tab_text = excelExportHtml(tab_text, true)  
        sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));  
        return (sa);  
    }  
  
    function excelExportHtml(table, includeCss) {  
        var html = "<html><head>";  
        html += "</head><body>" + table + "</body></html>";  
        return html;  
    }  
</script>  
  
<body> <input type="button" value="Export To Excel" onclick="fnExcelReport();" /> <iframe id="txtArea1"></iframe> </body>

function fnExcelReport() {

$('.ms-listviewtable').css({

'border-collapse': 'collapse',

'border': '1px solid #ddd'

});

$('.ms-listviewtable tr td').css({

'border': '1px solid #ddd'

});

var tab_text = $('.ms-listviewtable')[0].outerHTML;

debugger;

$(tab_text).find("tr td:first-child").remove();

tab_text = tab_text.replace(/<A[^>]*>|<\/A>/g, ""); //remove if u want links in your table

tab_text = tab_text.replace(/<img[^>]*>/gi, ""); // remove if u want images in your table

tab_text = tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params

var ua = window.navigator.userAgent;

var msie = ua.indexOf("MSIE ");

if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) // If Internet Explorer

{

txtArea1.document.open("txt/html", "replace");

txtArea1.document.write(tab_text);

txtArea1.document.close();

txtArea1.focus();

sa = txtArea1.document.execCommand("SaveAs", true, "ActionPoints.xls");

} else //other browser not tested on IE 11

tab_text = excelExportHtml(tab_text, true)

sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));

return (sa);

}

function excelExportHtml(table, includeCss) {

var html = "<html><head>";

html += "</head><body>" + table + "</body></html>";

return html;

}

</script>

Now, upload this file to Site Assets library in SharePoint.

Go to the list view in SharePoint where you would like to filter the list view and then click on Edit Page as shown in the screenshot below.

Then, click on Add a Web part >> Media And Content >> Content Editor and then click on Add button as shown in the image below.

After adding the web part click on the Down Arrow and then click on Edit Web Part as shown in the screenshot below.

Scroll to the right of the page and in the Content Link property paste the link of the txt file that was uploaded to the Site Assets Gallery, namely ExporttoExcel.txt and then click OK.

Now, you will see Export to Excel button on the list. Now if you filter the list and then click on “Export to Excel” button Excel will be downloaded with only filtered view records that are visible on the screen. In this article, we discussed how we can export SharePoint Filtered Items to Excel. This is of great help as we can directly export filtered view items which are currently not provided by SharePoint out of the box features.

SharePoint 2013 Hosting – HostForLIFE.eu :: Testing SPFx Web Part Project

Mar 22nd

Posted by Peter in European SharePoint 2013 Hosting

No comments

To preview the web part(s) on the browser, use the following commands

gulp trust-dev-cert
gulp serve

This will install a certificate and compile, build and run the application.

Once the “gulp serve” is successful, gulp compiles and opens local workbench.

SPFx Web part -Debugging – Logic
In SharePoint workbench, you can try to understand and debug the web part in the browser developer tool.

When gulp is running, and any change is saved in the project, gulp automatically compiles and builds the new code.

Once it is compiled, the latest code is available in the browser workbench developer tools window.

Classic SharePoint page

Alternatively, we can also debug/execute our local solution in SharePoint existing pages/web parts by appending the below query string onto the page URL in browser.

?loadSPFX=true&debug=true&enableconsolelog=true&forceAssembly=true&noredir=true&debugManifestsFile=https://localhost:4321/temp/manifests.js

It will open the “Allow Debug Manifests?” window. Click on “Load debug scripts” to run local solution.

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Search Script in SharePoint 2013?

Mar 15th

Posted by Peter in European SharePoint 2013 Hosting

No comments

This article will explain the PowerShell script that searches for files within document libraries in SharePoint (farm level, site collection level, web level etc.) based on the search parameters you provide. It can also be used for searching in SharePoint for any files with specified extension. The results are returned in .CSV format.

Examples of scenarios

Search the entire farm for files that have names like “Training Copy”.
Search the site collection http://sharepoint.mydreambox.com/sites/site1 for all PDF files, RDL files, etc.
Search the web http://sharepoint.mydreambox.com/sites/site1/web1 for the file named “AXL8rt.docx”, etc.

Usage of the Script

Replace the $webApp, $sites, etc. with appropriate values
Replace the $searchKey with the desired search queries or file extension that is to be searched for
Make sure the account that is running these scripts have necessary privileges in SharePoint

Script use cases

The code is presented for four different cases,

Searching for an entire farm
Searching within a web application
Searching within a site collection
Searching within a web

Output

The output will be in the form of a CSV file, as displayed below. It will contain all the file location URLs.

Case I – For searching within the entire farm

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}

$sites = Get-SPSite -Limit All
$searchKey = ".rdl"
$results = @()

foreach ($site in $sites)
{
foreach ($web in $site.AllWebs)
{
Write-Host Searching within $web.Url
foreach ($list in $web.Lists)
{
if($list.BaseType -eq "DocumentLibrary")
{
foreach($item in $list.Items)
{
if($item.Name.Contains($searchKey))
{
$RowDetails = @{
“File Location” = $web.Url + "/" + $item.Url
}
$results += New-Object PSObject –Property $RowDetails
}
}
}
}
}
}
$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

Case II - For searching within a Web Application

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}

$webApp = "http://sharepoint.dreambox.com"
$sites = Get-SPSite -WebApplication $webApp -Limit All
$searchKey = "Self Improvement"
$results = @()

foreach ($site in $sites)
{
foreach ($web in $site.AllWebs)
{
Write-Host Searching within $web.Url
foreach ($list in $web.Lists)
{
if($list.BaseType -eq "DocumentLibrary")
{
foreach($item in $list.Items)
{
if($item.Name.Contains($searchKey))
{
$RowDetails = @{
“File Location” = $web.Url + "/" + $item.Url
}
$results += New-Object PSObject –Property $RowDetails

}
}
}
}
}
}
$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

$sites = Get-SPSite -Limit All

$searchKey = ".rdl"

$results = @()

foreach ($site in $sites)

{

foreach ($web in $site.AllWebs)

{

Write-Host Searching within $web.Url

foreach ($list in $web.Lists)

{

if($list.BaseType -eq "DocumentLibrary")

{

foreach($item in $list.Items)

{

if($item.Name.Contains($searchKey))

{

$RowDetails = @{

“File �� = $web.Url + "/" + $item.Url

}

$results += New-Object PSObject –Property $RowDetails

}

$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

Case II - For searching within a Web Application

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

$webApp = "http://sharepoint.dreambox.com"

$sites = Get-SPSite -WebApplication $webApp -Limit All

$searchKey = "Self Improvement"

$results = @()

foreach ($site in $sites)

{

foreach ($web in $site.AllWebs)

{

Write-Host Searching within $web.Url

foreach ($list in $web.Lists)

{

if($list.BaseType -eq "DocumentLibrary")

{

foreach($item in $list.Items)

{

if($item.Name.Contains($searchKey))

{

$RowDetails = @{

“File �� = $web.Url + "/" + $item.Url

}

$results += New-Object PSObject –Property $RowDetails

}

$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

Case III – For searching within a Site Collection

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}

$site = Get-SPSite “http://sharepoint.dreambox.com/sites/site1”
$searchKey = ".docx"
$results = @()


foreach ($web in $site.AllWebs)
{
Write-Host Searching within $web.Url
foreach ($list in $web.Lists)
{
if($list.BaseType -eq "DocumentLibrary")
{
foreach($item in $list.Items)
{
if($item.Name.Contains($searchKey))
{
$RowDetails = @{
“File Location” = $web.Url + "/" + $item.Url
}
$results += New-Object PSObject –Property $RowDetails

}
}
}
}
}
$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

$site = Get-SPSite “http://sharepoint.dreambox.com/sites/site1”

$searchKey = ".docx"

$results = @()

foreach ($web in $site.AllWebs)

{

Write-Host Searching within $web.Url

foreach ($list in $web.Lists)

{

if($list.BaseType -eq "DocumentLibrary")

{

foreach($item in $list.Items)

{

if($item.Name.Contains($searchKey))

{

$RowDetails = @{

“File �� = $web.Url + "/" + $item.Url

}

$results += New-Object PSObject –Property $RowDetails

}

$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

Case IV – For searching within a Web

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}

$web = Get-SPWeb “http://sharepoint.dreambox.com/sites/site1/web1”
$searchKey = ".pdf"
$results = @()

foreach ($list in $web.Lists)
{
if($list.BaseType -eq "DocumentLibrary")
{
foreach($item in $list.Items)
{
if($item.Name.Contains($searchKey))
{
$RowDetails = @{
“File Location” = $web.Url + "/" + $item.Url
}
$results += New-Object PSObject –Property $RowDetails
}
}
}
}

$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

$web = Get-SPWeb “http://sharepoint.dreambox.com/sites/site1/web1”

$searchKey = ".pdf"

$results = @()

foreach ($list in $web.Lists)

{

if($list.BaseType -eq "DocumentLibrary")

{

foreach($item in $list.Items)

{

if($item.Name.Contains($searchKey))

{

$RowDetails = @{

“File �� = $web.Url + "/" + $item.Url

}

$results += New-Object PSObject –Property $RowDetails

}

$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

SharePoint 2013 Hosting – HostForLIFE.eu :: Restore SharePoint Item From Recycle Bin Using PowerShell

SharePoint 2013 Hosting – HostForLIFE.eu :: Console Application To Fetch SharePoint List Data Using REST API With CAML Query In C# Managed Code

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Save Button On Custom SharePoint List Forms?

SharePoint 2013 Hosting – HostForLIFE.eu :: Export Only SharePoint Filtered List Items To Excel

SharePoint 2013 Hosting – HostForLIFE.eu :: Testing SPFx Web Part Project

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Search Script in SharePoint 2013?

BLOGROLL

Featured On

European Sharepoint 2013 Hosting Blog

SharePoint 2013 Hosting – HostForLIFE.eu :: Restore SharePoint Item From Recycle Bin Using PowerShell

SharePoint 2013 Hosting – HostForLIFE.eu :: Console Application To Fetch SharePoint List Data Using REST API With CAML Query In C# Managed Code

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Save Button On Custom SharePoint List Forms?

SharePoint 2013 Hosting – HostForLIFE.eu :: Export Only SharePoint Filtered List Items To Excel

SharePoint 2013 Hosting – HostForLIFE.eu :: Testing SPFx Web Part Project

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Search Script in SharePoint 2013?

BLOGROLL

Featured On

Tags