Create a Report with Type User
svc = "report/update_report";
params={
"n": "User Log ",
"ct": "storage_user",
"p": "{\"bind\":null}",
"tbl": [
{
"n": "user_stats",
"l": "Statistics",
"f": 0,
"c": "",
"cl": "",
"p": "{\"address_format\":\"1255211008_10_5\",\"time_format\":\"%Y-%m-%E_%H:%M:%S\",\"us_units\":0}",
"sch": {
"y": 0,
"m": 0,
"w": 0,
"f1": 0,
"f2": 0,
"t1": 0,
"t2": 0
},
"sl": "[\"Address\",\"Time Format\"]",
"s": "[\"address_format\",\"time_format\",\"us_units\"]"
},
{
"l": "Log",
"c": "[\"time\",\"user\",\"item_name\",\"item_type\",\"action\",\"host\",\"dummy\"]",
"n": "user_log",
"cl": "[\"Time\",\"User\",\"Item name\",\"Item type\",\"Action\",\"Host\",\"Notes\"]",
"sl": "",
"s": "",
"f": 0,
"sch": {
"y": 0,
"m": 0,
"w": 0,
"f1": 0,
"f2": 0,
"t1": 0,
"t2": 0
},
"p": "{\"username\":\"*\"}"
}
],
"id": 0,
"itemId": <resource id>,
"callMode": "create"
}
And query the report template
And then Query the rows like any other
Nishad Hussain Kaippally
Implementation Specialist, Middle East, Gurtam
"Computer science is no more about computers than astronomy is about telescopes."