Posts

Showing posts from January, 2020

Renaming SharePoint Server Name

Image
When you rename the windows server name, then all the services stops running as it'll not update the new name in IIS and Central Admin. To Update the new name in IIS Rename the server name from IIS by right clicking on server name in connections pane on the left in IIS. Select Rename, provide new name, and then save the connection. For Central Admin  Use powershell command Rename-SPServer to rename the server After renaming the server, update Alternate access mappings for all sites referring old server name.

Fetch SharePoint Workflow Manager 1.0 Scopes

Workflow Manager Scopes SQL Query You can use following SQL Query on WFResourceManagementDB and it will list down all the workflow scopes created by Workflow Manager with Subsite URL and Scope path: ; WITH XMLNAMESPACES ( 'http://schemas.microsoft.com/workflow/2012/xaml/activities' AS ns ) SELECT  XC . value ( 'ns:Value[1]' , 'varchar(150)' ) AS WScope , S . Path , S . DefaultWorkflowConfiguration , S . Description FROM [WFResourceManagementDB] . [dbo] . [Scopes] S CROSS APPLY S . DefaultWorkflowConfiguration . nodes ( '/ns:ScopedWorkflowConfiguration/ns:appSettings/ns:AppSetting' ) as XT ( XC ) WHERE XC . value ( 'ns:Key[1]' , 'varchar(100)' ) LIKE '%WebUrl' Order By 1 PowerShell Method You can use below PowerShell script to fetch all the scopes: [ string ] $Endpoint = 'http://wfservername:12291' [ string ] $Path = '/' [ string ] $Parent = "None"