search

getstrake / aws-pricing-sheets-addon

Google Sheets add-on for AWS Pricing
https://workspace.google.com/marketplace/app/aws_pricing_by_strake/378787760903
33 stars 0 forks source link

API is supported only for windows and linux ec2 instances. #16

Closed khushi1997n closed 1 year ago

khushi1997n commented 2 years ago

This API is supports only for windows and linux ec2 instances. I want to calculate price for "WINDOWS SERVER WITH SQL SERVER STANDARD "and "Linux with SQL Server Standard"

mheffner commented 2 years ago

Does this function format work? 

 EC2_<platform>_MSSQL_<STD or CONV>_RI_<NO, PARTIAL, or ALL>(instanceType, region, sqlLicense, purchaseTerm)

link Where sqlLicense is either web, std, or enterprise and platform is either LINUX or WINDOWS.

reganbrianpatrick commented 1 year ago

@khushi1997n the updated version of this add-on, AWS Pricing by Strake has formulas that support Windows and Linux with SQL licenses. Below are the valid values for platform:

linux windows rhel suse linux_std (Linux SQL Standard) linux_web (Linux SQL Web) linux_enterprise (Linux SQL Enterprise) windows_std (Windows SQL Std) windows_web (Windows SQL Web) windows_enterprise (Windows SQL Enterprise)

Saroopashree commented 1 year ago

What about platforms like Linux/UNIX (Amazon VPC), Windows with SQL Server Web and Red Hat Enterprise Linux with HA? Does Strake add-on support fetching the pricing of these platforms?

john-macroscope commented 1 year ago

Not yet for the "Amazon VPC" things, but that is something I see under reserved instances.

edit: I created new issue to capture ("Amazon VPC" things)[https://github.com/getstrake/aws-pricing-sheets-addon/issues/32].

I do see the following operating systems:

472 "Linux"
306 "Red Hat Enterprise Linux with HA"
400 "RHEL"
118 "SUSE"
472 "Windows"

There is also a variable you can use for sql license filtering, here are some examples from us-east-1 reserved instances:

6878 linux                 "preInstalledSw": "NA",
4229 linux_enterprise      "preInstalledSw": "SQL Ent",
4673 linux_std             "preInstalledSw": "SQL Std",
4841 linux_web             "preInstalledSw": "SQL Web",
6582 rhel-ha               "preInstalledSw": "NA",
  96 rhel-ha_enterprise    "preInstalledSw": "SQL Ent",
 108 rhel-ha_std           "preInstalledSw": "SQL Std",
6806 rhel                  "preInstalledSw": "NA",
  96 rhel_enterprise       "preInstalledSw": "SQL Ent",
 108 rhel_std              "preInstalledSw": "SQL Std",
 108 rhel_web              "preInstalledSw": "SQL Web",
6518 suse                  "preInstalledSw": "NA",
5294 windows               "preInstalledSw": "NA",
4181 windows_enterprise    "preInstalledSw": "SQL Ent",
4665 windows_std           "preInstalledSw": "SQL Std",
4843 windows_web           "preInstalledSw": "SQL Web",
Saroopashree commented 1 year ago

Thanks @john-macroscope! I guess this could be documented well, perhaps in the README