# Product Key Automation

###### tags: `Dev Note`、`Product Key Automation`

## Sync-up with Hank
###### :calendar: 12/05 (Mon.) 14:00
Demo date would like to hold on 12/19(Mon)

## Sync-up with Hank
###### :calendar: 11/28 (Mon.) 15:00
1. Since automation is relay on P.K.R, so far autoamttion would only support SFT-DCMS-SINGLE, SFT-OOB-LIC
> H" understand that automation is relay on PKR
> But BMC order with 5 license type will be alot of help
3. If gonna add license type have to check new type license rule and format differentence, what is the road plan about this
- is key server contain all type of license
> H"yes
- who will know the difference
> H"me
- how is the portal design plan
> it will be great the portal could support mrome type, but ui may make some change
4. Do automation intigrate PKR genKey API like estore does?
> H" dont have idea about backend, as long as you agree and advise
6. do we need to lock the input field (but add 'clear' button), in order to save response time
> H" das long as you agree and advise
8. how to use the field 'sales email'
> H" append it to shipping notify
9. should we filter status with PDBS, what are thay stand for
> H" no but there is an importent thing have to exculde the order that contains "MC0037", it means is an assembily order, assembily team would take care of key license
11. what will be plan about staging domain, production domain
> TBD its not good discuss release plan

## Sync-up with Hank
###### :calendar: 11/21 (Mon.) 14:00am
1. 確定SW-PM list在pending list 少了Arun Kalluri?
::: spoiler 目前SW-PM列表
- Login:
- Arun Kalluri, Max Chen, Hank Chuang, Leon Hsu, Duyen Truong
- Admin page:
- Arun Kalluri, Max Chen, Hank Chuang, Leon Hsu, Duyen Truong
- pending notification:
- Max Chen, Hank Chuang, Leon Hsu, Duyen Truong
- Approve/Reject Sales notification:
- Arun Kalluri, Max Chen, Hank Chuang, Leon Hsu, Duyen Truong
:::

2. 系統透過到PDBS 用DN query自動帶入[Sales ORG, licence type, licence quantity]，有兩個問題
- A. 不同的Sales ORG，Order會存在PDBS中不同的DB，在只有DN時不知道要去哪個DB
::: spoiler 想到的解法
- 解法A.
系統在查詢PDBS時去每個DB都查過一次
因為只有分4個Sales ORG(USA: 1889, BV: 3888, TW: 2888, TW: 3806)
- 缺點1 是連到多個DB要顧慮查詢時間
- 缺點2 不敢確定DN在不同DB是唯一的，可能存在複數個DB，查到別人的訂單資料
- 改善A-1 當遇到多筆相符的資料另外跳提醒，讓sales選擇要哪一個ORG的資料
- 缺點 不可預期訂單數量，可能會多到不容易呈現與選擇
- 缺點 要另外設計操作介面方式

- 解法B. 跟舊系統一樣先填Sales ORG才能query，畢竟這看起來只有不常變動的4個選項
- 缺點 少一點點自動化
:::
- PDBS
- B. 透過DN可能查到多筆Orders，這些Orders可能會是不同licence type及數量，相同的type可以累加，但系統目前設計頂多只能帶出一種licence type及數量
::: spoiler 想到的解法
- 解法A.
查出來之後讓user還可以更改要選哪一種type
不同type會帶出相對應的資料
可以事先設定帶出來的優先順序，或是不選等待Sales選擇
- 缺點 需要Sales double check少一點點自動化
:::

1. Automation 要不要增加 從MB SN GenKey

1. 需不需要 Mac txt file upload?

1. 上次說到的到PKR檢查Customer’s eamil是不是代表這欄位也放一個query
::: spoiler
- 1.2 tool will fill the domain name in the Customer Domain field automatically when Sales keyin the customer email address in the Customer’s Email field
► Query data in Product Key Retrieval:
- Customer Domain
:::

1. 另外retrievel的DB裡也有company name，雖然文件沒有寫到，但是也是有機會可以透過retrievel帶出來，填寫流程會更順，沒有這樣設計是因為有什麼顧慮嗎?

1. 對於Customer's Email，有多筆輸入是為了什麼

1. 呈上題，多筆輸入代表要確認每一個Customer's Email在portal都是enterprise user且都指向同一個domain嗎?

1. 依照過去9090經驗Key Server有沒有一次產生Key的數量限制

3. Jim會在11/28才夠處理SPCI的訪問權限，有沒有其他解套方式
4. does PKR's membwe has enough covery?

## Sync-up with Hank
###### :calendar: 11/10 (Thur.) 14:00am

### 會議整理
- DN query
- PDBS是實際case
- Hank會協助要實際的帳號
- 我們要提出測試方式
- 跟IT討論
- 但實際DB不可以放TestDB

- PKR (produt key retriveal)
- 如果是prepaid要先確認客人有這部分的enterpise account、有domain
- SPCI
- Hank會協助要實際的帳號
- 確認Mac有存在
- 跟Matt確認是不是有拿過這部分的source code
> 9090(BMC)9091(pre-paid)有去PDBS、SPCI檢查
- AD
- login auth check
- SW-PM 根據文件hard code
- Sales 根據AD server查詢
- 相關帳密詢問Matt跟誰申請
- Notify
- 不用接AD server
- 台灣；荷蘭都有自己的mail group；美國有一定的list
- 根據文件hard code這部分
- 要給哪個shipping team 要看Salse org
- SW-PM也根據文件hard code
- Other
- 會後Hank會提供9090、9191 source code
- swpm4order是這個網站到時做gen key的身分驗證使用

## Discussion with Matt in training
###### :calendar: 11/7 (Mon.) 17:30am

> ### Matt
> 1. Protal use LDAP to login
> 2. Portal did not check DN number
> 3. Portal use MDBS to check Mac to generate key

> > [post]KeyTransfer
> > validate -->
> > check mb serial belong user -->
> > check SMC.t_ProdKey_Xfer MBSerial is exist or not -->
> > check RMA IT the RMA and MBSerial is valid or not -->
> > get MAC address from deactivate MBSerial(SMC)
> > get protal DB data via MAC

## Discussion after investigate
###### :calendar: 11/4 (Fri.) 10:00am

> ### Aubery
> 1. Feel free to modify code logic, is handover to you(Vito).
> 2. Notify rule has changed, [new doc](https://docs.google.com/spreadsheets/d/1wIP9HdWsVSnegGXqAVAMFpTmImaRfjNvOo0U8Qy3Akc/edit#gid=1452984416)
> 3. Soap API problem have to ask Matt
> 4. SSO problem could reference keycloak [offical site](https://www.keycloak.org/)

> ### Vito
> 1. almost no problem here.
> 2. maybe we could give some hint in Mac Address input
> 3. last isseue have to check with Violet
> while submit request, should we check customer_email with order's domain?
> 4. ==I have investigated the whole project.
> AD Server, PDBS is the last piece of developement==

## Web Team Meeting
###### :calendar: 11/2 (Wed.) 8:30am

> ### Francis:
> 1. What minium requirment needs to done
> => how many feature is lack currently
> => Release ASAP
> ==May: Propose a release plan ETF => Vito, Violet==
>
> 2. it is nessary to file upload on Mac address input field

> ### sb' in Indian(?)
> 1. Is there limitation of mac once input
> Violet: no ... limit?
> Vito: would invest that after i can retrieve product key server

> ### Ujar
> 1. How would be this service be serve
> Violet: its only for internal use