Dear all,
Im not a programmer nor specialist in databes. Yet I do have some experiences.
I have a medical workstation which has no effective user activity log output. Still in our region its mandatory to log user activity as long we keep the studies.
As vendor has no good solution, one way would be to go into database tables and create the query for 2 tables I need with necessary info, like this:
select /*CSV*/ DATE_TIME_CREATED,TO_CHAR(TO_DATE('19700101000000','YYYYMMDDHH24MISS')+((DATE_TIME_CREATED+7200)/(86400)),'YYYY-MM-DD HH24:MI') minute,
USER_ID,EVENT_TYPE,OBJECT_TYPE, OBJECT_REF,IDENTIFIER,SOURCE,DESTINATION,NUM_OBJECTS,EVENT_INFO,VIEWED,PATIENT_ID,DATA_ID,MACHINE_ID,SENT_TO_ARR
from mvf.map_event_audit
UNION ALL
select /*CSV/ DATE_TIME_CREATED,TO_CHAR(TO_DATE('19700101000000','YYYYMMDDHH24MISS')+((DATE_TIME_CREATED+7200)/(86400)),'YYYY-MM-DD HH24:MI') minute,
USER_ID,EVENT_TYPE,OBJECT_TYPE, OBJECT_REF,IDENTIFIER,SOURCE,DESTINATION,NUM_OBJECTS,EVENT_INFO,VIEWED,PATIENT_ID,DATA_ID,MACHINE_ID,SENT_TO_ARR
from mvf.MAP_EVENT
order by 1 desc;
This one works well in sql developer giving a needed output. Yet I would like to make it work as automatic pivot table. Meaning, to create this query run per month into a pivot table (to make client easy way to choose the information) and be named by month and year.
I know there are also external tools for different jobs etc... Yet would it be possible to make such a task automatic inside of DB itself?
Thankfully,
Kaupo
***Moderator action (Timo): removed private contact data as this is not allowed here.***