I have inherited a project for auditing to pull information on SQL users password expiration policy. Right now they believe it's 30 days and want to set it to 90 days. Is there a query that I can run to select this information?
No server access, I can't connect via PuTTy or RDP. I can only connect via SQL.
Group policy is set for 90 days on all the other servers, this may not be communicating correctly to the GP?
I'll be on all day as no one that would be able to help me directly in the office is here, and if you need more information I can provide that to the best of my ability.