Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
12 replies
Subscribers
7 subscribers
Views
3339 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I have seen Appian sending us the weekly event about usage of Appian Forum. I am
aksharc
over 8 years ago
I have seen Appian sending us the weekly event about usage of Appian Forum. I am curious how that could be achieve for our environment. Also, I would like to know whether I can monitor any Tempo Report, or Record similarly.
Any pointer on this would be helpful.
(We are on 7.11 Cloud)
Thanks.
Akshar
OriginalPostID-196493
OriginalPostID-196493
Discussion posts and replies are publicly visible
0
abishekk
over 8 years ago
U could use send email smart service for sending an email to specific users . Think it might be helpful have a look at it.. :)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 8 years ago
if you are referring to this "Last week, 22% of all XYZ users were active on Appian Forum", there might be a work around ... the first thought which came into my mind is to get the login audit csv file read the data and find out the percentage of active in the environment and post a feed ... which can be done in a weekly basis. For reading the Login-audit.csv file there is a plugin,
forum.appian.com/.../summary
Hope this would help.... :)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
narasimhaadityac
A Score Level 2
over 8 years ago
@Akshar, you can get the login details from login_audit.csv is a csv file where each login is tracked Its is a system log and is located under
/logs directory on the server where Appian is installed. please take a look at this file, after reading the information from the file you will be able to filter on the dates and also join with your Appian user and roles information to determine and send out respective emails.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
narasimhaadityac
A Score Level 2
over 8 years ago
sorry didn't refresh the page in time, Harsha's post covers the answer provided.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
I doubt if it's only based on the login activity. In addition to the login activity, it could be also based on the participation by an user in the news feed entries. Just in case, if user's participation information is also considered, it can be queried by interacting with the tables related to news feed in the primary data source (that is make use of query database smart service and native sql query) but I am not sure how Appian does this, as querying the primary datasource isn't a good idea.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 8 years ago
@sikhivans, Not sure whether this would be the approach but I would have considered like this... since the users who have logged into the environment could be obtained by getting the list from login audit file and the users available in env would be coming from distinct users of all users group. then the percentage would do...this is just my assumption...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
@harshav Simply logging into forum might not be a criteria as per my knowledge and anyhow Appian has got a possibility to determine if the user has made comments or not. Especially in case of forum, active as per my idea would be the participation in the news feed entries, as this activity has got much significance.
But if it's just based on login activity, parsing csv file should do the job as discussed above.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aksharc
over 8 years ago
I was going through the application logs, and under the audit folder, I found news_usage.csv file. This file contains following fields: Timestamp, User, Action.
Here is one sample entry: 4 Aug 2014 14:00:08 GMT,_h-0001d99b-b6a3-8000-9aee-01075c01075c_4,Comment From Process
I am curious how I should get the user's name from this value - _h-0001d99b-b6a3-8000-9aee-01075c01075c_4?
If I can get the user's name, I could use it for generating audit report.
Any idea how I should get that data?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
@aksharc Hi, as per the documentation at https://forum.appian.com/suite/help/16.1/Logging.html#News_Usage_Audit, the second column, that is, 'User' holds the uuid of User object.
As per my knowledge, unfortunately, there isn't a OOTB function or shared component as of now, that will get the User profile from uuid. But you may write one such by exploring the API.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aksharc
over 8 years ago
Thanks @sikhivahans for the information. I will try to explore the API for this information.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>