Does anyone know the SQL query to list all checked out files, user names? Right now every Friday I have ot manually do this. I was hoping I can get the SQL query to show this, then of course have an email sent to me with it.
select Path + filename, username from
inner join DocumentsInProjects dp on d.DocumentID = dp.DocumentID
inner join Projects p on p.ProjectID = dp.ProjectID
inner join Users u on u.UserID = d.UserID
where Username is not null
Awesome thank you. Is there to automate an email to those users that have files checked out?
There is, but you'll have to use dynamic SQL and a bit of creativity to do it.
Retrieving data ...