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
- Dyn365GP19 April 2024MADIC dynamics Knowledge Hub Webinars: Jet Reports & Business Central
- Dyn365GP19 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename a Company
- Dyn365GP18 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Share a Saved List View
- Dyn365GP17 April 2024Splitting a Table on a Microsoft Dynamics 365 Business Central Word Template