Wrong determination of the status for OpenStack Workloads

[Anastasia Palkina]

1. Download statistics data for November from https://product-stats.mirantis.com/reports.html
2. Open, for example, keystone_users.csv
3. For some environments, parameter keystone_user.is_added = True repeated several times for one keystone_user.id

Cause is duplication of OSWL records with the same resource_checksum but
with different external_id in the Nailgun DB.

Examples:
master_node_uid = 0181ca6b-bc33-4657-b3cc-4e68af3bd428
keystone_user.id = 0c5c2e3bc52b45498742d5820bd308e6

master_node_uid = bee663b7-6ca7-4655-8f6a-fa86ad5264c0
keystone_user.id = 6f31c49774f7433b84fa1070f7bf47c0

master_node_uid = 62281e7e-a18e-4349-ae0b-35463cf5c48e
keystone_user.id =2b17c9031fce40d2a57d2eb9a17ff73f

As solution we should ignore the same OSWL records in the report grneration process and use only oldest OSWL item.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/256380

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/256380
Committed: https://git.openstack.org/cgit/openstack/fuel-stats/commit/?id=3fdc8e347d7197813121f68463434fdabf4d9aa9
Submitter: Jenkins
Branch: master

commit 3fdc8e347d7197813121f68463434fdabf4d9aa9
Author: Alexander Kislitsky <email address hidden>
Date: Fri Dec 11 14:53:24 2015 +0300

    OSWL duplication in DB handled

    We can have duplicated OSWLs. They have the same checksum but
    different external_ids. Whe should ignore such 'new' OSWLs in the
    report generation process.

    Change-Id: I71b5ef91eb66a9ce475a78da2485f1ec439acd4e
    Closes-Bug: #1524820

[Anastasia Palkina (apalkina)]

Verified on data for January,2016