Patch Management only allows a certain set of languages to be selected. Office 365 allows many more languages. Thus there are many languages in Office 365 that are not available in the Patch Data Import UI and so we needed another solution so that Patch Management can patch these other languages.
ITMS 8.x
Patch Management 8.x
We need to modify the stored procedure, spPMCore_GetPatchCultureOptionLCID, which allows it to bring in other languages that are supported by Office 365.
To do this, find the language in the list below, and add the cultures as needed to the stored procedure, as noted below:
ALTER procedure [dbo].[spPMCore_GetPatchCultureOptionLCID]
@cultureGuids varchar(max) = null
as
begin
select c.Locales from
Inv_Patch_Culture_Option c
join fnGuidStrToUniqueGuidTab (@cultureGuids) s on c._ResourceGuid = s.ui
union select '46A, 425' -- these are example values - use appropriate culture values, comma separated, from the table below for your situation
END
Find the Culture in the table below:
Locale | LCID | Culture |
af-za | 1078 | 436 |
am-et | 1118 | 45e |
ar-sa | 1025 | 401 |
as-in | 1101 | 44d |
az-latn-az | 1068 | 42c |
be-by | 1059 | 423 |
bg-bg | 1026 | 402 |
bn-bd | 2117 | 845 |
bn-in | 1093 | 445 |
bs-latn-ba | 5146 | 141a |
ca-es | 1027 | 403 |
ca-es-valencia | 2051 | 803 |
cs-cz | 1029 | 405 |
cy-gb | 1106 | 452 |
da-dk | 1030 | 406 |
de-de | 1031 | 407 |
el-gr | 1032 | 408 |
en-us | 1033 | 409 |
es-es | 3082 | c0a |
es-mx | 2058 | 80a |
et-ee | 1061 | 425 |
eu-es | 1069 | 42d |
fa-ir | 1065 | 429 |
fi-fi | 1035 | 40b |
fil-ph | 1124 | 464 |
fr-ca | 3084 | c0c |
fr-fr | 1036 | 40c |
ga-ie | 2108 | 83c |
gd-gb | 1169 | 491 |
gl-es | 1110 | 456 |
gu-in | 1095 | 447 |
ha-latn-ng | 1128 | 468 |
he-il | 1037 | 40d |
hi-in | 1081 | 439 |
hr-hr | 1050 | 41a |
hu-hu | 1038 | 40e |
hy-am | 1067 | 42b |
id-id | 1057 | 421 |
ig-ng | 1136 | 470 |
is-is | 1039 | 40f |
it-it | 1040 | 410 |
ja-jp | 1041 | 411 |
ka-ge | 1079 | 437 |
kk-kz | 1087 | 43f |
km-kh | 1107 | 453 |
kn-in | 1099 | 44b |
kok-it | 1111 | 457 |
ko-kr | 1042 | 412 |
ky-kg | 1088 | 440 |
lb-lu | 1134 | 46e |
lt-lt | 1063 | 427 |
lv-lv | 1062 | 426 |
mi-nz | 1153 | 481 |
mk-mk | 1071 | 42f |
ml-in | 1100 | 44c |
mn-mn | 1104 | 450 |
mr-in | 1102 | 44e |
ms-my | 1086 | 43e |
mt-mt | 1082 | 43a |
nb-no | 1044 | 414 |
ne-np | 1121 | 461 |
nl-nl | 1043 | 413 |
nn-no | 2068 | 814 |
nso-za | 1132 | 46c |
or-in | 1096 | 448 |
pa-in | 1094 | 446 |
pl-pl | 1045 | 415 |
prs-af | 1164 | 48c |
ps-af | 1123 | 463 |
pt-br | 1046 | 416 |
pt-pt | 2070 | 816 |
quz-pe | 3179 | c6b |
rm-ch | 1047 | 417 |
ro-ro | 1048 | 418 |
ru-ru | 1049 | 419 |
rw-rw | 1159 | 487 |
sd-arab-pk | 2137 | 859 |
si-lk | 1115 | 45b |
sk-sk | 1051 | 41b |
sl-si | 1060 | 424 |
sq-al | 1052 | 41c |
sr-cyrl-ba | 7194 | 1c1a |
sr-cyrl-rs | 10266 | 281a |
sr-latn-rs | 9242 | 241a |
sv-se | 1053 | 41d |
sw-ke | 1089 | 441 |
ta-in | 1097 | 449 |
te-in | 1098 | 44a |
th-th | 1054 | 41e |
tk-tm | 1090 | 442 |
tn-za | 1074 | 432 |
tr-tr | 1055 | 41f |
tt-ru | 1092 | 444 |
ug-cn | 1152 | 480 |
uk-ua | 1058 | 422 |
ur-pk | 1056 | 420 |
uz-latn-uz | 1091 | 443 |
vi-vn | 1066 | 42a |
wo-sn | 1160 | 488 |
xh-za | 1076 | 434 |
yo-ng | 1130 | 46a |
zh-cn | 2052 | 804 |
zh-tw | 1028 | 404 |
zu-za | 1077 | 435 |
After making this change if we already have Office 365 package staged and a Policy created please do the following:
Go to the Patch Remediation Center, Right- Click the Office 365 bulletin, and select "Recreate Packages", as shown below.
Repeat this process for any existing O365 bulletins that have a Policy already created.
Any new bulletins / Policies that are created will download the right bulletins and so no modifications are needed.
After the updated policy is received by the client, the update should be installed successfully.
Note: The stored procedure needs to be updated after every ITMS Upgrade.