Huh?

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’

from v_GS_COMPUTER_SYSTEM

where v_GS_COMPUTER_SYSTEM.Name0 = @MachineName

 

Within Query Analyzer you get the expected results.

wre

Within SMS Web report

 

wre2

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?

 

Leave a Reply

Your email address will not be published. Required fields are marked *