Patch Management Solution

 View Only
  • 1.  Inv_AeX_OS_Quick_Fix_Engineering

    Posted Aug 25, 2016 04:40 PM

    I know at some point, probably all of 7.x, the Inv_AeX_OS_Quick_Fix_Engineering is gone. I need to generate a patch installation date report so I need to know the best way to do this in 7.6. Some notes I read made it look like that table may be back in 8.x, so what do I do in 7.x?

    I've tried to use ITA cubes, custom reports, and software execution dates. I purge the software exectution so that the data only exsists a couple months back. Is there a way to address this without writing a custom inventory? I don't understand why QFE is gone.



  • 2.  RE: Inv_AeX_OS_Quick_Fix_Engineering
    Best Answer

    Posted Aug 30, 2016 01:58 PM

    I didn't figure I would get a response these days so I just wrote a custom inventory to query the class.



  • 3.  RE: Inv_AeX_OS_Quick_Fix_Engineering
    Best Answer

    Posted Sep 28, 2016 05:20 PM

    On Error Resume Next

    strComputer = "." 
    Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2") 
    Set objCIMObj = objWMIService.ExecQuery("SELECT * FROM Win32_QuickFixEngineering",,48)
     
    'Create instance of Altiris NSE component
    dim nse
    set nse = WScript.CreateObject ("Altiris.AeXNSEvent")
    nse.To = "{1592B913-72F3-4C36-91D2-D4EDA21D2F96}"
    nse.Priority = 1

    dim objDCInstance
    set objDCInstance = nse.AddDataClass ("MS_QFE")
    'set objDCInstance = nse.AddDataClass ("{aa294d41-d56c-42f4-9bd2-ab5373d8363d}")

    dim objDataClass
    set objDataClass = nse.AddDataBlock (objDCInstance)

    'Populate the NSE file with desired data 
    For Each objInfo in objCIMObj

    'Add a new row for each update on the computer
    Dim objDataRow
    set objDataRow = objDataClass.AddRow

    objDataRow.SetField 0, objInfo.Caption
    objDataRow.SetField 1, objInfo.Description
    objDataRow.SetField 2, objInfo.HotFixID
    objDataRow.SetField 3, objInfo.InstalledBy
    objDataRow.SetField 4, objInfo.InstalledOn

    Next

    nse.SendQueued

     

     SELECT vComputer.[Name]
     ,QFE.Caption
     ,QFE.[Description]
     ,QFE.HotFixID
     ,QFE.InstalledOn
     ,QFE.InstalledBy

    FROM Inv_MS_QFE QFE
     LEFT JOIN vComputer
        ON vComputer.[Guid] = QFE.[_ResourceGuid]

    ORDER BY vComputer.[Name] ASC, QFE.[HotFixID] ASC
        



  • 4.  RE: Inv_AeX_OS_Quick_Fix_Engineering

    Posted Sep 28, 2016 05:29 PM

    Access Denied when I try to edit the post, so here is the dataclass.

     

    ms_qfe.png