Who created list in SharePoint using PowerShell

In this article we can learn, who created the list with name and date using PowerShell.


This script is very useful to know who created the list with created username and created date with time in any environment like Dev, QA and Prod using PowerShell.
Here we are having a list someone created long time back but as of now we don’t know who created this list, using below PowerShell script we can get it easily.

Add-PSSnapin microsoft.sharepoint.powershell
$web = Get-SPWeb "http://dotnetsharepoint.com/sites/sharepoint"
$list = $web.lists["listname"]
$listwhocreated = $list.Author
$listcreateddate = $list.Created
Write-Host "Created User Name:" $listwhocreated
Write-Host "Created Date:" $listcreateddate


SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Adding Certificate into SharePoint Central Administration

 In this article we are able to see, how to add certificate in to our SharePoint.

How to Create Self-Signed Certificate on IIS Server

Go to Central Administration
Click on Manage Trust under Security
Now we can see the existing trusted certifications, click on New in the Ribbon
Enter the name and select the certificate file on the Popup, as shown in the below figure.
Now we will able to see the certificate on the list. We can be access throughout our SharePoint 2013 farm.

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

How to Create Self-Signed Certificate on IIS Server

In this article we are able to see how to create self-signed certificate on IIS Server
When I am creating Provider Hosted app, i need to provide Self-Signed certification. Below steps to create Self-Signed certificate on the IIS of the development machine
                             Go to IIS & Open Server Certificates
    

 Now you can see the list of already existing certificates.
 Click on “Create Self- Signed Certificate” link on the Right panel as shown in the figure.

   
      Enter the name of Certification and Click “Ok”.


                     
Now we can see the certificate on the Server Certificates.

Do an IISRESET.

Now the certificate is ready to bind with web application on the Binding Links.

We will verify the binding links, navigate to IIS and select any web application, click “Bindings..” under Edit Site from the right Pane.

Click on edit, then we can see our certificate under SSL Certificate as shown in below.



SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Import and Export document library in SharePoint PowerShell

In this article we can able to see how to export and import document library using PowerShell, here we need to get all version document modified history and including users.

Now using the below script we are exporting in to our local D drive.

Export-SPWeb http://dotsharepoint.com/sites/SP/Documentsite/ –Path "D:\Documents.cmp" -ItemURL "Shared%20Documents" –IncludeUserSecurity  -IncludeVersions All

Now using the below script we are importing to another SharePoint site

Export-SPWeb http://dotsharepoint.com/sites/SPSite/NewDocuments/ –Path "D:\Documents.cmp" – force  –IncludeUserSecurity



SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

How to get field empty values in SharePoint using PowerShell

In this article we can able to see how to get the empty values in a field with count using PowerShell
We are having list with more than 10k items in that we are have a field with Status, now we have to know for this particular filed having empty values.

Add-PSSnapin microsoft.sharepoint.powershell
$web = Get-SPWeb http://dotnetsharepoint.com/sites/sharepoint
$list = $web.lists["ListName"] 
  $i = 0;
write-host $list
$items = $list.items
 #Go through all items
foreach($item in $items)
{
 $mystring = $item["Status"]
IF([string]::IsNullOrEmpty($mystring))
{
write-host  $item.ID
$i = $i+1
}
 }

Write-host "total final items" $i

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

We tried to delete a list in SharePoint suddenly we got an error message   “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.


Using GUI we are unable to delete the list because of list view threshold for this using PowerShell we disable the list view threshold.

 Add-PSSnapin Microsoft.SharePoint.PowerShell
$web = Get-SPWeb http://dotnetsharepoint.com/sites/sharepoint
$list = $web.Lists["ListName"]
write-host $list
$list.EnableThrottling = $false
$list.Update();

Now we can able to delete the list without any issues.


SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

enter only numbers in text box in SharePoint

In this article we are able to see how to allow to enter only numbers in a Textbox using JQuery/Java Script.
Could not save the list changes to the server SharePoint designer 2013
Disable list throttling SharePoint using PowerShell
We are having a column with name ZIP, in that we are allowing users to enter only numbers, we designed the form and based on the title we are getting the field, using Keydown  function.   we are using the below code .

<script language="javascript" type="text/javascript">
$(document).ready(function() {               
  $('input[title="ZIP"]').bind("keydown", function (event) {
    if ( event.keyCode == 46 || event.keyCode == 8 || event.keyCode == 9 || event.keyCode == 27 || event.keyCode == 13 ||
            
            (event.keyCode == 65 && event.ctrlKey === true) ||

      
            (event.keyCode >= 35 && event.keyCode <= 39)) {
              
              return;
        }
        else {
            
            if (event.shiftKey || (event.keyCode < 48 || event.keyCode > 57) && (event.keyCode < 96 || event.keyCode > 105 )&&(event.keyCode!=190)&&(event.keyCode!=110)) {
                event.preventDefault();
            }
        }
   });

               
});
                </script>



SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM