Sharepoint in trouble: febrero 2011

Como administradores de SharePoint nos podemos encontrar ante la circunstancia de tener que eliminar registros de la tabla dbo.auditdata para eliminar registros de la auditoría del sitio.

Hay que tener especial precacución a la hora de habilitar la auditoría de un sitio de SharePoint por el espacio en disco que va a consumir.

Para el caso en que tengamos que eliminar registros de lo auditado, utilizaremos el siguiente comando:

stsadm -o trimauditlog
   -url
   -date
   -databasename
   [-databaseserver]

Parameter

Value

Required?

Description

url

A valid URL, such as http://server_name

Yes, if databasename parameter is not specified

Specifies the URL name to a site collection. If you use this parameter, it will only delete the audit entries from that site collection. If this parameter is used, the databaseserver and databasename parameters are ignored.

date

A valid date in the form "YYYYMMDD"

Yes

Represents the earliest date and time for which the user wants to preserve audit data.

databasename (dn)

A valid database name, such as "DB1"

Yes, if url parameter is not specifed

Specifies the name of a content database where the audit log should be trimmed.

databaseserver (ds)

A valid database server, such as "DS1"

Name of the database server where the content database is stored.

Note:
If your database server and SharePoint Products and Technologies are hosted on separate servers, you need to use the databaseserver parameter to specify the database server name.

Extraido de:

http://technet.microsoft.com/en-us/library/cc706879%28office.12%29.aspx

Recogemos la referencia de TechNet con la correlación de comandos de administración STSADM con los cmdlets de PowerShell disponibles en SharePoint 2010:

http://technet.microsoft.com/es-es/library/ff621084.aspx

