SCCM query

Question

Need SQL query for getting details like SCCM client is pass inactive ,passactive in unknown state for patch compliance details for any software update deployment.

Doc1

solved 0
aamir ansari 2020-07-12T10:06:50+05:30 5 Answers 158 views Beginner 0

Answers ( 5 )

  2. aamir ansari
    0
    2020-07-15T17:08:45+05:30
    Reply

    Hi Karthik ,

    i attached work document into question .need such information .

  4. aamir ansari
    0
    2020-07-14T10:34:32+05:30
    Reply

    thank you anoop ,

    let me check result for this query

  6. Anoop C Nair
    0
    2020-07-12T13:35:06+05:30
    Reply
    Best answer
  8. Anoop C Nair
    0
    2020-07-12T12:41:24+05:30
    Reply

    This is the query to find out inactive clients

  10. Anoop C Nair
    0
    2020-07-12T12:37:45+05:30
    Reply

    Declare @Collection varchar(8)
    Set @Collection = ‘SMS00001’
    select Distinct
    sys.name0 AS ‘Device’,
    CASE WHEN sys.Client0 = 1 THEN ‘YES’ WHEN sys.Client0 = 0 THEN ‘NO’ ELSE ‘NA’ END AS ‘ConfigMgr Client’,
    CASE WHEN sys.active0 = 1 THEN ‘YES’ WHEN sys.active0 = 0 THEN ‘NO’ ELSE ‘NO’ END AS ‘Active Client’,
    CASE WHEN sys.Obsolete0 = 1 THEN ‘YES’ WHEN sys.Obsolete0 = 0 THEN ‘NO’ ELSE ‘NA’ END AS ‘Obsolete Client’
    from v_r_system Sys

Leave an answer

Sorry, you do not have a permission to answer to this question .