Please how do i get log of activities of users with administrator server rights on K2? Like how i can see user activities on K2].]ServerLog].]ProcInstDataAudit].
Page 1 / 1
Hi @femotinga,
If you have a unique identifier to identify your administrators, you can use this sql statement:
Select * from [ServerLog].ProcInst
where Originator Like '%administrator%';It is a select statement that lets you use a “contain” statement.
If you have multiple identifiers, something like this should also work:
SELECT * FROM MyTable WHERE
Column1 LIKE '%word1%'
AND Column1 LIKE '%word2%'
AND Column1 LIKE '%word3%'(The code above was from stackoverflow: https://stackoverflow.com/questions/14290857/sql-select-where-field-contains-words).
If you want to see all activities you can just use:
Select * from lServerLog].ProcInstHope this helps.
Kind Regards
Prineel
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.