I’m trying to create a report that produces a list of Windows Computer Applications (results of bes property "Installed Applications - Windows"
) and provides the number of computers that each application is installed on. After looking through old posts on this forum I found something similar to what I want and then made small alterations to it. The query does return a list of all the unique applications, but the computer count that it returns is zero for every one. I followed the logic of the query and from my perspective, it seems like it should work. Can someone help me to get this query working properly?
( item 0 of it, number of elements of item 1 of it ) of ( item 2 of it, sets of items 2 of ( item 0 of it, item 2 of it, elements of item 1 of it ) whose (value of results (item 0 of it, item 2 of it) = item 1 of it) ) of ( item 0 of it, item 1 of it, ( if (item 2 of it contains "%00") then (concatenation of substrings separated by "%00" of item 2 of it) else (item 2 of it) ) ) of ( item 0 of it, item 1 of it, unique values of values of (results (item 0 of it, elements of item 1 of it)) ) of ( it, set of members of bes computer groups whose (name of it = "Laptops") ) whose ( exist results (item 0 of it, elements of item 1 of it) whose (not error flag of it) ) of bes property "Installed Applications - Windows" whose (name of source analysis of it = "Application Information (Windows)")