(imported topic written by npeters91)
Can I sort the output results by a column.
In the relevance below, I’d like to sort the results by the property “Definition Last Update”
trs of (
td of (if (exists name of it) then name of it else “unknown”)&
td of (if (exists value of result(bes property “Definition Last Update”,it)) then value of result(bes property “Definition Last Update”,it) else “n/a”)&
td of (if (exists value of result(bes property “CompanyName”,it)) then value of result(bes property “CompanyName”,it) else “n/a”)&
td of (if (exists value of result(bes property “Last Report Time”,it)) then value of result(bes property “Last Report Time”,it) else “n/a”)
)
of bes computers whose (exist (value of result(bes property “Definition Last Update”,it))whose (it as integer < ((year of (current date - 3day)) as string & (month of (current date - 3day) as two digits) as string & (day_of_month of (current date - 3*day)) as two digits as string) as integer)
)
Any guidance is appreciated.
Thanks,
Nathan