(imported comment written by homer91)
I am trying to write a custom report to pull all the data now and am using this
| Computer Name,Hewlett-Packard Battery Info |
<?Relevance
trs of (td of
(
(if exists (name of it) then (name of it) else "N/A") &
"," & (if (exists results (it, bes property "HP batt design capacity (temp)")) then (if (exists (values of results (it, bes property "HP batt design capacity (temp)"))) then
concatenation "," of (values of results (it, bes property "HP batt design capacity (temp)")) else "N/A") else "N/A")
)
)
of bes computers whose
(
(
(
(exists result (it, bes property "Computer Manufacturer")) and (exists (value of result (it, bes property "Computer Manufacturer")))
and ((value of result (it, bes property "Computer Manufacturer"))="Hewlett-Packard" OR (value of result (it, bes property "Computer Manufacturer"))="HP")
)
and
(
(exists operating system of it) and
(operating system of it as lowercase="winxp 5.1.2600")
)
)
)
?>
I then copy and paste this section and change for other values to get the other data
(if exists (name of it) then (name of it) else “N/A”) &
“,” & (if (exists results (it, bes property “HP batt design capacity (temp)”)) then (if (exists (values of results (it, bes property “HP batt design capacity (temp)”))) then
concatenation “,” of (values of results (it, bes property “HP batt design capacity (temp)”)) else “N/A”) else “N/A”)
problem is I get parse errors - is this a problem with my syntax?
last but not least if I go with the first code I get mutiple entries, now this could be one of two reasons
my code - more than likely
utility that creates XMl was run more than once and appends the file
any suggestions?
just another thing I have found, it doesnt seem to return the same amount i.e
client1 5130, 5130, 5130, 5130, 5130
client 2 5130, 4000
client 3 5130, 5130, 5130, 5130, 5130, 5130, 5130, 5130, 5130, 5130