Operación de Stsadm	Cmdlet de Windows PowerShell
Activatefeature	Enable-SPFeature
Activateformtemplate	Enable-SPInfoPathFormTemplate
Addalternatedomain	New-SPAlternateUrl
Addcontentdb	Mount-SPContentDatabase New-SPContentDatabase
Adddataconnectionfile	Install-SPDataConnectionFile
Add-ecsfiletrustedlocation	New-SPExcelFileLocation
Add-ecssafedataprovider	New-SPExcelDataProvider
Add-ecstrusteddataconnectionlibrary	New-SPExcelDataConnectionLibrary
Add-ecsuserdefinedfunction	New-SPExcelUserDefinedFunction
Addexemptuseragent	Add-SPInfoPathUserAgent
Addpath	New-SPManagedPath
Addpermissionpolicy	Ninguno
Addsolution	Add-SPSolution
Addtemplate	Install-SPWebTemplate
Adduser	New-SPUser
Addwppack	Install-SPWebPartPack
Addzoneurl	New-SPAlternateUrl
Allowuserformwebserviceproxy	Set-SPInfoPathWebServiceProxy Use los parámetros AllowForUserForms e Identity.
Allowwebserviceproxy	Set-SPInfoPathWebServiceProxy Use los parámetros AllowWebServiceProxy e Identity.
Authentication	Set-SPWebApplication Use los parámetros AuthenticationMethod o AuthenticationProvider.
Backup	Backup-SPConfigurationDatabase Backup-SPFarm Backup-SPSite
Backuphistory	Get-SPBackupHistory
Binddrservice	Ninguno
Blockedfilelist	Ninguno
Canceldeployment	Ninguno
Changepermissionpolicy	Ninguno
Copyappbincontent	Ninguno
Createadminvs	New-SPCentralAdministration
Creategroup	Ninguno
Createsite	New-SPSite
Createsiteinnewdb	New-SPSite Use el parámetro ContentDatabase. New-SPContentDatabase
Createweb	New-SPWeb
Databaserepair	Ninguno
Deactivatefeature	Disable-SPFeature
Deactivateformtemplate	Disable-SPInfoPathFormTemplate
Deleteadminvs	Ninguno
Deletealternatedomain	Remove-SPAlternateUrl
Deleteconfigdb	Remove-SPConfigurationDatabase
Deletecontentdb	Dismount-SPContentDatabase
Deletegroup	Ninguno
Deletepath	Remove-SPManagedPath
Deletepermissionpolicy	Ninguno
Deletesite	Remove-SPSite
Deletesolution	Remove-SPSolution
Deletetemplate	Uninstall-SPWebTemplate
Deleteuser	Remove-SPUser
Deleteweb	Remove-SPWeb
Deletewppack	Uninstall-SPWebPartPack
Deletezoneurl	Remove-SPAlternateUrl
Deploysolution	Install-SPSolution
Deploywppack	Install-SPWebPartPack
Disablessc	Ninguno
Displaysolution	Get-SPSolution
Editcontentdeploymentpath	Set-SPContentDeploymentPath
Email	Ninguno
Enablessc	Ninguno
Enumalternatedomains	Get-SPAlternateURL
Enumcontentdbs	Get-SPContentDatabase
Enumdataconnectionfiledependants	Get-SPDataConnectionFileDependent
Enumdataconnectionfiles	Get-SPDataConnectionFile
Enumdeployments	Ninguno
Enumexemptuseragents	Get-SPInfoPathUserAgent
Enumformtemplates	Get-SPInfoPathFormTemplate
Enumgroups	Ninguno
Enumroles	Ninguno
Enumservices	Get-SPServiceInstance
Enumsites	Get-SPSiteAdministration (Para ejecutar este cmdlet, debe pertenecer al grupo de administradores del conjunto o granja de servidores). Get-SPSite (Para ejecutar este cmdlet, debe ser un administrador local del equipo donde está instalado Productos de SharePoint 2010).
Enumsolutions	Get-SPSolution
Enumsubwebs	Get-SPWeb
Enumtemplates	Get-SPWebTemplate
Enumusers	Get-SPUser
Enumwppacks	Get-SPWebPartPack
Enumzoneurls	Get-SPAlternateURL
Execadmsvcjobs	Start-SPAdminJob
Export	Export-SPWeb
Extendvs	New-SPWebApplication
Extendvsinwebfarm	New-SPWebApplicationExtension
Forcedeletelist	Ninguno
Getadminport	Get-SPWebApplication Utilice la sintaxis siguiente: `Get-SPWebApplication -IncludeCentralAdministration \| ? {$_.IsAdministrationWebApplication -eq $true}`
Propiedad Getdataconnectionfileproperty	Get-SPDataConnectionFile Utilice la sintaxis siguiente: `Get-SPDataConnectionFile \| where {$_.Name -eq "dataConFileName"} \| format-list`
Propiedad Getformtemplateproperty	Get-SPInfoPathFormTemplate Utilice la sintaxis siguiente: `Get-SPInfoPathFormTemplate \| where {$_.DisplayName -eq "formTemplateName"} \| format-list`
Getosearchsetting	Ninguno
Getproperty	Get-SPFarmConfig Get-SPTimerJob Disable-SPTimerJob Enable-SPTimerJob Set-SPTimerJob Start-SPTimerJob
Getsitelock	Get-SPSiteAdministration
Getsiteuseraccountdirectorypath	Ninguno
Geturlzone	Get-SPAlternateURL
Import	Import-SPWeb
Installfeature	Install-SPFeature
Listlogginglevels	Get-SPLogLevel
Listqueryprocessoroptions	Ninguno
Listregisteredsecuritytrimmers	Get-SPEnterpriseSearchSecurityTrimmer
Localupgradestatus	Ninguno
Managepermissionpolicylevel	Ninguno
Mergecontentdbs	Move-SPSite
Migrateuser	Move-SPUser
Osearch	Para Osearch, parámetros farmcontactemail, farmperformancelevel, farmserviceaccount y farmservicepassword, use los cmdlets Get-SPEnterpriseSearchService y Set-SPEnterpriseSearchService. Para Osearch, parámetros start y stop, use los cmdlets Start-SPEnterpriseSearchServiceInstance y Stop-SPEnterpriseSearchServiceInstance respectivamente. Para Osearch, parámetro defaultindexlocation, use los cmdlets Get-SPEnterpriseSearchServiceInstance y Set-SPEnterpriseSearchServiceInstance.
Osearchdiacriticsensitive	Use el cmdlet Get-SPEnterpriseSearchServiceApplication para recuperar la aplicación de servicio de búsqueda específica y, a continuación, use el parámetro DiacriticSensitive del cmdlet Set-SPEnterpriseSearchServiceApplication.
Provisionservice	Start-SPServiceInstance
Quiescefarm	Ninguno
Quiescefarmstatus	Ninguno
Quiesceformtemplate	Stop-SPInfoPathFormTemplate
Reconvertallformtemplates	Update-SPInfoPathFormTemplate
Refreshdms	Ninguno
Refreshsitedms	Ninguno
Registersecuritytrimmer	New-SPEnterpriseSearchSecurityTrimmer
Registerwsswriter	Ninguno
Removedataconnectionfile	Uninstall-SPDataConnectionFile
Remove-ecsfiletrustedlocation	Remove-SPExcelFileLocation
Remove-ecssafedataprovider	Remove-SPExcelDataProvider
Remove-ecstrusteddataconnectionlibrary	Remove-SPExcelDataConnectionLibrary
Remove-ecsuserdefinedfunction	Remove-SPExcelFileLocation
Removedrservice	Ninguno
Removeexemptuseragent	Remove-SPInfoPathUserAgent
Removeformtemplate	Uninstall-SPInfoPathFormTemplate
Removesolutiondeploymentlock	Ninguno
Renameserver	Rename-SPServer
Renamesite	Set-SPSite Use el parámetro Url.
Renameweb	Set-SPWeb Use el parámetro RelativeUrl.
Restore	Restore-SPFarm Restore-SPSite
Retractsolution	Uninstall-SPSolution
Retractwppack	Ninguno
Runcontentdeploymentjob	Start-SPContentDeploymentJob
Scanforfeatures	Install-SPFeature Use el parámetro Scanforfeatures.
Setadminport	Set-SPCentralAdministration
Setapppassword	Ninguno
Setconfigdb	Connect-SPConfigurationDatabase
Setcontentdeploymentjobschedule	Set-SPContentDeploymentJob
Setdataconnectionfileproperty	Set-SPDataConnectionFile
Set-ecsexternaldata	Set-SPExcelFileLocation
Set-ecsloadbalancing	Set-SPExcelServiceApplication Use el parámetro LoadBalancingScheme.
Set-ecsmemoryutilization	Set-SPExcelServiceApplication Use los parámetros MemoryCacheThreshold y PrivateBytesMax.
Set-ecssecurity	Set-SPExcelServiceApplication Use los parámetros CrossDomainAccessAllowed, EncryptedUserConnectionRequired y FileAccessMethod.
Set-ecssessionmanagement	Set-SPExcelServiceApplication Use los parámetros SessionsPerUserMax y SiteCollectionAnonymousSessionsMax.
Set-ecsworkbookcache	Set-SPExcelServiceApplication Use los parámetros Workbookcache y WorkbookCacheSizeMax.
Setformtemplateproperty	Set-SPInfoPathFormTemplate
Setlogginglevel	Set-SPLogLevel
Setosearchsetting	Ninguno
Setproperty	Set-SPFarmConfig Get-SPTimerJob Disable-SPTimerJob Enable-SPTimerJob Set-SPTimerJob Start-SPTimerJob
Setqueryprocessoroptions	Ninguno
Setsitelock	Set-SPSiteAdministration Use el parámetro LockState.
Setsiteuseraccountdirectorypath	Get-SPSiteSubscription New-SPSiteSubscription Remove-SPSiteSubscription
Setworkflowconfig	Set-SPWorkflowConfig
Siteowner	Set-SPSiteAdministration
Syncsolution	Install-SPSolution Use el parámetro Synchronize.
Unextendvs	Remove-SPWebApplication
Uninstallfeature	Uninstall-SPFeature
Unquiescefarm	Ninguno
Unquiesceformtemplate	Start-SPInfoPathFormTemplate
Unregistersecuritytrimmer	Remove-SPEnterpriseSearchSecurityTrimmer
Unregisterwsswriter	Ninguno
Updateaccountpassword	Set-SPManagedAccount
Updatealerttemplates	Ninguno
Updatefarmcredentials	Ninguno
Upgrade	Ninguno
Upgradeformtemplate	Install-SPInfoPathFormTemplate
Upgradesolution	Update-SPSolution
Upgradetargetwebapplication	Ninguno
Uploadformtemplate	Install-SPInfoPathFormTemplate
Userrole	Get-SPUser Move-SPUser New-SPUser Remove-SPUser Set-SPUser
Verifyformtemplate	Test-SPInfoPathFormTemplate

Sharepoint in trouble

jueves, 24 de febrero de 2011

Novedades en SharePoint 2010

miércoles, 23 de febrero de 2011

Eliminar registros de auditoría del sitio. Tabla dbo.auditdata y stsadm -o trimauditlog

SharePoint Designer 2010 gratuito

Introducción a las bases de datos utilizadas por SharePoint 2010

SharePoint Space Monitor

STSADM vs Powershell para SharePoint 2010