I have seen Appian sending us the weekly event about usage of Appian Forum. I am

U could use send email smart service for sending an email to specific users . Think it might be helpful have a look at it.. :)

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.... :)

@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.

sorry didn't refresh the page in time, Harsha's post covers the answer provided.

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.

@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...

@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.

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?

@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.

Thanks @sikhivahans for the information. I will try to explore the API for this information.