I need to track when the users have been granted access to PIVison. Is there a way? Did check the tables & views of PICoresightDB but no luck.
Check the PI Vision admin page.
There is a option.
You can get Reports from here. Who accessed PI Vision.
It shows monthly data by clicking View or Export.
Adding if you click Details button, it downloads csv file which shows accessing date too.
I thought so.
I created a ODBC Table link to the PIVision Database.
Linked - Provider=SQLNCLI11.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog=PI_Coresight;Data Source=osi-pi-prd;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=OSI-APP1;Initial File Name="";Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False;Application Intent=READWRITE;
Linked - SELECT Distinct[UsedBy],[UsedOn]
Do you know if is it possible to add the name of the displays that the person used to the SQL Query that you shared?
So that to obtein 3 columns: UserName, DiaplayName, DateUsed
Thank you in advance!
Retrieving data ...