Thanks a lot Stuart. Let me read this several times!!!

reading https://www.logicmonitor.com/support/monitoring/applications-databases/microsoft-sql-server i am confuse if I have to use these properties on each device or is there a way to do it for all devices at one... Thanks, Dom

Hello, "set the jdbc.port property on the device." working on this now... Should it be a custom property as the jdbc properties already define for the cluster: mssql.mssqlserver.mssql_url jdbc:sqlserver://10.12.172.26:1438;integratedSecurity=true;applicationIntent=ReadOnly mssql.sqlclent1.mssql_url jdbc:sqlserver://10.12.172.26:1440;integratedSecurity=true;applicationIntent=ReadOnly mssql.sqlclent2.mssql_url jdbc:sqlserver://10.12.172.26:1436;integratedSecurity=true;applicationIntent=ReadOnly

Yes that was the issue I had... forcing the port works now... Let me try for the global Thanks, Dom

Hello I am not using the port 1433 so it is closed. Let me check how to redirect the port in the script to another port... Thanks, Dom

Hello, I changed back the DNS name to the IP I am getting a new error: Thanks, Dom

Hello, I saved the xml on my laptop then import it under Settings > Add> From File to _SSL_Certificates_All_Support I will have to dig more as now I have an error I never saw before!!! ' Thanks, Dom

Hello, I created a new DS _SSL_Certificates_all I am getting error for missing instance.. there might be something else preventing these scripts to work... I tried on several devices.... Thanks. Dom

Thanks

Hello, I have two and the column was added ... But still nothing... Any idea? Thanks, Dom

Hello, No a specific report through Alert Report ... https://xxxx.logicmonitor.com/santaba/uiv3/report/download.jsp?1600885411693 Thanks, Dom

Hello, The friendly name is in the field properties in the alert.... How to make it appearing in the report... Thanks, Dom

Hello, What does this error mean? I am trying to collect the information using the "_SSL Certificates Datasource" and Thanks, Dom

Hello, I have the discovery: and the Collector Attributes Looking to add the "FriendlyName" of the certificate on the report... Any idea? Thanks, Dom

I see the Friendly Name in the info on the device: auto.cert.friendlyname SCCM SCUP Signing Certificate