HOWTO: Identify files checked out to a user?

Good day Jef;

In addition to @dumi, the simple way would be to execute this select statement against k2 database:-

(SELECT * FROM [K2].[Form].[Form]

WHERE MODIFIEDBY = 'K2:DENALLIXAdministrator';)

Please see related information---let's assume you want to know the user who checkin/out forms and forcefully checkedin/out on behalf of the user,

kindly dive into this link:-(https://grok.lsu.edu/article.aspx?articleid=17469&printable=y)

Additional information you might find usefu, Undo Checkout of smartforms with Stored Procedure.
1. select * from [k2].[Form].AuditLog

2. Note: the UserID is the fully qualified name (FQN) for the user that has the form checked out.
3. (https://discovertechnologies.com/blog/undo-checkout-smartforms-stored-procedure/)

Kindly feel free to Mark as "Accepted Solution, Kudo and/or MeToo" if you find this information answered your question or leads you to the answer.

Thanks & Regards;

Widson.

Hi Jef

Again, this is directly manipulating the Database, so please take a full backup prior to doing this.
I'm using an example user and ID below. Please change as necessary.

Step 1: get the info.
--For checked out views
SELECT ID, DisplayName, CheckedOutBy
FROM Form.View_Design
WHERE CheckedOutBy = 'K2:yourdomainNameUserName'; (e.g 'k2:denallixAdministrator'; )

--For checked out forms
SELECT ID, DisplayName, CheckedOutBy
FROM Form.Form_Design
WHERE CheckedOutBy = 'K2:domainNameUserName'; (e.g 'k2:denallixAdministrator'; ) 

Regards

Elvis