This query will give you a count of services.
SELECT GSS.DisplayName0 AS ‘Service Name’, Count(GSS.DisplayName0) AS ‘Count’
FROM v_GS_SERVICE GSS
GROUP BY GSS.DisplayName0
ORDER BY GSS.DisplayName0
This query will give you a count of services.
SELECT GSS.DisplayName0 AS ‘Service Name’, Count(GSS.DisplayName0) AS ‘Count’
FROM v_GS_SERVICE GSS
GROUP BY GSS.DisplayName0
ORDER BY GSS.DisplayName0
Recent Comments