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

Posted on June 12, 2009 by Eswar Koneti | 5 Comments | 6,862 Views

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′

5 Responses to "SCCM Report for computers with service status (started,stopped,disabled)"

Dominique Duchemin February 19, 2021 at 2:25 AM · Edit

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
1. Dominique Duchemin February 19, 2021 at 2:39 AM · Edit
  
  the error is:
  “An expression of non-boolean type specified in a context where a condition is expected “
  Reply
  1. Eswar Koneti February 20, 2021 at 12:46 PM · Edit
    
    Hi,
    Try wirh quotes ' where required. It looks like the blog convert the quotes to fancy quotes which is causing the issue.
    Reply
2. Eswar Koneti February 20, 2021 at 12:45 PM · Edit
  
  Hi,
  You need to replace the quotes with ''
  
  Thanks
  Eswar
  Reply
JPB March 6, 2014 at 1:58 AM · Edit

Cool Information... Thanks!
Reply