It has been brought to my attention that a report I generate weekly
from the TEM Excel Connector contains a few lines of incorrect data.
The report simply returns the values of the "Microsoft SQL Server and
Client Tools Version Detection" analysis (Analysis #54) from the BES
Inventory and License site. I submit this report weekly to our SQL
When I run the report from the Excel connector for whatever reason I
get values for servers that do not have the specified SQL components
that are stated in the report. When I look at the analysis in the
console or view a report from WebReports I do not see this data.
Basically, I do not know where this data is coming from.
Is the data old data that needs to be cleaned out of the database?
Having this is putting in question the integrity of any report run via
the Excel connector.
This topic has been locked.
Pinned topic Excel Connector Returns Erroneous Data
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Re: Excel Connector Returns Erroneous Data2012-10-09T21:20:28ZThis is the accepted answer. This is the accepted answer.Hi Andrew,
Sorry to hear of the problem.
I tried to call you to help but could not get through to x28107.
You can send me your contact info to leewei at us.ibm.com.
In the meantime, there is a "Show Relevance Code" button in the Excel Connector menu.
You can copy the statement and run it separately outside of the Excel Connector to double-check on the data being returned.
The best place to test the Session Relevance statement is:
Re: Excel Connector Returns Erroneous Data2012-10-10T19:29:09ZThis is the accepted answer. This is the accepted answer.We determined that Web Reports is incorrectly reporting data when the endpoints are no longer relevant to an Analysis.
This symptom is similar to bug# 41728 titled, "Analysis results appear for computers which are no longer reporting values when an analysis property column added to Explore Computers"
SystemAdmin 110000D4XK104 Posts
Re: Excel Connector Returns Erroneous Data2012-10-10T19:33:35ZThis is the accepted answer. This is the accepted answer.Thank you, is there an ETA on the bug already reported?
Re: Excel Connector Returns Erroneous Data2012-10-10T20:26:16ZThis is the accepted answer. This is the accepted answer.
Re: Excel Connector Returns Erroneous Data2012-10-10T20:45:52ZThis is the accepted answer. This is the accepted answer.
- Lee Wei 270003U2EX