cancel
Showing results for 
Search instead for 
Did you mean: 

How to find the user name

Former Member
0 Kudos

Hi,

Is there a way to find which user has triggered the event manually in CMC? This case raised, as i want to know the user that got trigerred incorrectly as the webi reports ran on 18th day of a month instead of 2nd day of a month.

Any sql syntax on SAP query builder would also be helpfull.

Thanks,

Venkat

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member198519
Active Contributor
0 Kudos

Is the schedule based on File based event? If yes, then it would be hard to find who triggered that event. The event will not be triggered until someone delete and paste the trigger file again. This information will be in windows logs, i dont think it will be in BO.

Former Member
0 Kudos

This is not based on file event. Is is based on a manual event.

Former Member
0 Kudos

Hi Venkat,

Please try following query to get list of event occurs in CMC

List of events + settings

select * from ci_systemobjects where si_kind='Event'

And you can refer following KBA for more details;

1733964 - How to get list of events using Query Builder?



Hope this will help


Regards,

Veer

Former Member
0 Kudos

Hi Veer,

I tried above SQL, this list all events, what i need to find is a user who trigerred the event at a particular time.

For example: Event1: Trigerred time: 21-sep-2016 9:00 AM, User = need to know user.

Thanks,

Venkat

Former Member
0 Kudos

Hi Veer,

I have modified SQL as select * from ci_systemobjects where si_kind='Event' and si_name ='RunDay2' and found in the results that there are two dates SI_UPDATE_TS and SI_DATE reflecting when it was trigerred but unable to see the user who exactly trigerred it.

Thanks,

Venkat