users not logged on for more than 30 days

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Peter Forbes Grasshopper Points: 13 More actions · Answer 1

We activate Login audit and read the errorlog files into a temporary table with master.dbo.xp_readerrorlog

Then delete unwanted rows until left with a report of users and last login date.