Forum Discussion

aravikum's avatar
aravikum
Contributor
8 years ago

Is it possible to check how many users have been using URL as Review materials using Database?

Hi All,

 

Please let us know, Is there any way for filtering out the number of users who are using URL upload for the Review Materials. In case of Database, atleast let us know the Table name in which we need to search or filter.

 

If there is any other way to check this.

 

 

Regards,

Avinash Ravikumar

  • yimy's avatar
    yimy
    Community Manager
    7 years ago

    Hi,

     

    I believe it could be possible, but it would involve, at least two tables. On the other hand, there is not a column in a table that says if the uploaded file is an URL link/path, or something else. They do, however, have the "http(s)" string, which can be used to filter out these URL links.

     

    The tables to consider are, 'version' and 'userversionaction'. You might also need the 'user' table to list the actual names of the users along with their IDs.

     

    Take a look at this link for an overview of Collaborator's database schema:

    https://support.smartbear.com/viewarticle/91536/

     

    I hope the information was helpful.

     

    Thanks,

    Yimy

    • aravikum's avatar
      aravikum
      Contributor
      7 years ago

      Thanks for the reply.

       

      But, we are not able to find the userversion action table and also let us know which field values shows https string in version table.

       

      Thanks and Regards,

      Avinash

      • yimy's avatar
        yimy
        Community Manager
        7 years ago

        Hi,

         

        Sorry for not replying sooner.

         

        I am attaching a screenshot of the tables that I was referring as well as the fields/columns.

         

        I hope it helps.

         

        Thanks,

        Yimy