If you look at certain pre-canned reports that come with SMS 2003, you'll notice some of them have wierd column names like C054, but show up in the report output as "Operating System". The reason behind this is that SMS was designed as a multi-language application that should be able to easily change its output based on the different languages of the users.
One of the first things you're going to want to know is what are all those C054, C056, etc. columns (how high does it go) and what do they mean?
There's a view v_LocalizedNameLookup that has the columns, but it doesn't include a list of what they mean, it contains a list of DLLS they use to do the lookups. So instead, let's just write a SQL query you can put into a report to see what they mean.
SELECT
'c001' AS c001,
'c002' AS c002,
'c003' AS c003,
'c004' AS c004,
'c005' AS c005,
'c006' AS c006,
'c007' AS c007,
'c008' AS c008,
'c009' AS c009,
'c010' AS c010,
'c011' AS c011,
'c012' AS c012,
'c013' AS c013,
'c014' AS c014,
'c015' AS c015,
'c016' AS c016,
'c017' AS c017,
'c018' AS c018,
'c019' AS c019,
'c020' AS c020,
'c021' AS c021,
'c022' AS c022,
'c023' AS c023,
'c024' AS c024,
'c025' AS c025,
'c026' AS c026,
'c027' AS c027,
'c028' AS c028,
'c029' AS c029,
'c030' AS c030,
'c031' AS c031,
'c032' AS c032,
'c033' AS c033,
'c034' AS c034,
'c035' AS c035,
'c036' AS c036,
'c037' AS c037,
'c038' AS c038,
'c039' AS c039,
'c040' AS c040,
'c041' AS c041,
'c042' AS c042,
'c043' AS c043,
'c044' AS c044,
'c045' AS c045,
'c046' AS c046,
'c047' AS c047,
'c048' AS c048,
'c049' AS c049,
'c050' AS c050,
'c051' AS c051,
'c052' AS c052,
'c053' AS c053,
'c054' AS c054,
'c055' AS c055,
'c056' AS c056,
'c057' AS c057,
'c058' AS c058,
'c059' AS c059,
'c060' AS c060,
'c061' AS c061,
'c062' AS c062,
'c063' AS c063,
'c064' AS c064,
'c065' AS c065,
'c066' AS c066,
'c067' AS c067,
'c068' AS c068,
'c069' AS c069,
'c070' AS c070,
'c071' AS c071,
'c072' AS c072,
'c073' AS c073,
'c074' AS c074,
'c075' AS c075,
'c076' AS c076,
'c077' AS c077,
'c078' AS c078,
'c079' AS c079,
'c080' AS c080,
'c081' AS c081,
'c082' AS c082,
'c083' AS c083,
'c084' AS c084,
'c085' AS c085,
'c086' AS c086,
'c087' AS c087,
'c088' AS c088,
'c089' AS c089,
'c090' AS c090,
'c091' AS c091,
'c092' AS c092,
'c093' AS c093,
'c094' AS c094,
'c095' AS c095,
'c096' AS c096,
'c097' AS c097,
'c098' AS c098,
'c099' AS c099,
'c100' AS c100
Number2 (John Nelson)
MyITForum - Forum Posts
MyITForum - Blog
