Skip to main content

Posts

Retrieve SharePoint last modified details using Powershell

Below is a simple script to retrieve the SharePoint webapplication last modified details along with the site/subsite URL and folder size. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $siteInfo = @(); Get-SPWebApplication http://yourwebapplication/ | Get-SPSite -Limit All | Get-SPWeb -Limit All|%{ $web = $_; $listInfo = "" $versionCount = "" $strHomePage = $web.RootFolder.WelcomePage        $WebSize = CalculateFolderSize($Web.RootFolder)        $row = New-Object -TypeName PSObject        $row | Add-Member -Name 'Site' -MemberType Noteproperty -Value $web.Title        $row | Add-Member -Name 'URL' -MemberType Noteproperty -Value $web.Url        $row | Add-Member -Name 'LastModifiedDate' -MemberType Noteproperty -Value $web.LastItemModifiedDate.tostring('dd/MMM/yyyy')        $row | Add-Member -Name 'Size' -MemberType Notepr...

SharePoint Site Permissions page throws "Something Went wrong" error

Thought of  sharing my experience on an issue which I encountered recently that took me 10 hrs! to resolve. To be frank, it consumed an entire day just to understand the issue! Here it goes, We all know that the Pages, Lists, Libraries can be shared with other users using the so called "Site Permissions" settings from the "Site Settings" tab or by directly clicking on the "Share" button. The "Site Permissions" settings can be found under the Site Settings->Users and Permissions. To my surprise, the "Site Permissions" page started showing "Something went wrong" along with a correlation id. It has to be noted that, there was no issue in accessing the "Site Permissions" of the root site and all other subsites. The issue was only with this particular subsite. Following are the workaround tried to resolve the issue. 1. Extract the error message from the correlation id either by searching for it in the UL...

How to Migrate a InfoPath List Form to another List Form in SharePoint 2013

I encountered an issue recently where the Info Path form got published accidentally with improper layout. As we all know that Info Path does not maintain versions and it is impossible to revert to the previous versions.  Luckily I had the back up of the SharePoint list template from where I could open the previous version of the Info path form. Following are the steps I tried to migrate the Info Path form from the back up to the new SharePoint list. 1. Create a new SharePoint list from the list template. 2. Open the newly created list and click on "Customize form" to open the form in Info path designer. 3. Extract the source files by clicking on File->Publish-> Export Source Files. 4. Update the manifest file with the URL, List ID, Content Type ID of the list to which the Info path form has to be published. Steps to update the manifest file: 1. Get the List ID from the URL by clicking on List settings. The List Id would be something like  List=%7B691FF1A0%2...

Search Configuration in SharePoint 2013

How to create and configure a SharePoint Search service application? Following are the basic steps to be carried out for creating a search service application. Create accounts   Create a Search service application   Configure the Search service application Configure the Search service application topology Register a managed account by following these steps. Open the "Central Administration" home page, in the "Quick Launch", click "Security". On the Security page, in the "General Security" section, click "Configure managed accounts". On the "Managed Accounts" page, click "Register Managed Account". On the "Register Managed Account" page, in the "Account Registration" section, type the user name and password that you want to use as credentials for the service account. If you want SharePoint Server 2013 to manage password changes for this account, select the ...

1904 issue when data is extracted from the SharePoint list.

We have an option in SharePoint to export the SharePoint list to an excel.  When a user extracts a report and enable the "user 1904 date system" under Excel Options-> Advanced->When calculating this workbook,  the data columns in the excel would get added by 4 years and 1 day. For example: If the date column has the value 08/03/2019, it would get converted to 09/03/2023. Please click here to know more about the excel date systems. Please follow the steps to correct the shifted dates! Correcting Shifted Dates If you link from or copy dates between workbooks, or if you change the date system for a workbook that already contains dates, the dates may be shifted by four years and one day. You can correct shifted dates by following these steps: 1.     In an empty cell, enter the value 1462. 2.     Select the cell. On the  Edit  menu, click  Copy . Note  In Excel 2007, select the cell, and th...

Hide SharePoint List View based on User Groups

There is a requirement where the users should be allowed to view only the requests raised by them and a particular SharePoint group members should be able to view all the items. We can achieve it using Rest API but a much simpler approach would be to make use of the OOTB features. 1. Please create a view with filter "Created By" is equal to [Me] and make it as the default view. 2. Now navigate to the list view page. Edit Page. Edit web part and check the option "Disable view selector menu" and save the webpart. This would prevent users from selecting the view. In simple words, the user would be able to see only the list items and not the view tab. Now, how to  make all items view visible to the members of a SharePoint group. Please go to the navigation settings and create a link to navigate to the all items view. Set target audience to the particular SharePoint group. Its done! :)

Navigation Settings not found under SharePoint "Look and Feel"

The global navigation can be handled through the navigation settings in SharePoint. The 'Navigation Settings' can be found under Site Settings->Look and Feel. The Navigation Settings would be enabled only if the 'SharePoint Server Publishing Infrastructure'   feature is activated.