Pages

Wednesday, November 9, 2016

Incoming Email Sharepoint List workflow is not starting in the new item is created

1- First of all, we have check in SharePoint server setting if workflow trigger on email is enabled or not, and enable it.
Using STSADM 
Open the SharePoint 2010 Management Shell as administrator and run following command:

stsadm -o getproperty -pn declarativeworkflowautostartonemailenabled

Output should be:

PS 

If Value of property is “No” you have to enable it by typing following command:

stsadm -o setproperty -pn declarativeworkflowautostartonemailenabled -pv true.

Using PowerShell
st


This property was somewhat easier to set using STSADM, however keep in mind that STSADM is being retired. PowerShell is the command line administration tool to use moving forward.

Open the SharePoint 2010 Management Shell as administrator and run the following to determine the value of the DeclarativeWorkflowAutoStartOnEmailEnabled property:

$spWebService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$spWebService.DeclarativeWorkflowAutoStartOnEmailEnabled

If the Value of the property is "False" you have to enable it by typing the following commands:


Execute in the powershell script to set true in the DeclarativeWorkflowAutoStartOnEmailEnabled.
By default DeclarativeWorkflowAutoStartOnEmailEnabled property is false.


$spWebService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$spWebService.DeclarativeWorkflowAutoStartOnEmailEnabled = $true
$spWebService.Update()

Wednesday, September 21, 2016

Get SQL Server Custom Login Password expiration Details

 The below code will execute in the SQL server then you will get the details


--Show all logins password expiration date and creation date

SELECT name AS SQLLoginName,
   DATEADD(DAY, CAST(LOGINPROPERTY(name, 'DaysUntilExpiration') AS int), GETDATE())
AS ExpirationDate,
   create_date
   FROM sys.server_principals
   WHERE type = 'S'


-- Show all logins where the password was changed within the last day

SELECT name, LOGINPROPERTY([name], 'PasswordLastSetTime') AS 'PasswordChanged'
FROM sys.sql_logins
WHERE LOGINPROPERTY([name], 'PasswordLastSetTime') > DATEADD(dd, -1, GETDATE());


-- Show all logins where the password is over 60 days old

SELECT name, LOGINPROPERTY([name], 'PasswordLastSetTime') AS 'PasswordChanged'
FROM sys.sql_logins
WHERE LOGINPROPERTY([name], 'PasswordLastSetTime') < DATEADD(dd, -60, GETDATE())
  AND NOT (LEFT([name], 2) = '##' AND RIGHT([name], 2) = '##');


--Change Password via code

ALTER LOGIN TestDBs
WITH PASSWORD = 'Asdeft##';

Wednesday, August 17, 2016

Dynamic hyperlink open in the new window in the Nintex workflow form

Opening a dynamic link in a new window can also be done by adding a button

 (action: JavaScript, type: Link) in the advanced section you enter window.open("the dynamic link") by on-click.




Now you can click on the Resume Link, it will open the Resume Document.

Friday, July 15, 2016

Enable Breadcrumb in the sharepoint 2013

Enable Bread crumb traditional link in the master page

Edit your sharepoint master page and apply the below code as per in the screen shot.



Thursday, June 23, 2016

Sharepoint 2013: “Access Denied” Error Message While Activating A Timerjob Site-Feature or Custom Web Part Feature

Error:
ULS: Access denied. w3wp.exe (0x1E30) – 6615 – Critical under /_layouts/ManageFeatures.aspx?Scope=Site
Getting a error message while activating a timerjob site-feature (on a production system with uac) as farm and local administrator on a sharepoint site.
Solution:
1) Execute this powershell script as farmadmin:
function Set-AccessDenied-False()
{
# load sharepoint api libs
[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”) > $null
[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint.Administration”) > $null# get content web service
$contentService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
# turn off remote administration security
$contentService.RemoteAdministratorAccessDenied = $false
# update the web service
$contentService.Update()
}
Set-AccessDenied-False




2) App pool recycle or iisreset
3) Active your feature again

Thursday, May 26, 2016

ASP.Net Server Side Code for redirect to another Page


You can use in the below code in your code block

string spurl = SPContext.Current.Site.Url;              
string scriptText = "alert('Record has Successfully SavedDraft.'); window.location='" + spurl + "/Test/default.aspx'";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(panel4, Page.GetType(), "alertMessage", scriptText, true);


Once user click on the Button then it will redirect to other page.