Comment 5 for bug 1603563

Trying to get the events log seems to be an iterative process because I can only get 100 entries at a time and with the Power state queries INFO entries there, there are literally thousands of entries. If I select level=ERROR, then there's not much returned and I still have to figure out So I just got them from the GUI

ubuntu@maas2-integration:~/lmic/events$ maas root events query id=4y3h8b
Success.
Machine-readable output follows:
{
    "events": [
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 12:10:37",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1463165
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 12:05:37",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1463080
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 12:00:22",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1463018
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 11:55:22",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1462955
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 11:50:08",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1462892
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 11:44:53",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1462830
        },
....
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 05:17:52",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1447596
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 05:12:37",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1447481
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 05:07:37",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1447378
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 05:02:23",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1446805
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:57:07",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1446213
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:52:07",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1445833
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:46:52",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1445535
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:41:37",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1445150
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:36:37",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1444752
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:31:38",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1444417
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:26:37",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1444286
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:21:23",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1444062
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:16:07",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1443972
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:10:53",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1443910
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:05:38",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1443851
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 04:00:22",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1443784
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 03:55:23",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1443725
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 03:50:08",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1443662
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 03:44:52",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1443600
        },
        {
            "hostname": "prunus",
            "description": "Power state queried: off",
            "node": "4y3h8b",
            "created": "Wed, 20 Jul. 2016 03:39:38",
            "level": "INFO",
            "type": "Queried node's BMC",
            "id": 1443519
        }
    ],
    "next_uri": "/MAAS/api/2.0/events/?op=query&after=1463165&id=4y3h8b",
    "count": 100,
    "prev_uri": "/MAAS/api/2.0/events/?op=query&before=1443519&id=4y3h8b"
}

If I try to use before and after then I either get 1 at a time or an error if I specify the range.

ubuntu@maas2-integration:~/lmic/events$ maas root events query id=4y3h8b level=ERROR after=0
Success.
Machine-readable output follows:
{
    "events": [
        {
            "type": "Failed to power on node",
            "hostname": "prunus",
            "level": "ERROR",
            "description": "Node could not be powered on: Failed talking to node's BMC: Can't convert 'NoneType' object to str implicitly",
            "id": 70,
            "created": "Wed, 22 Jun. 2016 14:47:36",
            "node": "4y3h8b"
        }
    ],
    "prev_uri": "/MAAS/api/2.0/events/?op=query&id=4y3h8b&before=70&level=ERROR",
    "next_uri": "/MAAS/api/2.0/events/?op=query&id=4y3h8b&after=70&level=ERROR",
    "count": 1
}
ubuntu@maas2-integration:~/lmic/events$ maas root events query id=4y3h8b level=ERROR before=1443519Success.
Machine-readable output follows:
{
    "events": [
        {
            "type": "Failed to power on node",
            "hostname": "prunus",
            "level": "ERROR",
            "description": "Node could not be powered on: Failed talking to node's BMC: Can't convert 'NoneType' object to str implicitly",
            "id": 70,
            "created": "Wed, 22 Jun. 2016 14:47:36",
            "node": "4y3h8b"
        }
    ],
    "prev_uri": "/MAAS/api/2.0/events/?op=query&id=4y3h8b&before=70&level=ERROR",
    "next_uri": "/MAAS/api/2.0/events/?op=query&id=4y3h8b&after=70&level=ERROR",
    "count": 1
}
ubuntu@maas2-integration:~/lmic/events$ maas root events query id=4y3h8b level=ERROR after=0 before=1443519
There is undetermined behaviour when both `after` and `before` are specified.
ubuntu@maas2-integration:~/lmic/events$

So attaching events log pasted from GUI instead.