I'm not sure if 2 is even possible and loegged somewhere. For 1 you can easily use the API as the API call (in python) get_organization_inventory(organizationid) will tell you the S/N, mac, model, networkId which should work out for you. YOu can get an entry with "claimedAt" which seems to help you with 2 at least remotely. Of course you can and should format the JSON output to have some sort of excel export.
... View more