Unable to send Alerts to a user or Group

Issue

Whenever you add a user or  group to alerts section in a library\list. Alerts are not getting delivered when anything is changed.

Resolution

Make sure those groups are added in the Library\Lists permissions. They should atleast have read access to get the alerts.

Unable to add DL to sharepoint permissions

Issue
 whenever you try to add a DL to sharepoint permissions, it doesn't resolve and gives an error

Resolution
 If you want to add any DL to the sharepoint permissions, it should be converted to Security Groups. As soon as that is converted to Security Group it will be resolved in the permissions section and users will be able to access the site.

Note: If those DL's are having SUB DL's inside it , then they should also be converted to Security Groups.

Export SharePoint Permissions to Excel

I have seen multiple requests from the users asking to Export SharePoint permissions to Excel Sheet. Now there is a way to export it from sharepoint 


To do this , you will have to Open Excel Sheet , Navigate to Data Tab – Click on "From Web", as shown in the below Screen shot





Once You click on that , it will bring up a New Web Query pop up Box, You will have to Enter the URL and Select the check boxes Highlighted in yellow to import it in Excel.





Select the desired users, Click on Import and Voila . All the users imported.


Hope this Helps.