jueves, 1 de septiembre de 2016

Set retention period for Usage definitions

Here's a sample script that will set the retention period to three days:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
Set-SPUsageDefinition -Identity "Sandboxed Requests" -DaysRetained 3
Set-SPUsageDefinition -Identity "Content Import Usage" -DaysRetained 3
Set-SPUsageDefinition -Identity "Workflow" -DaysRetained 3
Set-SPUsageDefinition -Identity "Clickthrough Usage" -DaysRetained 3
Set-SPUsageDefinition -Identity "Content Export Usage" -DaysRetained 3
Set-SPUsageDefinition -Identity "Page Requests" -DaysRetained 3
Set-SPUsageDefinition -Identity "Feature Use" -DaysRetained 3
Set-SPUsageDefinition -Identity "Search Query Usage" -DaysRetained 3
Set-SPUsageDefinition -Identity "Site Inventory Usage" -DaysRetained 3
Set-SPUsageDefinition -Identity "Sandboxed Requests Monitored Data" -DaysRetained 3
Set-SPUsageDefinition -Identity "Timer Jobs" -DaysRetained 3
Set-SPUsageDefinition -Identity "Rating Usage" -DaysRetained 3

When a file can't be check-out / check-in or deleted because is locked from someone


This is the time, when you can do magic via PowerShell..!

The PS script to unlock your file is this one:

$web = get-spweb "SITE URL"
$list = $web.Lists["LIST NAME "]
$item = $list.Items.GetItemById(DOCUMENT ID)

$web = get-spweb "https://abcde.com/team/IT/SharePoint/"
$list = $web.Lists["Documents"]
$item = $list.Items.GetItemById(225)

There are different ways to find the DOC ID, however the easy way is adding in your VIEW (list/library) the column named ID.


miércoles, 31 de agosto de 2016

Recreating the User Profile Service application using the old databases


Recently I have been doing some testing about the User Profile service application, and I had some issues with this picky service. I tried to fix it, but the only way to solve this is deleting the current UPA and creating one from scratch.

Guess what!!... Some users have information at MySite.. So I can't delete the content databases..

So based on this, and avoiding bunch of emails from the business asking for their information, let's recreate the UPA using current databases.

  1. Via Central Administration, STOP the User Profile Application service on all servers in the farm.
  2. Delete the User Profile Service Application, but DO NOT CHECK the option "Delete data associated with the Service Application"
  3. Identify the names of the User Profile (Social, Sync, Profile) databases.
  4. Open the SharePoint 2013 Management Shell
  5. Run the New-SPProfileServiceApplication command passing in parameters for: ApplicationPool, Name, MySiteHostLocation, ProfileDBName, ProfileSyncDBName, SocialDBName. This will create a new Profile service app using our restored profile databases. 
  6. Run the New-SPProfileServiceApplicationProxy command passing in parameters for: ServiceApplication, Name and also include the DefaultProxyGroup.
  7. Start the UPA Service on all servers in farm (all servers required)
  8. Run an IISReset on each servers
  9. Start the User Profile Synchronization Service on the application server (server that will host this service) 
  10. Wait... 
  11. Wait...... 
  12. Ensure that it is started before proceeding..!
  13. Ensure that the User Profile Sync timer job is enabled and set properly and then start a full import.. 
 Remember to test this at lower environments BEFORE doing this at PROD


viernes, 24 de abril de 2015

Ups, I forgot the SharePoint Passphrase! No problem

Getting a high load on your farm and you decide to add a new Web Front End to the mix. Oh no! You forgot that SharePoint Passphrase to allow you to connect to your farm.

Before you start freaking out, check out this powershell command

Get-Help Set-SPPassPhrase -Detailed

To easily reset your SharePoint Passphrase
$passphrase = ConvertTo-SecureString -String "mySharePoint2010password" -asPlainText -Force
Set-SPPassPhrase -PassPhrase $passphrase -Confirm


miércoles, 18 de febrero de 2015

Webcast: El Fundamento para un Dashboard Ejecutivo de Análisis de Datos en SharePoint

La comunidad de SharePoint Costa Rica junto con Carlos Cerrato les presenta una jugosa charla sobre dashboards con JavaScript para tu SharePoint.

Registrate en el siguiente vinculo:


martes, 10 de febrero de 2015

There are no addresses available for this application

La razón es dada a que hay configuraciones faltantes, como lo pueden ser servicios o "settings".


  1. Revisa que tus servicios (Central Admin) estén arriba y sin problemas. 
  2. App Pools encendidos y sin problemas en el IIS