State Message details (like for error description on a failed app
deployment)--apparently the best place for that is a place which can only be
read and interpreted from an SRS report. It's not actually "in" SQL to be
read. It's in companion files that your SSRS site will use for reports. I
suspect it's because of having to do language localizations--contrary to what
most of us on this list believe, not everyone speaks or runs their CM site in
English only. (go figure!)
So, for example, if you've created (or cloned) a SRS report, and one of the
values returned is "vAppDeploymentErrorAssetDetails.ErrorCode", what you do (in
SRS) is you have another column in your results. In that column instead of
referring to a field returned from your select whatever, whatever from
vAppDeploymentErrorAssetDetails... you instead fill that column with this
Expression by right-clicking Text Box Properties, under "General", Value: click
on the fx instead of the pull-down and type in this exactly:
=SrsResources.Localization.GetErrorMessage(Fields!ErrorCode.Value,
User!Language)
What that will do, is, for example if you have an errorcode returned for an
appdeployment of "-2016410844"... you won't have to go "huh?" Because the SRS
geterrormessage thing will tell you that (in English, since that's my
localization) that means "The application was not detected after installation
completed."
Of course... that's only gets you so far. There's still a lot of errorcodes
returned where the SRS localization thing resolves to "Unknown Error Code".
but at least you get SOME value out of some of the error codes.
On Thursday, August 27, 2015 1:29 PM, "Schwan, Phil"
<[email protected]> wrote:
<!--#yiv5920607690 _filtered #yiv5920607690 {font-family:Wingdings;panose-1:5
0 0 0 0 0 0 0 0 0;} _filtered #yiv5920607690 {font-family:"Cambria
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv5920607690
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv5920607690
{font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv5920607690
#yiv5920607690 p.yiv5920607690MsoNormal, #yiv5920607690
li.yiv5920607690MsoNormal, #yiv5920607690 div.yiv5920607690MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv5920607690 a:link, #yiv5920607690
span.yiv5920607690MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv5920607690 a:visited,
#yiv5920607690 span.yiv5920607690MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv5920607690
span.yiv5920607690EmailStyle17 {font-family:"Calibri",
sans-serif;color:#1F497D;}#yiv5920607690 span.yiv5920607690EmailStyle18
{font-family:"Calibri", sans-serif;color:#1F497D;}#yiv5920607690
span.yiv5920607690EmailStyle19 {font-family:"Calibri",
sans-serif;color:#1F497D;}#yiv5920607690 .yiv5920607690MsoChpDefault
{font-size:10.0pt;} _filtered #yiv5920607690 {margin:1.0in 1.0in 1.0in
1.0in;}#yiv5920607690 div.yiv5920607690WordSection1 {}-->Yeah, I caught that
after the fact. Reading carefully is importantJ -Phil From:
[email protected] [mailto:[email protected]]On Behalf
Of Andreas Hammarskjöld
Sent: Thursday, August 27, 2015 1:44 PM
To: [email protected]
Subject: RE: [mssms] State Message IDs State != Status Dont think there
is such a thing for state? From:[email protected]
[mailto:[email protected]]On Behalf Of Schwan, Phil
Sent: den 26 augusti 2015 21:06
To: [email protected]
Subject: RE: [mssms] State Message IDs Google foo isn’t there right now, but
Ben Rampe actually has a great script for parsing and analyzing status
messages:http://miscug.org/2015/03/05/ben-rampes-status-message-parsing-script/
-Phil _________________________________________________________________ Phil
Schwan | Technical Architect, Enterprise Windows Services Microsoft VTSP
([email protected]) Project Leadership Associates|2000 Town Center, Suite
1900, Southfield, MI 48075 Lync: 312.756.1626 Mobile: 419.262.5133
www.projectleadership.net Lead with Strategy. Leverage Technology. Deliver
Results. From:[email protected]
[mailto:[email protected]]On Behalf Of Nick Scott
Sent: Wednesday, August 26, 2015 3:00 PM
To: [email protected]
Subject: [mssms] State Message IDs Does anyone have a list of all the State
Message IDs for ConfigMgr? I'm trying to building out some audit reports and
I want to be able to display what the message IDs actually mean. Nick
