(In reply to Poonam Bhargava from comment #3) > Following changes have been done in sandbox: > > - A new formula field "Root Certificate Included?" has been added to determine if the certificate is included by any of the root stores. This field will be used in reports and programs to avoid future code changes when a new root store is added. > > - Please check the reports below to see the results generated by the new formula field: > "Root Certificate Included in Any RS" > "Intermediate Cert Included in Any RS" I checked both of these reports, and the results of "Root Certificate Included?" looks good. > > - On homepage, please scroll to the bottom to see a new custom component "Root Certs with Outdated Audit Statements". This sample shows data based on the logged in user. For a Root Store all records will be visible whereas for a CA only the records that are associated with the CA Owner are visible. > I am having difficulty with the logic. Please send me the current logic (in the code) that is used for determining when to send the current Mozilla audit emails: - Audit Reminder is sent when previous Audit Period End date is 1 year plus 31 days to 93 days old. - Overdue Notice is sent when previous Audit Period End date is 1 year plus 93 days to 150 days old. - Danger of being removed warning is sent when previous Audit Period End date is older than 1 year plus 150 days.
Bug 1734497 Comment 4 Edit History
Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.
(In reply to Poonam Bhargava from comment #3) > Following changes have been done in sandbox: > > - A new formula field "Root Certificate Included?" has been added to determine if the certificate is included by any of the root stores. This field will be used in reports and programs to avoid future code changes when a new root store is added. > > - Please check the reports below to see the results generated by the new formula field: > "Root Certificate Included in Any RS" > "Intermediate Cert Included in Any RS" I checked both of these reports, and the results of "Root Certificate Included?" looks good. > > - On homepage, please scroll to the bottom to see a new custom component "Root Certs with Outdated Audit Statements". This sample shows data based on the logged in user. For a Root Store all records will be visible whereas for a CA only the records that are associated with the CA Owner are visible. > I think the new logic should be: Don't list the certificate if (Today - Audit Period End date) < 365 Green: 365 < (Today - Audit Period End date) < 425 Yellow: 425 < (Today - Audit Period End date) < 455 Red: 455 < (Today - Audit Period End date)
(In reply to Poonam Bhargava from comment #3) > Following changes have been done in sandbox: > > - A new formula field "Root Certificate Included?" has been added to determine if the certificate is included by any of the root stores. This field will be used in reports and programs to avoid future code changes when a new root store is added. > > - Please check the reports below to see the results generated by the new formula field: > "Root Certificate Included in Any RS" > "Intermediate Cert Included in Any RS" I checked both of these reports, and the results of "Root Certificate Included?" looks good. > > - On homepage, please scroll to the bottom to see a new custom component "Root Certs with Outdated Audit Statements". This sample shows data based on the logged in user. For a Root Store all records will be visible whereas for a CA only the records that are associated with the CA Owner are visible. > I think the new logic should be: Don't list the certificate if (Today - Audit Period End date) < 365 Green: 365 < (Today - Audit Period End date) < 425 Yellow: 425 < (Today - Audit Period End date) < 455 Red: 455 < (Today - Audit Period End date) This report shows all Root Certificates which satisfy the criteria below: * Certificate is Included in any of Root Store * Certificate is not expired * Highlighted in Green: 365 < (Today - Audit Period End date) < 425 * Highlighted in Yellow: 425 < (Today - Audit Period End date) < 455 * Highlighted in Red: 455 < (Today - Audit Period End date)
(In reply to Poonam Bhargava from comment #3) > Following changes have been done in sandbox: > > - A new formula field "Root Certificate Included?" has been added to determine if the certificate is included by any of the root stores. This field will be used in reports and programs to avoid future code changes when a new root store is added. > > - Please check the reports below to see the results generated by the new formula field: > "Root Certificate Included in Any RS" > "Intermediate Cert Included in Any RS" I checked both of these reports, and the results of "Root Certificate Included?" looks good. > > - On homepage, please scroll to the bottom to see a new custom component "Root Certs with Outdated Audit Statements". This sample shows data based on the logged in user. For a Root Store all records will be visible whereas for a CA only the records that are associated with the CA Owner are visible. > Please don't list the certificate if (Today - Audit Period End date) < 365 And update the information at the top of the report to: This report shows all Root Certificates which satisfy the criteria below. * Certificate is Included in participating Root Stores * Certificate is not expired * Highlighted in Green: 365 < (Today - Audit Period End date) < 425 * Highlighted in Yellow: 425 < (Today - Audit Period End date) < 455 * Highlighted in Red: 455 < (Today - Audit Period End date)
(In reply to Poonam Bhargava from comment #3) > Following changes have been done in sandbox: > > - A new formula field "Root Certificate Included?" has been added to determine if the certificate is included by any of the root stores. This field will be used in reports and programs to avoid future code changes when a new root store is added. > > - Please check the reports below to see the results generated by the new formula field: > "Root Certificate Included in Any RS" > "Intermediate Cert Included in Any RS" I checked both of these reports, and the results of "Root Certificate Included?" looks good. > > - On homepage, please scroll to the bottom to see a new custom component "Root Certs with Outdated Audit Statements". This sample shows data based on the logged in user. For a Root Store all records will be visible whereas for a CA only the records that are associated with the CA Owner are visible. > Please don't list the certificate if (Today - Audit Period End date) < 365 And update logic and the information at the top of the report to: This report shows all Root Certificates which satisfy the criteria below. * Certificate is Included in participating Root Stores * Certificate is not expired * Highlighted in Green: 365 < (Today - Audit Period End date) < 425 * Highlighted in Yellow: 425 < (Today - Audit Period End date) < 455 * Highlighted in Red: 455 < (Today - Audit Period End date)