Department Computer Property Report

Reporting
1

(imported topic written by SystemAdmin)

I am working for a Department computer property Web report like this:

Department Win98 Win2000 WinXP Win2003 WinVista Pentium 4 Pentium M Pentium 3 Dept total
Network 200 210 300 200 60 20 600 800 2100
Market xx xx xx xx xx xx xx xx xx
Support xx xx xx xx xx xx xx xx xx
Design xx xx xx xx xx xx xx xx xx
Product xx xx xx xx xx xx xx xx xx

Total xx xx xx xx xx xx xx xx xx

I customed a property named department for each computer.

and I wirte the Relevance expression liks this:

<?Relevance trs of ( td of it & td of (number of computers whose( value of result(bes property "OS",it) contains "98")of it as string) & td of (number of computers whose( value of result(bes property "OS",it) contains "2000")of it as string) & td of (number of computers whose( value of result(bes property "OS",it) contains "WinXP")of it as string) & td of (number of computers whose( value of result(bes property "OS",it) contains "Win2003")of it as string) & td of (number of computers whose( value of result(bes property "OS",it) contains "Vista")of it as string) & td of (number of computers whose( value of result(bes property "CPU",it) contains "Pentium 4")of it as string) & td of (number of computers whose( value of result(bes property "CPU",it) contains "Pentium M")of it as string) & td of (number of computers whose( value of result(bes property "CPU",it) contains "Pentium 3")of it as string) & td of (number of computers of it as string) ) unique values of value of results of bes property "department" ?> Total <?Relevance number of bes computers whose( value of result(bes property "OS",it) contains "98") as string ?> <?Relevance number of bes computers whose( value of result(bes property "OS",it) contains "2000") as string ?> <?Relevance number of bes computers whose( value of result(bes property "OS",it) contains "WinXP") as string ?> <?Relevance number of bes computers whose( value of result(bes property "OS",it) contains "Win2003") as string ?> <?Relevance number of bes computers whose( value of result(bes property "OS",it) contains "Vista") as string ?> <?Relevance number of bes computers whose( value of result(bes property "CPU",it) contains "Pentium 4") as string ?> <?Relevance number of bes computers whose( value of result(bes property "CPU",it) contains "Pentium M") as string ?> <?Relevance number of bes computers whose( value of result(bes property "CPU",it) contains "Pentium 3") as string ?> <?Relevance number of bes computers ?>

but it does not work !

Could somebody help me . :frowning:

Thanks !

2

(imported comment written by SystemAdmin)

Or who can tell me how to get the unique property result object ?

I think the bottleneck problem is how to get the unique property result object is !

Please give me some suggestions.

thanks.

3

(imported comment written by BenKus)

Hey kollo44,

We haven’t forgot about you… but it turns out that this is a particularly hard report for us to generate because of the aggregation steps. I think we can come up with something, but I failed at my first attempt. Unfortunately, “unique values” only applies to strings, so it probably not going to work well in this case.

I will take another crack at it soon.

Ben

4

(imported comment written by SystemAdmin)

Hey Ben ,

Thanks for your replay!

I am very happy to see your replay.

Waiting for your good news!

Thanks very much!

:wink:

5

(imported comment written by BenKus)

Hey kollo44,

This report is particularly difficult to do in BES 6.0 because of the “double group by” element of the tables… The only way I can find at the moment is to make a separate relevance clause for each “cell” in your table.

Here is the basic piece:

number of bes computers whose( exist (value of result(bes property “OS”,it)) whose (it contains “2000”) AND exist (value of result(bes property “department”,it)) whose (it contains “Network”))as string

So you will substitute the different values as part of your chart… since you have a 9x5 table, it will have 45 of these types of relevance clauses.

In the end it will look something like this:

<?Relevance tr of ( td of (number of bes computers whose( exist (value of result(bes property "OS",it)) whose (it contains "98") AND exist (value of result(bes property "department",it)) whose (it contains "Network"))as string) & td of (number of bes computers whose( exist (value of result(bes property "OS",it)) whose (it contains "2000") AND exist (value of result(bes property "department",it)) whose (it contains "Network"))as string) & ... ) & tr of ( td of (number of bes computers whose( exist (value of result(bes property "OS",it)) whose (it contains "98") AND exist (value of result(bes property "department",it)) whose (it contains "Market"))as string) & td of (number of bes computers whose( exist (value of result(bes property "OS",it)) whose (it contains "2000") AND exist (value of result(bes property "department",it)) whose (it contains "Market"))as string) & ... ) ?>

Let me know if that works for you…

I think some of the newer “set operations” enhancements in the relevance language in the future versions of BES will help with these types of reports.

Ben

6

(imported comment written by SystemAdmin)

Hey ben!

Very happy to see your replay.

the method you told me work well.

Thank you very much,and I wait for the new version, with the feelings of excitement . :wink:

:wink: