We've had accidental deployment of mcs profiles and would like a way to monitor this.
Release : 20.3
Component : UIM - MON_CONFIG_SERVICE
To get the total row count for the number of deployments use:
select count(*) from ssrv2profile where latestDeploymentSummary like '%DEPLOYED%'
That query can be used with the sql_response probe.
To get the profile name and count this can be used:
select profilename,count(profilename) from ssrv2profile where latestDeploymentSummary like '%DEPLOYED%' group by profilename
SSRV2Profile is the table that keeps a record of profile deployements and the details.
For example: Successfully DEPLOYED profile LogmonE(19) in 2579ms to /9.2-DOM/P_hub/robot4/logmon
However every entry doesn't have to be for a deployment.
For example: Profile Setup ntevl has been CREATED
So the total row count will not be the true profile deployment count but will provide the best real life value for tracking.