Our customer has asked us to provide them with a list of SSL that is due renewal between X date and X date. As they have nearly 1k SSL, can you please help us with an automated way to do this? Do you already have a WHMCS report or anything like that?
I have some ideas:
Perhaps with a SQL statement to query the WHMCS database directly.
Perhaps via API to query GGSSL directly.
Potential issues:
Need to only display SSL for a selected customer.
Need to only display SSL due renewal between X date and X date.
Some SSL in WHMCS do not have renewal date as they are (one time).
Some SSL in WHMCS are 2 year (but really 1 year via subscription)
Attached is a screenshot of an example SSL in WHMCS, as you can see the Registration Date, Next Due Date, and Expires Date all different. Its the Expires date we need to sort by.
Hi there,
Our customer has asked us to provide them with a list of SSL that is due renewal between X date and X date. As they have nearly 1k SSL, can you please help us with an automated way to do this? Do you already have a WHMCS report or anything like that?
I have some ideas: Perhaps with a SQL statement to query the WHMCS database directly. Perhaps via API to query GGSSL directly.
Potential issues: Need to only display SSL for a selected customer. Need to only display SSL due renewal between X date and X date. Some SSL in WHMCS do not have renewal date as they are (one time). Some SSL in WHMCS are 2 year (but really 1 year via subscription)
Attached is a screenshot of an example SSL in WHMCS, as you can see the Registration Date, Next Due Date, and Expires Date all different. Its the Expires date we need to sort by.
Thanks for any help with this. C