Hardware Report

Reporting
1

(imported topic written by SystemAdmin)

So we are trying to pull a hardware report and we’ve come across two problems.

First, using web reports or the Excel Connector, there doesn’t seem to be a way to generate a cross platform report (windows, os x, linux). In this case we are talking things like Brand, CPU, memory, number of disks, serial #, etc.

Second, working within the confines of only being able to do os specific hardware reports, when using the Excel Connector we pull in the hardware inventory for windows and are given the choice of Concatenate Multi-Value Results or not. Choosing to concatenate seems to hide multiple values. Choosing not to concatenate results in 20+ rows of data for a single computer. Given that Excel may not be the best place to try to produce such a report, is there a way to do this in Web Reports other that the All Analysis report and then drilling down into the Hardware Analysis - which quite frankly is just visually disturbing for an Executive to look at and can’t be used for much analysis due to the way the data is presented?

2

(imported comment written by Lee Wei)

Hi John,

Since some hardware info like brand, cpu, memory are collected as separate Properties, you are correct that we cannot do a cross platform report. This is more a data collection issue than reporting.

On the 2nd issue with data concatenation, this might simply be an Excel row height issue. If you are using the default concatenation character of %0A (line feed), then the extra data is actually hidden by the height of the Excel Rows. Try Select All then Format/Row/AutoFit and you should see all the data.

Can you please verify that is the case?

Lee Wei