2 Replies Latest reply on Jun 12, 2018 10:19 PM by HAGY

    which user edited a display?

    HAGY

      I was wondering if there is a way to know which user edited a display.

      In Vision database I found the LastAccessed table

      here I can see that user entered for the last time.

       

      Apart I saw a table UsedOn

      can you say that these users edited using pivision, to edit display?

        • Re: which user edited a display?
          rschmitz

          Hey Henry,

           

          I would highly recommend not making any changes to the PI Vision Database directly, as this isn't supported. If you're just looking for who edited displays, you do a SELECT on the BrowseElements Table.

           

          SELECT TOP 1000 [ID]
                ,[Name]
                ,[Owner]
                ,[CreatedOn]
                ,[ModifiedOn]
                ,[CreatedBy]
                ,[ModifiedBy]
                ,[ReadOnly]
                ,[StorageTypeID]
                ,[ParentID]
                ,[DeleteFlag]
                ,[TenantID]
            FROM [CoresightDB].[dbo].[BrowseElements]
          

           

          Cheers,

          Rob

          1 of 1 people found this helpful