All about Microsoft Endpoint Manager
  • Home
  • SCCM
    • Collections
    • OS Deployment
    • Troubleshooting Tips
    • Scripting
      1. PowerShell
      2. VB Script
    • SCCM Tools
  • SCCM Reports
  • Intune
  • About Author
Tuesday, 2 March 2021

Tags: sccm report for service set to AUTO

List all PC where a service is set to automatically start and the service is not “Running”

Posted on January 3, 2010 by Eswar Koneti | 0 Comments | 289 Views
SELECT GS.Name0 as 'PC Name', GSS.DisplayName0 as 'Service', GSS.StartMode0 as 'Startup', GSS.State0 as 'State' FROM v_GS_SERVICE GSS, v_GS_COMPUTER_SYSTEM GS Where GSS.StartMode0 = 'Auto' and GSS.State0 != 'Running' and GSS.ResourceID = GS.ResourceID ORDER BY GS.Name0, GSS.DisplayName0 Thanks to jones for original post.
Read more »

Eswar Koneti

Looking for Consulting services?

Awards

  • Latest
  • Popular
  • Comments
  • Did you miss to download your samples from Technet Gallery Here is how you can do it.

    Did you miss to download your samples from Technet Gallery Here is how you can do it.

    February 27, 2021
  • Using PowerShell – Retrieve the o365 audit logs for SharePoint sites

    Using PowerShell – Retrieve the o365 audit logs for SharePoint sites

    February 9, 2021
  • SCCM Collection for AAD joined devices (co-managed)

    SCCM Collection for AAD joined devices (co-managed)

    February 5, 2021
  • How to disable Firewall and network protection notifications using Microsoft Intune

    How to disable Firewall and network protection notifications using Microsoft Intune

    January 29, 2021
  • SCCM ConfigMgr report for local admins and local group members

    SCCM ConfigMgr report for local admins and local group members

    March 9, 2017
  • Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

    Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

    March 25, 2010
  • SCCM Configmgr Troubleshooting Client software update issues

    SCCM Configmgr Troubleshooting Client software update issues

    April 7, 2015
  • SCCM report/collection for computers with Internet Explorer with different versions

    April 21, 2010
  • Eswar Koneti hi Bob, Here is how you can download the samples from Techne
  • Eswar Koneti Hi Bob, Here is how you can download the samples from Techne
  • Bob Fitz Hey, Could you share the updated link to the source file "RD
  • Bob Fitz I know this is an old article. But wondering if the report i

.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 7,118 other subscribers

@eskonr on Twitter

Tweets Eswar

All Rights Reserved

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

Archives

.

© Copyright 2009-2021 Eswar Koneti , All rights reserved.