locked
Hotfix details using WMI query RRS feed

  • Question

  • Hi All,

    I'm trying to get the installed patches details along with dates using WMI ADDM query, but still installed date is missing. Is there any special permission required to get the installed date?

    Thanks in advance.


    vicky

    Tuesday, July 4, 2017 6:30 PM

All replies

  • Get-Hotfix

    or

    Get-CimInstance win32_QuickFixEngineering


    \_(ツ)_/

    Tuesday, July 4, 2017 9:12 PM
  • you can try with the below option .

    get-hotfix | select hotfixid, installedon | sort-object installedon 

    you can modify as per your requirement.

    Thanks


    Prashant Dev Pandey LIVE IN YOUR OWN WAY Please remember to mark the replies as answers if they help

    • Proposed as answer by Hello_2018 Wednesday, July 5, 2017 8:05 AM
    • Unproposed as answer by - vicky Monday, July 10, 2017 2:15 PM
    Wednesday, July 5, 2017 7:17 AM
  • Hi,

    >> but still installed date is missing. Is there any special permission required to get the installed date?

    Lots of methods:

    https://gallery.technet.microsoft.com/scriptcenter/PowerShell-script-to-list-0955fe87

    Best regards,

    Andy


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Wednesday, July 5, 2017 8:07 AM
  • On older versions of Windows this value may always be blank.


    \_(ツ)_/

    Wednesday, July 5, 2017 8:09 AM
  • Hi,

    I can get the installed date in locally but when trying from ADDM scan it's not coming up. The ADDM account have added into local administrator group.

    Below query is used from ADDM end.

    Query := "SELECT HotFixID,InstalledOn FROM Win32_QuickFixEngineering"; 148 149 if (host.os_version matches '2000') then 150 Query := Query + " "; // Dummy 151 else 152 Query := Query + " where HotFixID like 'KB%'"; 153 end if; 154 155 patches := discovery.wmiQuery(host, Query, raw "root\cimv2"); 156


    vicky

    Wednesday, July 5, 2017 10:17 AM
  • You are posting in the wrong forum for your issue.  You need to post in the vendor forum.  This forum cannot support third party products.


    \_(ツ)_/

    Wednesday, July 5, 2017 10:34 AM
  • Hi,

    If i run the below command in server locally, then it's showing installed date.

    Get-WmiObject -class Win32_QuickFixEngineering

    If i use the below command, then it's not showing the installed date.

    Get-WmiObject -class Win32_QuickFixEngineering -ComputerName "Target machine name"

    Is there any permission required while running from remote machine. Please advise.


    vicky

    Wednesday, July 5, 2017 12:59 PM
  • target machine powershell version is lower .Please cross check.

    Prashant Dev Pandey LIVE IN YOUR OWN WAY Please remember to mark the replies as answers if they help

    Wednesday, July 5, 2017 1:02 PM
  • Get-CimInstance -class Win32_QuickFixEngineering -ComputerName "Target machine name"

    If no dates then the remote machine is likely too old for that to be filled.


    \_(ツ)_/

    Wednesday, July 5, 2017 1:10 PM
  • But i can get the installed on dates using below command.

    Get-HotFix -computername <Target machine name> | % { $_.psbase.properties["installedOn"].Value }

    Any idea ?



    vicky

    Wednesday, July 5, 2017 2:26 PM
  • Hi,

    I'm running the below command from source server, and getting the informations for one server but for another server no informations. Is there any special permission required to get the details?

    Get-WmiObject -class Win32_QuickFixEngineering -ComputerName

    Note: In both the servers i've added into local administrators group.


    vicky

    Monday, July 10, 2017 2:17 PM
  • Older KBs will not have an install date.


    \_(ツ)_/

    Monday, July 10, 2017 2:20 PM
  • Both the servers have latest patches installed.

    vicky

    Monday, July 10, 2017 2:41 PM
  • Older OSs do not record Installed dates.


    \_(ツ)_/

    Monday, July 10, 2017 2:49 PM
  • It's Windows 2008 version.

    vicky

    Monday, July 10, 2017 3:09 PM
  • It should work on all WS2008r2 and later systems.


    \_(ツ)_/

    Monday, July 10, 2017 3:10 PM
  • Yes, but it's not working on that box. Even wmic qfe list command and returning with no instances available. 

    Is there any way to fix it?


    vicky

    Tuesday, July 11, 2017 7:02 AM
  • As I keep noting.  WS2008 and earlier do not support installed dates.


    \_(ツ)_/

    Tuesday, July 11, 2017 7:13 AM