This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Easy way to capture all comments associated with file (is there a log for this)?

Hi all!!

I looking for an easy way to view and/or download "comments" attached to a file.

The process we are testing is when a user reviews a file they shall comment "reviewed". The comment attests to me that they have actually read the file as opposed to just clicking the file.

So, I'd like to capture the comments, time stamp and the name of the file associated with the comments

Does anyone now of a specific method to accomplish this task or hack? 

Thanks.

  • 0

    Not sure if this is a Feature Request or feature that is available now. Regardless, i needed a closer look into this and submitted an SR. Submitted as a "How do I..."

    For tracking purposes:

    SR#101316550641

     

  • 0   in reply to 

    I do not see an easy way ...

    In Vibe there is an activity log which can be exported and will probably contain this information. But I did not find a similar way in Filr.

    So a feature request would be the next step!


    Use "Verified Answers" if your problem/issue has been solved!

  • Verified Answer

    0   in reply to 

    The audit report does log that a comment has been added to a document.  Unfortunately it does not log the contents of the comment.  Maybe it would be worth adding an idea?

    The way to do this now, would be to pull the information from the database, the comment text is in the ss_folderentries table in the description_text field

  • 0 in reply to   

    hi  

    thanks. i will submit an idea.

    BTW: i vaguely recall you mentioning something along digging/pulling items out of the database during one of the webinars. I was about to take look at the video to refresh my memory.

    @all i have a 4 day holiday (thaksgiving - US)  to make this happen. someone, anyone please kindly send some guidance my way.

    best

  • 0 in reply to   

    Please vote for my idea:

     

    /collaboration/filr/i/filrideas/configure-audit-log-to-capture-contents-on-the-comment-field

     

    THANKS!

  • 0   in reply to 

    Here is an SQL query which should return what you need, edit as required,

    Select
    ss_basicaudit.eventdate As eventdate,
    ss_forums.pathname As pathname,
    ss_folderentries.title As title,
    ss_principals.name As username,
    ss_basicaudit.eventtype As eventtype,
    Case ss_basicaudit.eventtype
    When 2
    Then 'Create'
    When 3
    Then 'Edit'
    Else ''
    End As actiontype,
    ss_folderentries.description_text
    From
    ss_basicaudit Inner Join
    ss_zoneinfo On ss_zoneinfo.zoneid = ss_basicaudit.zoneid Inner Join
    ss_principals On ss_principals.id = ss_basicaudit.userid Inner Join
    ss_folderentries On ss_folderentries.id = ss_basicaudit.entityid Inner Join
    ss_forums On ss_forums.id = ss_basicaudit.owningbinderid
    Where
    ss_folderentries.title Like ('Re:%')

  • 0 in reply to   
    thank you
  • 0   in reply to   
    Yes, I know SQL statements are excellent to get a out more information of Filr - but it is not easy/simple ...

    Use "Verified Answers" if your problem/issue has been solved!

  • 0 in reply to   

    Was wondering if there was any movement on printing comments? Also, are there any restrictions on deleting comments?

  • 0   in reply to 

    Yes, with the SIEM capabilities this is now logged in ss_cef events, and appserver.log also of course sent to your SIEM solution.  The log entry includes the contents of the comment.  See below.

    CEF:1|Micro Focus|Filr|5.0.0.1|Add Comment|Add Comment|0|msg=testing for comments shost=filrshare.mydemo.biz dvc=172.17.2.185 suid=Robin Redgrave (rredgrave) fileType=Entry fileCreateTime=Mar 15 2023 16:59:52.542 GMT filePath=/Home Workspace/Personal Workspaces/Robin Redgrave (rredgrave)/My Files Storage fname=airserver.pdf