Count of installed client agents

Use this query to get a count of installed client agents.

SELECT
v_GS_SMS_ADVANCED_CLIENT_STAT.DisplayName0 AS ‘Component’,
v_GS_SMS_ADVANCED_CLIENT_STAT.Version0 AS ‘Version’,
Count(v_GS_SMS_ADVANCED_CLIENT_STAT.Version0) AS ‘Count’
FROM
v_GS_SMS_ADVANCED_CLIENT_STAT v_GS_SMS_ADVANCED_CLIENT_STAT
Where
v_GS_SMS_ADVANCED_CLIENT_STAT.DisplayName0=’SMS Client Core Components’
GROUP BY
v_GS_SMS_ADVANCED_CLIENT_STAT.DisplayName0,
v_GS_SMS_ADVANCED_CLIENT_STAT.Version0

Leave a Reply

Your email address will not be published. Required fields are marked *