question

NeeleshTiwari-7891 avatar image
0 Votes"
NeeleshTiwari-7891 asked Amandayou-MSFT answered

How to schedule a report in SCCM

Hello All,

I have the below posh command which return me a last patch and HotFix ID from all systems so I wanted to know how can I schedule as a report from SCCM server.

$lastpatch= Get-HotFix | Sort-Object InstalledOn -Descending | select-object -first 1 | Select-Object InstalledOn, HotfixID
"{0:MM/dd/yyyy} - {1}" -f $lastpatch.InstalledOn,$lastpatch.HotfixID | Write-Output

mem-analytics-reporting
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Garth avatar image
0 Votes"
Garth answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Garth avatar image
0 Votes"
Garth answered

Btw knowing the last su applied is useless, as it will not tell use if there are missing su that got skipped over.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered

Hi @NeeleshTiwari-7891,

About Equivalent SCCM Report to Powershell "Get-Hotfix" for a single computer, we could enable win32_quickfixengineering class from hardware inventory, then all these information will be collected by SCCM including installed date in SQL DB view v_GS_QUICK_FIX_ENGINEERING FIX, see below query, create a SSRS report and use it.

select
rs.Name0,
fix.Description0,
fix.HotFixID0,
fix.InstalledBy0,
fix.InstalledOn0
from v_GS_QUICK_FIX_ENGINEERING FIX,v_R_System RS
where fix.ResourceID = rs.ResourceID and rs.Name0 = 'clientName'
order by CAST(InstalledOn0 as datetime)

The article about SCCM DCM Inventory for Installed Windows Hotfixes, please refer to this article:
https://t3chn1ck.wordpress.com/2010/10/20/sccm-dcm-inventory-for-installed-windows-hotfixes/
Note: This is non-official Microsoft article just for your reference.



If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.