El Blog de JuanBO

Requirement Display security permissions for site collection, subsites, and lists/libraries in each site. Solution This can be achieved by a simple powershell script. To use it, you must modify the $site variable to point to your site collection. Syntax: <script name>.ps1 | out-file c:\permissions.txt   1: #Add SharePoint PowerShell SnapIn if not already added 2: if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $ null ) { 3: Add-PSSnapin "Microsoft.SharePoint.PowerShell" 4: } 5:   6: #Define variables 7: $site = Get-SPSite "http://<site collection>" 8:   9: #Get all subsites for site collection 10: $web = $site.AllWebs 11:   12: #Loop through each subsite and write permissions 13:   14: foreach ($web in $web) 15: { 16: if (($web.permissions -ne $ null ) -and ($web.hasuniqueroleassignments -eq "True" )) 17: { 18: Write-Output &

  Error: Log Name:      Application Source:        MsiInstaller Date:          27/11/2013 05:04:10 p.m. Event ID:      1004 Task Category: None Level:         Warning Keywords:      Classic User:          NETWORK SERVICE Description: Detection of product '{90140000-104C-0000-1000-0000000FF1CE}', feature 'PeopleILM', component '{1C12B6E6-898C-4D58-9774-AAAFBDFE273C}' failed.  The resource 'C:\Program Files\Microsoft Office Servers\14.0\Service\Microsoft.ResourceManagement.Service.exe' does not exist. Solución: Éste puede ser fácilmente resuelto mediante la asignación de permisos de servicios a la cuenta “NETWORK SERVICE” en la carpeta "'C:\Program Files\Microsoft Office Servers\14.0\" Fuente: http://sharepointsoldiers.wordpress.com/2011/10/29/eventid-1004-cprogram-filesmicrosoft-office-servers14-0servicemicrosoft-resourcemanagement-service-exe-does-not-exist/

After provisioning and starting the User Profile Synchronization Service: Under services FIM Started: You click on User Profile Service Application: You create a new User Profile Service Application and try browsing to the Manage link for the User Profile Service Application, this page might fail with the following error, If you filter on the "User Profiles" category in the ULS Logs, you should see these errors: UserProfileServiceUserStatisticsWebPart:LoadControl failed, Exception: System.IO.FileLoadException: The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager.InitializeIlmClient(String ILMMachineName, Int32 FIMWebClientTimeOut) at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager..ctor(UserProfileApplicationProxy userProfileApplicationProxy, Guid partitionID) at Microsoft.SharePoint.Portal.WebControls.UserProfileServiceSta

Problem You have followed Harbar’s Rational Guide to setting up the User Profile Service Application in SharePoint 2010 but the User Profile Service is still stuck on starting. Solution Ensure that the account you are running the UPS service is a local administrator for the provisioning process. This is normally the farm account which also runs the SharePoint Timer service. You can remove admin rights later. If it is not a local admin, you will need to restart the Timer service after you grant the correct permissions. Log on as the account that will run the User Profile Synchronization service. If the User Profile Service Synchronisation Service is stuck on ‘Starting’: Run SharePoint Management Shell as a farm administrator. Type: stop-spserviceinstance | where { $_.typename -eq “user profile synchronization service” } The User Profile Synchronization service status should now be ‘Stopped’ or ‘Disabled’. Check the Certificates store on the server that runs the User Profile Synchr

Problema SharePoint constantemente pide credenciales de autenticación en los siguientes escenarios: Le pide las credenciales cuando se accede al sitio en el navegador. Le pide las credenciales cuando se abre un documento de SharePoint. Le pide las credenciales después de abrir un documento de SharePoint y tratar de "Guardar como". Causa La causa más probable de su problema es que usted está utilizando un nombre de dominio completo para SharePoint (Por ejemplo, sharepoint.company.com) y la máquina cliente ejecuta Windows 7. De forma predeterminada, Internet Explorer y Webdav asumen que esta dirección se encuentra en Internet y como medida de seguridad, no pasa de forma automática sus credenciales. Solución Si el escenario es el mismo que el anterior, entonces usted tendrá que hacer dos cosas. Añadir FQDN de su servidor SharePoint a sus sitios de confianza o a sitios de la zona intranet. Modificar la configuración del Registro para el servicio WebClient. Añadir F

