Uploaded image for project: 'Subscription Watch'
  1. Subscription Watch
  2. SWATCH-1874

[SPIKE] ELS EUS Payg product configs shouldn't require productname

XMLWordPrintable

    • Icon: Story Story
    • Resolution: Done
    • Icon: Undefined Undefined
    • None
    • None
    • None

      Currently, one of the criteria we use in our join on offering when sending usage to AWS is product name. Hence product name currently gets mandatory for payg product configuration. The goal is to remove product name for ELS so that we can re-enable EUS in our configuration. ELS and EUS would have the same product name 'RHEL server'

       select s1_0.start_date,s1_0.subscription_id,s1_0.billing_account_id,s1_0.billing_provider,s1_0.billing_provider_id,s1_0.end_date,o1_0.sku,o1_0.cores,o1_0.derived_sku,o1_0.description,o1_0.has_unlimited_usage,o1_0.hypervisor_cores,o1_0.hypervisor_sockets,o1_0.product_family,o1_0.product_name,o1_0.role,o1_0.sla,o1_0.sockets,o1_0.usage,s1_0.org_id,s1_0.quantity,s2_0.start_date,s2_0.subscription_id,s2_0.measurement_type,s2_0.metric_id,s2_0.value,s1_0.subscription_number from subscription s1_0 join offering o1_0 on o1_0.sku=s1_0.sku left join subscription_measurements s2_0 on s1_0.start_date=s2_0.start_date and s1_0.subscription_id=s2_0.subscription_id where s1_0.start_date<='2023-10-23T18:45:51.992522852Z' and (s1_0.end_date is null or s1_0.end_date>='2023-10-23T17:45:51.992522852Z') and s1_0.org_id='13259775' and s1_0.billing_provider_id is not null and s1_0.billing_provider_id<>'' and o1_0.product_name in ('RHEL Server') and o1_0.sla='Premium' and s1_0.billing_provider='aws' and s1_0.billing_account_id='746157280291' order by s1_0.start_date desc
      • SKU should contain payg vs nonpayg to differentiate between two. Like traditional EUS and payg EUS. - Justin is going to follow on this.
      • We can create another table to store offering_producttags to store 1:many relation between sku and product tags.
      • To obtain the correct product, we need to utilize three parameters: (the eng id, the new parameter Justin will provide, and the possibility of adding a third parameter to distinguish across Payg products) to remove the need for productnames.
      • ^ can be utilized across other teams to identify the product not just based on skus.
        https://docs.google.com/document/d/1sAaxwILBpTxjTzejxYRy_quP2fgUax_cFYTemONHaQk/edit#heading=h.q12souwqw1nf

            Unassigned Unassigned
            karshah@redhat.com Kartik Shah
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: