When I use try the following sesion relevance, I get the result “Singular expression refers to nonexistent object”. I have narrowed it down to it not liking the “SBU” property. When I replace “SBU” with “CPU”, it seems to work, even though “SBU” is a valid property.
HostName
OS
SBU
Last Report Time
<?Relevance
(trs of
(
td of name of it &
td of (value of (results from (bes property "OS") of it)) &
td of (value of (results from (bes property "SBU") of it)) &
td of (value of (results from (bes property "Last Report Time") of it))
)
of bes computers
whose (last report time of it < now - 3*day))
?>
However, when I run this, it shows valid data for my “SBU” property.
(names of it, values of (results from (bes property “OS”) of it ), values of (results from (bes property “SBU”) of it ),last report times of it) of bes computers whose (last report time of it < now - 3*day)
Also, are you sure it’s the property that doesn’t exist? You usually need to add a guard clause to property results clauses in case of errors or values that don’t exist. Like this:
… results from (bes property “SBU”) whose (not error flag of it AND exists value of it) of it …
changed th e line to ‘td of (value of (results from (bes property whose (name of it = “SBU”)) of it)) &’ and now the result is “Singular expression refers to non-unique object”.
I was able to get it with this report. Thanks anyways though
HostName
OS
SBU
Last Report Time
<?Relevance
trs of
(
td of names of it &
td of operating systems of it &
td of concatenation "" of values of (results (bes property "SBU" ,it)) &
td of values of (results (bes property "Last Report Time" ,it))
)
of computers of results
whose
(
exists value
whose
(
it as time < now - 3 * day
)
of it
)
of bes property "Last Report Time"
?>
TOTAL=
<?Relevance
number of results (bes property “Last Report Time”, bes computers) whose (now - (value of it as time) > 3 * day) ?>