SQL Certificates | Product Discussions

Dominique · 2020-05-27T04:19:17Z

Hello, I am trying to collect the SQL Certificates obtain by "Select name, expiry_date from sys.certificates" to have an alert when their expiration date arrived. I tried by datasource but apparently it is not feasible after consultation with LM Support. I was directed to Property Sources but not finding my way in this new environment... Any groowvy script to be used for that? <span class="pln">import com.santaba.agent.groovyapi.expect.Expect; import com.santaba.agent.groovyapi.snmp.Snmp; import com.santaba.agent.groovyapi.http.*; import com.santaba.agent.groovyapi.jmx.*; import org.xbill.DNS.*; import groovy.sql.Sql // needed for SQL connection and query def hostname = hostProps.get("system.hostname"); import groovy.sql.Sql // needed for SQL connection and query def url = "jdbc:sqlserver://" + hostname + ";databaseName=master;integratedSecurity=true"; def driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; sql = Sql.newInstance(url, driver) // connects to SQL server def query_result = sql.firstRow("SELECT name, expiry_date from sys.certificates") full_name_certificate = query_result.name full_date_certificate = query_result.expiry_date sql.close() // Close connection ... return 0;</span> This part looks okay but how to get the information in the Alert... ... Thanks, Dom

MoreDiscussions

SQL Certificates | Product Discussions | LogicMonitor Community