Support Forum: Get Support for Patch My PC Products and Services

Microsoft Configuration Manager and Intune (Enterprises/Paid) => Support and General Questions (Enterprises Using ConfigMgr and Intune) => Topic started by: PatchThings87635 on December 02, 2019, 11:20:40 AM

Title: SCCM Report Question - Patch Installation Time
Post by: PatchThings87635 on December 02, 2019, 11:20:40 AM
Hello!

Is anyone aware of a Patch My PC report within SCCM that does the following:

I want to report on Collection1 (which contains 4 systems) for November 21st, 2019 to see what patches were installed on each of the four systems and at what time the patches finished installing.

I'm looking for output similar to the attached image with the "Date" column being the time the patch finished installing.
Title: Re: SCCM Report Question - Patch Installation Time
Post by: Justin Chalfant (Patch My PC) on December 02, 2019, 02:17:07 PM
We don't have any that would show that date of install. Where did you pull this data in your screenshot?

Quote from: PatchThings87635 on December 02, 2019, 11:20:40 AM
Hello!

Is anyone aware of a Patch My PC report within SCCM that does the following:

I want to report on Collection1 (which contains 4 systems) for November 21st, 2019 to see what patches were installed on each of the four systems and at what time the patches finished installing.

I'm looking for output similar to the attached image with the "Date" column being the time the patch finished installing.
Title: Re: SCCM Report Question - Patch Installation Time
Post by: PatchThings87635 on December 02, 2019, 02:26:54 PM
The PSWindowsUpdate and ConfigurationManager PowerShell modules. Specifically, the Get-WUHistory command from the PSWindowsUpdate module.

PSWindowsUpdate
https://www.powershellgallery.com/packages/PSWindowsUpdate/2.0.0.4 (https://www.powershellgallery.com/packages/PSWindowsUpdate/2.0.0.4)

ConfigurationManager
https://docs.microsoft.com/en-us/powershell/sccm/overview?view=sccm-ps

I'm looking for a more friendly way to allow management etc. to run this report without needing to run scripts and was curious if this product had something along these lines.

Quote from: Justin Chalfant on December 02, 2019, 02:17:07 PM
We don't have any that would show that date of install. Where did you pull this data in your screenshot?

Quote from: PatchThings87635 on December 02, 2019, 11:20:40 AM
Hello!

Is anyone aware of a Patch My PC report within SCCM that does the following:

I want to report on Collection1 (which contains 4 systems) for November 21st, 2019 to see what patches were installed on each of the four systems and at what time the patches finished installing.

I'm looking for output similar to the attached image with the "Date" column being the time the patch finished installing.
Title: Re: SCCM Report Question - Patch Installation Time
Post by: Justin Chalfant (Patch My PC) on December 02, 2019, 02:28:04 PM
I don't believe SCCM exposes this level of detail to the ConfigMgr DB.
Title: Re: SCCM Report Question - Patch Installation Time
Post by: PatchThings87635 on December 02, 2019, 02:34:37 PM
Thank you for your reply Justin! If this type of report isn't currently available or possible given the way Patch My PC works, feel free to consider this topic closed. I was mostly here to check if something already existed.

Quote from: Justin Chalfant on December 02, 2019, 02:28:04 PM
I don't believe SCCM exposes this level of detail to the ConfigMgr DB.