SMSDPMon.log – CSMSDPMonitoring::ReportStatusMessage failed; 0x80004005 during content validation

The following was logged in smsdpmon.log during content validation:

CSMSDPMonitoring::ReportPackageState failed; 0x80004005

CSMSDPMonitoring::ReportStatusMessage failed; 0x80004005

This occurred because the distribution point was using a self-signed certificate and the management point is in https mode.

The fix was to create a create and issue a custom client certificate template for distribution points as specified here.

ConfigMgr: Query to show the details of Client Operations

A co-worker asked me if there was a report to show the details of a Client Operation.  He had done a “Download Computer Policy” and there was 7 computers offline and he wanted to know the names of the 7 offline computers.

A search of the reporting services site shows nothing with “operation”:

so I created a query for myself.

To filter results, I put in a variable for CreatedBy and RequestedTime (to filter on a specific date).

declare @CreatedBy varchar (20) = 'xyz\_esmith'
declare @RequestedTime date = '03/01/2022'

select
s.Name0
, a.Name OperationName
, o.RequestedTime
, o.CollectionName
, o.IsExpired
, costat.LastMessageTime
, costat.IsFailed
, costat.IsUnknown
, costat.IsCompleted
, costat.IsNotApplicable
, costat.IsOffline
, costat.IsFailedOrNotApplicable
from v_ClientAction a
inner join vSMS_ClientOperation o on o.Id = a.Id
inner join v_ClientOperationTargets ot on ot.ID = a.Id
inner join v_R_System s on s.ResourceID = ot.MachineID
inner join vSMS_G_System_ClientOperationStatus costat on costat.MachineID = ot.MachineID and costat.ID = ot.ID
where
o.CreatedBy = @CreatedBy and cast (o.RequestedTime as date) = @RequestedTime
order by o.RequestedTime, a.Name, s.Name0