There is a way to know which users accessed a specific dashboard on Pi Vision? Or at least, know how many users have accessed Pi Vision per day, week or month
Unfortunately, there is no built-in report that will answer the questions you ask. Most of this information is, however, available in the PI Vision database and can be extracted from that. Keep in mind that any direct SQL access is not supported and might not work from version to version. But with that caveat, the database schema has been quite stable and read-only access shouldn't cause any harm. The information is primarily in the 'UserDisplayData' table. That table shows a list of the most recent time each user has accessed a display. For example this SQL query can be used to see the displays accessed by the most users:
SELECT TOP (1000) DisplayID, Name, COUNT(User) as 'Users'
FROM [PIVision].[dbo].[UserDisplayData] JOIN BrowseElements ON BrowseElements.ID = UserDisplayData.DisplayID GROUP BY DisplayID, Name ORDER BY Users DESC
Please keep in mind that I'm not a SQL expert and that this probably has significant style errors.
Please go to the PI Vision forum on https://feedback.osisoft.int and see if there are any current requests for the reports that you need. If not, please enter a new suggestion.
a corrected SQL statement that will work. You had only missed the [PIVision].[dbo].[BrowseElements].
FROM [PIVision].[dbo].[UserDisplayData] JOIN [PIVision].[dbo].[BrowseElements] ON BrowseElements.ID = UserDisplayData.DisplayID
GROUP BY DisplayID, Name
ORDER BY Users DESC
Would it be possible to add/query the user name/id that has accessed display?
this SQL statement will give you information about users who have accessed the displays. If you order by Last Accessed By instead of Last Accessed Date you will have the list sorted by user name instead.
SELECT E.Name as [Display Name],e.Owner as [Display Owner], e.CreatedOn as [Display Creation Date],U.[User] as [Last Accessed By], u.LastAccessed as [Last Accessed Date] from BrowseElements E join UserDisplayData U on E.ID =U.DisplayIDorder by [Last Accessed Date] desc
This is great, thanks!
Just to follow up, this is the corresponding request on our feedback site: View Display Usage – User Feedback for OSIsoft Products and Services
This could be of help: Measure PI Vision Utilization
The data is there, as at least we have reports for a variable period on the admin page:
From admin page you can check how many users are accessing PI Vision.
Admin Page--> Reports--> Users who have accessed PI Vision within a specific time range--> custom range
Thanks for this, I was aware of this, it is useful although it doesn't really provide a detailed information.
Retrieving data ...