on 11-02-2015 3:55 AM
W e are using SAP BO XI 3.1 SR 6. Please let me know how will I get last 7 days, hourly basis connected users
The right place for you to search is in Audit reports not in Query builder as you need historical information.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please Explain it CLearly, if u dont mind
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anutosh,
You can use the following query builder query to fetch the user's last logon time.
select SI_NAME,SI_USERFULLNAME,SI_LASTLOGONTIME from CI_SYSTEMOBJECTS where si_kind='User'
Extract the output in the excel file using JAVA SDK and you would be able to sort them out as per the date and time.
Hope this helps
~SwapnilY
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.