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##';

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.

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.

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

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.

How to get Nintex Tasks Approval ID from Sql Server

SQL Query:

Execute the below query in your Nintex SQL server.

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [Id]
      ,[Name]
  FROM [NW2013DB].[dbo].[ConfiguredOutcomes]

Sharepoint 2013 Workflow Tasks List - View with Filtered By Assigned To = Sharepoint Groups

Scenario:

I have workflow with three approvers, One approvers is specific person, the other approvers are two sharepoint groups like HR SP Group and CEO SP Group.

I would like to add task webpart in the home page to filter my sharepoint Workflow 2013 Tasks list only to display the tasks assigned to the current user.

Hence I create a HR View and set a filter ‘Assigned To’ is equal to [Me] in the view.

However, I am not seeing the tasks that has a HR SP Group assigned and the HR SP group contains the current user.

Solution:

 Here are the steps:

1. Create HR Task view in the Task List.
2. set a filter ‘Assigned To’ is equal to HR SP Group in the view.
3. Open SharePoint Designer.
4. Open theHR Task view of the task list in code view.
5. Find the tag and within it add the following:

Find the Tag

Replace to

     6.Save the view and open it again in the browser.