SCCM Configmgr 2012 distribution Content status Message IDs and State Message IDs

The way SCCM Configmgr 2012 object information stored is changed from CM07 with respect to tables/views.

In SCCM Configmgr 2012,Status of content stored in dbo.vSMS_DistributionDPStatus view.This view basically contains information about packageID,content status,objectTypeID like what type of package is it(boot image or package/Application etc) and status message ID.

These status Message IDs and State Message IDs are translated here in more description way which will help you to take necessary action to fix them.

What is status messages and State Messages : status messages provide information about component behavior and data flow, whereas state messages provide a snapshot of the state of a process at a specific time. To know more about state messages,read here

Based on these status Message IDs,you can write customized SSRS report to know the status of package. (note: package can be treated as application,Boot images,SU packages etc).

You can use Case Statement while using these Status Messages Ids to put the description filed in reports.

 

Status Message ID: Description:
2303 Content was successfully refreshed
2323 Failed to initialize NAL
2324 Failed to access or create the content share
2330 Content was distributed to distribution point
2354 Failed to validate content status file
2357 Content transfer manager was instructed to send content to Distribution Point
2360 Status message 2360 unknown
2370 Failed to install distribution point
2371 Waiting for prestaged content
2372 Waiting for content
2380 Content evaluation has started
2381 An evaluation task is running. Content was added to Queue
2382 Content hash is invalid
2383 Failed to validate content hash
2384 Content hash has been successfully verified
2391 Failed to connect to remote distribution point
2398 Content Status not found
8203 Failed to update package
8204 Content is being distributed to the distribution Point
8211 Failed to update package

 

Message State IDs from dbo.vSMS_DistributionDPStatus  :

state Message IDs Description
1 Success
2 In Progress
4 Failed

 here is the case statement for the status Message ID's:

select PackageID, Name, StatusMessage =
CASE MessageID
WHEN ’2384′ THEN ‘Content hash has been successfully verified’
WHEN ’2330′ THEN ‘Content was distributed to distribution point’
WHEN ’2303′ THEN ‘Content was successfully refreshed’
WHEN ’2323′ THEN ‘Failed to initialize NAL’
WHEN ’2324′ THEN ‘Failed to access or create the content share’
WHEN ’2354′ THEN ‘Failed to validate content status file’
WHEN ’2357′ THEN ‘Content transfer manager was instructed to send content to Distribution Point’
WHEN ’2360′ THEN ‘Status message 2360 unknown’
WHEN ’2370′ THEN ‘Failed to install distribution point’
WHEN ’2371′ THEN ‘Waiting for prestaged content’
WHEN ’2372′ THEN ‘Waiting for content’
WHEN ’2380′ THEN ‘Content evaluation has started’
WHEN ’2381′ THEN ‘An evaluation task is running. Content was added to Queue’
WHEN ’2382′ THEN ‘Content hash is invalid’
WHEN ’2383′ THEN ‘Failed to validate content hash’
WHEN ’2391′ THEN ‘Failed to connect to remote distribution point’
WHEN ’2398′ THEN ‘Content Status not found’
WHEN ’8203′ THEN ‘Failed to update package’
WHEN ’8204′ THEN ‘Content is being distributed to the distribution Point’
WHEN ’8211′ THEN ‘Failed to update package’
ELSE ‘I dont know this MessageID’
END, LastUpdateDate, Status_at_LastUpdateDate =
CASE MessageState
WHEN ’1′ THEN ‘Success’
WHEN ’2′ THEN ‘In Progress’
WHEN ’4′ THEN ‘Failed’
ELSE ‘I dont know this MessageState’
END
from dbo.vSMS_DistributionDPStatus
ORDER BY PackageID;

 

----Reference Via danrichings Blog

2 Responses to "SCCM Configmgr 2012 distribution Content status Message IDs and State Message IDs"

  1. The described Query with CASE Statemant can look like this.

    --------------------------------------
    select PackageID, Name, StatusMessage =
    CASE MessageID
    WHEN '2384' THEN 'Content hash has been successfully verified'
    WHEN '2330' THEN 'Content was distributed to distribution point'
    WHEN '2303' THEN 'Content was successfully refreshed'
    WHEN '2323' THEN 'Failed to initialize NAL'
    WHEN '2324' THEN 'Failed to access or create the content share'
    WHEN '2354' THEN 'Failed to validate content status file'
    WHEN '2357' THEN 'Content transfer manager was instructed to send content to Distribution Point'
    WHEN '2360' THEN 'Status message 2360 unknown'
    WHEN '2370' THEN 'Failed to install distribution point'
    WHEN '2371' THEN 'Waiting for prestaged content'
    WHEN '2372' THEN 'Waiting for content'
    WHEN '2380' THEN 'Content evaluation has started'
    WHEN '2381' THEN 'An evaluation task is running. Content was added to Queue'
    WHEN '2382' THEN 'Content hash is invalid'
    WHEN '2383' THEN 'Failed to validate content hash'
    WHEN '2391' THEN 'Failed to connect to remote distribution point'
    WHEN '2398' THEN 'Content Status not found'
    WHEN '8203' THEN 'Failed to update package'
    WHEN '8204' THEN 'Content is being distributed to the distribution Point'
    WHEN '8211' THEN 'Failed to update package'
    ELSE 'I dont know this MessageID'
    END, LastUpdateDate, Status_at_LastUpdateDate =
    CASE MessageState
    WHEN '1' THEN 'Success'
    WHEN '2' THEN 'In Progress'
    WHEN '4' THEN 'Failed'
    ELSE 'I dont know this MessageState'
    END
    from dbo.vSMS_DistributionDPStatus
    ORDER BY PackageID;
    ---------------------------------

    Reply

Post Comment