Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Report for most recent KB installed On date for each computer

I’m attempting to run a report that provides a single line per computer, showing the last time it received a KB. Right now I have only had success in generating a list of computers’ entire list of hotfixes, which includes old and new KBs and accrues up to 78 pages.

I could of course export this to excel and remove the lines there, but hoping there is a quicker way with PDQ itself. 

Thanks for any time and assistance you can provide!

0

Comments

2 comments
Date Votes
  • From PowerShell you could run

    Get-HotFix -ComputerName Yourcomputername | sort InstalledOn | select -Last 1

    You could also make a Inventory Tool for this.

    The issue I see making a Inventory Report is some of my Installed on fields only have a date and not a date and time.

    Thanks,

    Guy Josenhans

    Software Deployment Solutions 

      

    0
  • Thanks for the response, Guy!

    I'm fairly beginner/intermediate--do you mean run that powershell command on the host server? 

    Also not familiar with Inventory tools... any further instruction you can provide is very much appreciated.

    Thanks for your time. 

    0