I don’t recall exactly why this script was required, but the below SQL query can be used to get the expiration date for logins in Microsoft SQL Server. Some of the data is available directly from the sys.sql_logins
table, but other pieces had to be retrieved using the LOGINPROPERTY
function:
SELECT
[‘SQL Logins’].name AS ‘LoginName’
,LOGINPROPERTY([‘SQL Logins’].name, ‘PasswordLastSetTime’)
Continue Reading Ian Grieve’s Article on their blog
SQL Query to Get Login Password Expiry
I don’t recall exactly why this script was required, but the below SQL query can be used to get the expiration date for logins in Microsoft SQL Server. Some of the data is available directly from the sys.sql_logins table, but other pieces had to be retrieved using the LOGINPROPERTY function: ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See Improved Usability for Warehouse and Inventory
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate the Reminders Process in Collections
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Allow Lines with Amounts of Zero on Recurring General Journals
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Specify Dimensions on Posted Entries Applications With Realized Gains or Losses