While writing a number of reports for a client, I came across this bug:
Titles within SMS Web report are incorrectly set and renamed to inappropriate column titles.
To demonstrate the issue I created a SMS web report using the following SQL statement:
Select v_GS_COMPUTER_SYSTEM.Name0 as ‘Name’,
v_GS_COMPUTER_SYSTEM.Domain0 as ‘Domain’,
v_GS_COMPUTER_SYSTEM.UserName0 as ‘User ID’
where v_GS_COMPUTER_SYSTEM.Name0 = @MachineName
Within Query Analyzer you get the expected results.
Within SMS Web report
Notice that the “Domain” is renamed within SMS Web report to “User Domain”.
Since we know that v_GS_COMPUTER_SYSTEM.Domain0 is equal to the domain of the PC and not the user, then the title of “User Domain” is incorrect. If this was to be correct then the user domain should be set to the local server name of “es-01” and not “gartek.tst”, therefore it should also not be titled “User Domain”. If anything it should be “PC’s Domain”.
I would be ok with the renaming of the column title if I had not manually specified a column title but I have manually specified a column title, so what is the deal?