Question

How to get audit or log of activities of administrators on K2?

  • 23 November 2020
  • 1 reply
  • 38 views

Badge

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].


1 reply

Userlevel 3
Badge +7

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.

Here I selected all from the “Originator” column that contained the word “administrator”

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.

 

Kind Regards

Prineel

Reply