Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog

Summary Report Fix

Created: 27 Sep 2007 • 3 comments
Andrew Souter's picture
0 0 Votes
Login to vote

There is a known problem that sometimes arises when using Summary report definition. The COUNT does not report correctly but when drilling down the next level of the report is correct. For example the summary level of the report might show 58 computers of a particular operating system but when you drill down there are 65 computers listed, which is the correct number.

The issue usually surfaces when selecting data from multiple tables. To limit the data to the resource type selected, a view called vResourceEx is used. When fields are selected from the other tables the combining of the data from the view and the other tables is not done properly. It is simple to correct the problem with just a few steps using the Advanced edit button which opens the Report Query Builder.

  1. Open a summary report
  2. Click Edit this report.
  3. Click Advanced.
  4. In Selected Objects on the right side of the dialog, select vResourseEx.
  5. Click Remove.
  6. Click Next.
  7. In the middle of the screen on the right side, click the X icon to delete the INNER JOIN string.
  8. Click Next four times to access the Test your query page.
  9. Click Finish.
  10. Click Apply.

Steps 4-7 are the steps required to fix this issue and can be used with any Summary report.

Comments 3 CommentsJump to latest comment

jjesse's picture

Does this problem exists with any of the pre-defined reports Altiris has or is it just w/ custom reports?

If it happens w/ pre-defined reports then the first report needs to be to clone the report.

Jonathan

Jonathan Jesse Practice Principal ITS Partners

-1
Login to vote
Andrew Souter's picture

This will happen on any Summary reports, simple reports are not affected.

A

+2
Login to vote
xmoreland's picture

It will happen with predefined and custom reports. It is all in how you write them. Thanks for the info, this is something I had not gotten around to trying to look at yet...but it is something I was aware of.

+2
Login to vote