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].
If you have a unique identifier to identify your administrators, you can use this sql statement:
Select * from [ServerLog].ProcInstwhere 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 [ServerLog].ProcInst
Hope this helps.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.