Patching of Office 365 in languages that are not available in Patch Data import UI

Products

Patch Management Solution IT Management Suite Client Management Suite Server Management Suite

Issue/Introduction

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.

Environment

ITMS 8.x

Patch Management 8.x

Resolution

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.