SQL Query

Question

Need SQl query to get detail when last patch installed with kb details like current month or last month .

solved 0
aamir ansari 9 months 2020-07-22T10:59:39+05:30 4 Answers 119 views Beginner 0

Answers ( 4 )

  1. aamir ansari
    0
    2020-07-24T20:52:13+05:30
    Reply

    ok let me check this .

  2. Ankit Shukla
    1
    2020-07-24T14:18:58+05:30
    Reply

    Make sure you have v_GS_QUICK_FIX_ENGINEERING class enabled in hardware inventory.

  3. Ankit Shukla
    0
    2020-07-24T12:07:32+05:30
    Reply

    Try this one, change the Patches accordingly and define them.Also define the collection against which you want to run it.

    Declare @CollID char(8)
    Set @CollID = ‘C0001420’
    SELECT
    COMP.name0 as ‘Host Name’,
    COMP.operatingSystem0,
    case when HOTFIX.HotFixID0 =’KB4561643′ then ‘Jun 20′
    when HOTFIX.HotFixID0 =’KB4556836’ then ‘May 20′
    when HOTFIX.HotFixID0 =’KB4550964’ then ‘Apr 20′
    when HOTFIX.HotFixID0 =’KB4540688’ then ‘Mar 20′
    when HOTFIX.HotFixID0 =’KB4537820’ then ‘Feb 20′
    when HOTFIX.HotFixID0 =’KB4534310’ then ‘Jan 20′
    when HOTFIX.HotFixID0 =’KB4530734’ then ‘Dec 19’ end ‘Patch Level’
    from v_r_system COMP
    JOIN v_FullCollectionMembership FCM
    ON COMP.resourceID = FCM.resourceID
    JOIN v_GS_QUICK_FIX_ENGINEERING HOTFIX
    ON FCM.resourceID = HOTFIX.resourceID
    WHERE FCM.CollectionID = @CollID
    AND (HOTFIX.HotFixID0 = ‘KB4561643’ OR
    HOTFIX.HotFixID0 = ‘KB4556836’ OR HOTFIX.HotFixID0 = ‘KB4550964’ OR HOTFIX.HotFixID0 = ‘KB4540688’ OR
    HOTFIX.HotFixID0 = ‘KB4537820’ OR HOTFIX.HotFixID0 = ‘KB4534310’ OR HOTFIX.HotFixID0 = ‘KB4537820’ OR
    HOTFIX.HotFixID0 = ‘KB4530734’)

    Best answer
  4. Anoop C Nair
    0
    2020-07-23T07:31:25+05:30
    Reply

    It’s not easy to build a specific query like this

    But the best way is to get the report using PowerShell script

    https://www.anoopcnair.com/powershell-script-patch-installation-status/

Leave an answer

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