query to count deployed MCS profiles

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We've had accidental deployment of mcs profiles and would like a way to monitor this. 

Environment

Release : 20.3

Component : UIM - MON_CONFIG_SERVICE

Resolution

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

Additional Information

Note:

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.