Is there a table or InfoProvider in SOLMAN that stores the about to Expire ABAP or J2EE Certificates

[S0000587367]

I would like to create a Report to rapidly check if any of the ABAP or J2EE Certificates could expire within 90 days.

That report could be use to create a BEx query for a Dashboard presentation.

Any help finding where that data is store within Solman 7.2?

Thanks,

Jose

[bglobee]

Hi,

did you check SAP Note https://me.sap.com/notes/0002507235

this has all the relevant info. after the configuration, it has to be integrated with System Monitoring framework to generate alerts.

[bglobee]

Use configuration validation. this supports monitoring the certificate expiry for both ABAP and JAVA systems.

I did this and it works amazingly well. It has flexible monitoring notifications. you can configure notification email alerting as well.

BR

Balaji

[S0000587367]

Balaji,

thanks for the reply. I do find both ABAP and JAVA Expiring Certificates, though need to create 2 views, one for ABAP and one for JAVA, since there is not an option to enter 2 different ConfigStore Names in 'configuration validation'.

But I cannot see from where to send an email in that page.

Also, I click on the "Save View" icon on the page but then I cannot find the URL with the results. where was it saved?

SAP does not make things easy.

Regards,

Jose

[VigneshPrabhu99]

Hello jose.delacruz4

There is already a standard SAP report SSF_ALERT_CERTEXPIRE that is available in SAP Solution Manager system to check the expiry of certificates based on days we give as input.

Check if this report helps you in your use case.

Thanks,

Vignesh

[S0000587367]

Thanks a lot Vignesh,

since Solution Manager, via Alert Search or Alert Inbox, shows the Certificates, both ABAP and JAVA, that are about to expire some 30 days prior to expiration for itself and FROM ALL Managed systems connected to it. I thought that information, the "Valid To" date or Expiration date of a certificate, either ABAP or JAVA, was store, for all systems connected to the Solution Manager systems, in either a table or an InfoProvider.

I know report SSF_ALERT_CERTEXPIRE gives me the Certificate about to expire in RED, but that is for each system.

Again, i thought, that since Solution Manager collects and reports from all Managed Systems, there is or were a 'central store place' for that 'Valid To' information that I could use for a more proactive reporting or to know quickly which Certificates are about to expire instead of waiting for individual alerts.

Regards,

Jose

[VigneshPrabhu99]

Hello Jose,

Maybe you can proactively monitor the certificate expiry by scheduling a background job with this report as input.

This ensures you don't need to wait for individual alerts.

Try your luck,

Kindly mark my answer as correct / helpful if it really helped you in any means.

Regards,

Vignesh

[liesebosch]

Hi Jose,

Use the Functional Module /SDF/SLIC_READ_LICENSE_700, or analyze it and see what tables it uses.

Also for information there is such a free utility sapometer. It has a "License Overview" metric. With it, you can build such a Dashboard:

Best wishes

Liese

[S0000587367]

Thanks Liese for the prompt response. But, perhaps i was not too clear. I meant for the Certificates in Transaction STRUST for ABAP and the ones for JAVA = J2EE.

Regards,

Jose