Log information in the grid

ashman over 7 years ago

Hi All,

I have a use case where I need to show some of the log files such as audit/news_usage.csv and login-audit.csv in the grid. For the news usage grid,I have a grid columns such as Username, Action, Timestamp. And I have used readcsvlog() function and it is returning the csv contents. I am worried how to retrieve the contents from this log file and show up in the gird.

Please let me know how to achieve this.

Thanks in advance!

Discussion posts and replies are publicly visible

Parents

0 ashman over 7 years ago

Thanks Chetany for the inputs. I have gone through this sail recipes forum.appian.com/.../SAIL_Recipes.html
Before loading the datas in todatasubset() ,the log data's should be like this
{ Username: "John Smith", Action: "Comment From Process", Timestamp:"xxx"},
{ Username: "Michael Johnson", Action: "Comment From Process" ,Timestamp:"xxx"},
{ Username: "Mary Reed", Action: "Event From Process", Timestamp:"xxx"}
But the log data's were in the below format
[logName=E:\\appian162\\logs\\audit\
ews_usage.csv, totalCount=xx, rows=2 Jul 2016 15:42:24 GMT,_h-0000dcc8-996e-8000-0313-010000010000_128,Comment From Process; 31 Jul 2016 15:42:28 GMT,_h-0000dcc8-996e-8000-0313-010000010000_128,Comment From Process]

Anyone help me how to format the data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ashman over 7 years ago

Thanks Chetany for the inputs. I have gone through this sail recipes forum.appian.com/.../SAIL_Recipes.html
Before loading the datas in todatasubset() ,the log data's should be like this
{ Username: "John Smith", Action: "Comment From Process", Timestamp:"xxx"},
{ Username: "Michael Johnson", Action: "Comment From Process" ,Timestamp:"xxx"},
{ Username: "Mary Reed", Action: "Event From Process", Timestamp:"xxx"}
But the log data's were in the below format
[logName=E:\\appian162\\logs\\audit\
ews_usage.csv, totalCount=xx, rows=2 Jul 2016 15:42:24 GMT,_h-0000dcc8-996e-8000-0313-010000010000_128,Comment From Process; 31 Jul 2016 15:42:28 GMT,_h-0000dcc8-996e-8000-0313-010000010000_128,Comment From Process]

Anyone help me how to format the data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data