get_activity_for

Gets activity for a database.

Path:
/lib/server/get_activity_for_database.js

Parameters:

Name	Type	Description
id	String	The unique ID of the database to retrieve activity for.

Example Request:

POST /redrock/query

{
	"Script":"@/lib/server/get_activity_for_database.js(id:'1572c...')"
}

Example Response:

{
    "success": true,
    "Result": {
        "IsAggregate": false,
        "Count": 4,
        "Columns": [
            {
                "Name": "When",
                "IsHidden": false,
                "DDName": "WhenOccurred",
                "Title": "When",
                "DDTitle": "When Occurred",
                "Description": null,
                "Type": 3,
                "Format": null,
                "Width": 0,
                "TableKey": "NotAKey",
                "ForeignKey": null,
                "TableName": "Event"
            },
            {
                "Name": "Detail",
                "IsHidden": false,
                "DDName": "EventMessage",
                "Title": "Detail",
                "DDTitle": "Message",
                "Description": null,
                "Type": 12,
                "Format": null,
                "Width": 0,
                "TableKey": "NotAKey",
                "ForeignKey": null,
                "TableName": "Event"
            },
            ...
        ],
        "FullCount": 4,
        "Results": [
            {
                "Entities": [],
                "Row": {
                    "Detail": "SYSTEM$ checked in database account \"User1\" password for \"Oracle1\"(Oracl1\\test)",
                    "EventType": "Cloud.Server.DatabaseAccount.PasswordReturn",
                    "When": "/Date(1521577208098)/",
                    "AuditId": null
                }
            },
            {
                "Entities": [],
                "Row": {
                    "Detail": "John@test.com checked out database account \"User1\" password for \"Oracle1\"(Oracl1\\test)",
                    "EventType": "Cloud.Server.DatabaseAccount.PasswordExport",
                    "When": "/Date(1521573339396)/",
                    "AuditId": null
                }
            }
        ],
        "ReturnID": ""
    },
    "Message": null,
    "MessageID": null,
    "Exception": null,
    "ErrorID": null,
    "ErrorCode": null,
    "InnerExceptions": null
}