Notifications
Clear all
Topic starter
Is there a way to find out or a report that can be run to find out which user(s) created specific appointment books in Centricity 9.12?
Posted : May 17, 2021 8:45 am
It doesn't look like it. There is no field in the BOOK table with that information and I didn't see an event that looked appropriate in the AUDIT_EVENT_TYPE table.
Posted : May 17, 2021 10:11 am
you can get the workstation id for the workstation that created it the books table, might help you, only thing think i could think of.
Posted : May 17, 2021 1:33 pm
Topic starter
@petemarkey I am not seeing workstation id field in the Books table. Can you provide more details on where the workstation id field is and how to link it back to the Books table? Thank you!
Posted : May 18, 2021 12:23 am
The last 6 digits of the ID field in the book table are the workstation ID. It is certainly not an absolute way to determine what you are looking for (especially in a terminal services environment), but about all you have to go on. Match to the wsid in the worksta table.
Posted : May 18, 2021 1:50 am
Topic starter
@petemarkey Thank you for that information. It seems like the the ID in Book table last 6 digits is not consistent. Since there is usually only one user that creates the appt books. So the last 6 digits of the ID should be the same correct since the user is using the same workstation each time an appt book gets created. Also, when i add in the worksta table it says table or view doesn't exist.
Posted : May 18, 2021 2:05 am
yeah depending on your environment it can be inconsistent, in mine it is very consistent. the wsid in the worksta table probably isn't the full 6 digits, just fyi you would have to trim the zero's of the front of the 6 digits in the id field to get a sql match.
Posted : May 18, 2021 3:01 am