Problem A service application database was deleted in SQL Server Management Studio. After a while, I noticed errors in the event viewer on the WFE and ULS logs complaining that SharePoint was not able to login to the database that I deleted. Obviously, SharePoint still thought that the database existed so I needed to find a way to remove it. PowerShell to the rescue. Solution Using PowerShell, run the following command: Get-SPDatabase | where {$_.exists -eq $ false } This will list all databases in SharePoint that no longer exist on the database server. If you are happy with the result and wish to remove the orphaned databases, run the following command: Get-SPDatabase | where {$_.exists -eq $ false } | foreach {$_.delete()} All orphaned databases should now be removed and SharePoint should stop complaining about being unable to login to the non-existent database.   Fuente: http://www.mysharepointadventures.com/2012/02/cleaning-up-deleted-databases-in-sharepoint/

Requirement I needed an easy way to automatically document my farm and take snap shots of its configuration periodically for audit purposes. A quick search landed me on this Codeplex project by Jayvijw As you can see from the above screenshot, the report is quite detailed and contains most of the information you would need as an administrator to track configuration changes and restore a farm to its original configuration if you ever have to start from scratch. So I thought, why not use PowerShell and Windows Task Scheduler to give me weekly snapshots of my farm’s configuration? Solution Summary of what the script does Generate the farm configuration report using the 2010SPSFR.exe stored in C:\SharePoint Rename the report html file to our naming convention. Upload the report to a document library in SharePoint. E-mail a copy of the report to the SharePoint administrator. Modify the variables in the script below to suit your environment. You can easily schedule this scri

  Problem: Log Name: Application Source: Microsoft-SharePoint Products-Web Content Management Date: <date> Event ID: 7362 Task Category: Publishing Cache Level: Warning Keywords: User: <username> Computer: <server> Description: Object Cache: The super user account utilized by the cache is not configured. This can increase the number of cache misses, which causes the page requests to consume unneccesary system resources. To configure the account use the following command 'stsadm -o setproperty -propertyname portalsuperuseraccount -propertyvalue account -url webappurl'. The account should be any account that has Full Control access to the SharePoint databases but is not an application pool account. Additional Data: Current default super user account: SHAREPOINT\system Solution Step 1 – Create AD Domain Accounts Create domain accounts for the ‘portalsuperuseraccount’ and ‘portalsuperreaderaccount’. I use sp

  Already have data in a spreadsheet that you want to be a SharePoint 2010 list? You're halfway there! Before you start, make sure you do the following: Clean the list. Make sure your list looks like a table, with no blank columns or rows. Make sure your list has headers. All columns should have a column title. Make sure your column data is consistent. For example, if a column has a comment in what would otherwise be a Date column, remove the text. Make sure your first row is representative of the rest of the data. SharePoint reads that first row and makes assumptions about the information in that column. Here is an example of a clean spreadsheet ready for importing. TIP : SharePoint looks for what it believes is the first text column and uses it as the pseudo-title field (the primary field in the list that has the Edit menu attached to it). Therefore, try to place a text field with unique data in the first column position. Unfortunately, if your unique field is a nu

  Recientemente me he visto en la obligación de tener que migrar una lista con datos sensibles de una instalación en Sharepoint 2007 a una instalación nueva en Sharepoint 2010. Bien, primero un poco de teoría, después explicaré en profundidad y con detalle la práctica. Después de dar muchas vueltas por Internet y no encontrar información al respecto, he descubierto las siguientes verdades a medida que he intentado métodos para pasar los datos: Las exportaciones de listas (*.STP) de SP2007 no son compatibles con SP2010. Es decir, no se puede importar y exportar y listo. El SPMetal de SP2010 no genera las clases de un site de SP2007. Es decir, no se puede utilizar LINQ desde VS2010 para hacer un proceso o un webpart que haga la importación. Sí se puede conectar al WebService de SP2007 ( http://TuServidor/sites/TuSubSite/_vti_bin/Lists.asmx ) desde VS2010 y utilizar los métodos de que dispone el servicio para obtener los datos, guardarlos en colecciones y después subirlos, o bien con las

  Symptoms: When you try to start User Profile Synchronization (Full/Incremental) or start the "User Profile Synchronization Service" found under "Services on server" in SharePoint 2010, you receive an error "An update conflict has occurred, and you must re-try this action. The object UserProfileApplication Name=User Profile Service Application was updated by [User]" Full details about this error as it is logged in various places has been detailed below: ULS: ConcurrencyException: Old Version : 241817 New Version : 241817 99a7a04b-0297-4ecc-9621-a38b05c8ccce Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException: An update conflict has occurred, and you must re-try this action. The object UserProfileApplication Name=User Profile Service Application was updated by [User], in the OWSTIMER (3456) process, on machine [Server Name] ULS: SharePoint Foundation Runtime Unexpected Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException: