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 Comments
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;
---------------------------------
Thanks for the Case Statement 🙂 .Adding into Post.