Close Menu
    Facebook X (Twitter) Instagram
    Tuesday, May 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM Report for computers with service status (started,stopped,disabled)

    SCCM Report for computers with service status (started,stopped,disabled)

    Eswar KonetiBy Eswar KonetiJune 12, 5:10 pm1 Min Read SCCM 2007 12,151 Views
    Share
    Facebook Twitter LinkedIn Reddit

    select Distinct
    CS.Name0,
    SER.Displayname0,
    SER.Started0,
    SER.StartMode0,
    SER.State0
    from
    dbo.v_GS_COMPUTER_SYSTEM CS,
    dbo.v_GS_SERVICE SER,
    dbo.v_FullCollectionMembership FCM
    where
    CS.ResourceId = SER.ResourceID
    and CS.ResourceId = FCM.ResourceID
    and SER.displayname0 like ‘%firewall%’
    and (SER.State0 != ‘Running’ or Isnull(SER.State0,”)=”)
    and FCM.CollectionID = ‘SMS00001′

    Configmgr 2007 configmgr report running SCCM 2007 sccm report for services with status SCCM Reports service status SMS SQL started stopped
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    Efficiently Identify Co-Managed Devices: Techniques and Tools

    January 17, 8:37 pm

    SCCM report list collections with no deployments

    December 05, 12:04 pm

    9 Comments

    1. Anil on February 5, 2024 8:04 PM

      SELECT DISTINCT
      CS.Name0,
      SER.Displayname0,
      SER.Started0,
      SER.StartMode0,
      SER.State0
      FROM
      dbo.v_GS_COMPUTER_SYSTEM CS,
      dbo.v_GS_SERVICE SER,
      dbo.v_FullCollectionMembership FCM
      WHERE
      CS.ResourceId = SER.ResourceID
      AND CS.ResourceId = FCM.ResourceID
      AND SER.displayname0 LIKE '%Service%'
      AND (SER.State0 != 'Running' OR ISNULL(SER.State0,'')='')
      AND FCM.CollectionID = 'SMS00001';

      Reply
    2. Dominique Duchemin on February 19, 2021 2:25 AM

      Hello,

      I have an issue with the syntax in

      Isnull(SER.State0,”)=”) or Isnull(SER.State0,’)=’)

      the double quotes or single quotes did not work…
      What could be the correct syntax?

      Thanks,
      Dom

      Reply
      • Dominique Duchemin on February 19, 2021 2:39 AM

        the error is:
        “An expression of non-boolean type specified in a context where a condition is expected “

        Reply
        • Eswar Koneti on February 20, 2021 12:46 PM

          Hi,
          Try wirh quotes ' where required. It looks like the blog convert the quotes to fancy quotes which is causing the issue.

          Reply
        • Wahyu on March 29, 2022 6:42 PM

          hii. i also face same problem. can u help me ?

          Reply
          • Eswar Koneti on April 7, 2022 9:31 PM

            Hi,
            what is the issue you are having?

            Thanks,
            Eswar

            Reply
      • Eswar Koneti on February 20, 2021 12:45 PM

        Hi,
        You need to replace the quotes with ''

        Thanks
        Eswar

        Reply
      • Anil on February 5, 2024 8:06 PM

        SELECT DISTINCT
        CS.Name0,
        SER.Displayname0,
        SER.Started0,
        SER.StartMode0,
        SER.State0
        FROM
        dbo.v_GS_COMPUTER_SYSTEM CS,
        dbo.v_GS_SERVICE SER,
        dbo.v_FullCollectionMembership FCM
        WHERE
        CS.ResourceId = SER.ResourceID
        AND CS.ResourceId = FCM.ResourceID
        AND SER.displayname0 LIKE '%Service%'
        AND (SER.State0 != 'Running' OR ISNULL(SER.State0,'')='')
        AND FCM.CollectionID = 'SMS00001';

        Reply
    3. JPB on March 6, 2014 1:58 AM

      Cool Information... Thanks!

      Reply

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

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

    Type above and press Enter to search. Press Esc to cancel.