Monday, January 30, 2012

SCCM SQL Query: Count known Service Accounts

This query helped me use SCCM to track down some service accounts that were running under the credentials of a recently terminated employee:

SELECT v_GS_SERVICE.StartName0 AS 'Service Account', COUNT(v_GS_SERVICE.StartName0) AS 'Count' FROM v_GS_SERVICE GROUP BY v_GS_SERVICE.StartName0 ORDER BY v_GS_SERVICE.StartName0
Very useful, especially since the services were failing to run because we suspended the account in AD as part of our term process! SCCM to the rescue...

No comments:

Post a Comment