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

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

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