Script Needed to get the Data from BESDatabase

Without error handling,

(name of it, values of results (it, bes property "Computer Name"), concatenation ";" of values of results (it, bes property "IP Address")) of bes computers

Ideally aim towards using the method in @brolly33 blog post.

(name of item 0 of it | "Computer Name missing", (if (size of item 1 of it = 1) then ((if it = "" then "No values" else it) of concatenation ";" of values of results (item 0 of it, elements of item 1 of it)) else (if (size of item 1 of it > 1) then (concatenation ";" of values of results (item 0 of it, elements of item 1 of it)) else ("Property does not exist")))) of (elements of item 0 of it, item 1 of it) of (set of BES computers, set of bes properties whose (name of it as lowercase = ("IP Address") as lowercase))

1 Like