BigFix WebReport Relevance

Content Authoring
1

Hello

I am developing a new report with Web Relevance. My goal is to display the software installed on each computer: Name of the computer; editor; version; …

I use the following code

concatenation of (
name of it
& “;”
& concatenation “,” of (values of it) of property results whose (name of property of it
is contained by set of (“Installed Applications - Windows”)) of it
)
of bes computers

which returns the following result

VM-W2016-SOURCE;Azure Data Studio | 1.32.0,BES Session Relevance Tester 8.0.627 | 8.0.627,Bat To Exe Converter version 3.2 | 3.2,BigFix Client | 10.0.4.32,BigFix Console | 10.0.4.32,BigFix Installation Generator | 10.0.4.32,BigFix Inventory | 10.0.6.0,BigFix Server | 10.0.4.32,BigFix WebUI Service | 10.0.4.32,Browser pour SQL Server 2016 | 13.0.1601.5,CCleaner | 5.86,Enregistreur VSS Microsoft pour SQL Server 2016 | 13.0.1601.5,Fichiers de support d’installation de Microsoft SQL Server 2008 | 10.3.5500.0,Google Chrome | 95.0.4638.69,Java 8 Update 301 | 8.0.3010.9,Microsoft Help Viewer 2.3 | 2.3.28107,Microsoft ODBC Driver 13 for SQL Server | 13.0.1601.5,Microsoft ODBC Driver 17 for SQL Server | 17.7.2.1,Microsoft OLE DB Driver pour SQL Server | 18.5.0.0,Microsoft SQL Server 2012 Native Client | 11.4.7001.0,Microsoft SQL Server 2016 (64-bit),Microsoft SQL Server 2016 Setup (English) | 13.0.1742.0,Microsoft SQL Server 2016 T-SQL Language Service | 13.0.14500.10,Microsoft SQL Server Data-Tier Application Framework (x86) - fr-FR | 13.0.3225.4,Microsoft SQL Server Management Studio - 18.10 | 15.0.18390.0,Microsoft SQL Server 2016 T-SQL ScriptDom | 13.0.1601.5,Microsoft Visual C++ 2010 x64 Redistributable - 10.0.40219 | 10.0.40219,Microsoft Visual C++ 2010 x86 Redistributable - 10.0.40219 | 10.0.40219,Microsoft Visual C++ 2012 Redistributable (x64) - 11.0.61030 | 11.0.61030.0,Microsoft Visual C++ 2012 Redistributable (x86) - 11.0.61030 | 11.0.61030.0,Microsoft Visual C++ 2013 Redistributable (x86) - 12.0.30501 | 12.0.30501.0,Microsoft Visual C++ 2015-2019 Redistributable (x64) - 14.20.27508 | 14.20.27508.1,Microsoft Visual C++ 2015-2019 Redistributable (x86) - 14.20.27508 | 14.20.27508.1,Microsoft Visual Studio Tools for Applications 2017 | 15.0.27520,Module linguistique de Microsoft Help Viewer 2.3 - FRA | 2.3.27412,Notepad++ (32-bit x86) | 8.1.9,Secret Server Protocol Handler | 6.0.0.33,VMware Tools | 11.0.0.14549434

Can someone help me to have a line by software installed with separation between the editor; software installed; version; …

Sincerely

2

It seems like Installed applications analysis returns the name and version separated by " | ".

Do you want a line per machine per software title? This will return machine name; software title; version, or just machine name for systems that have not evaluated that property.

(
	(item 0 of it & ";" & item 1 of it) 
	of 
	(
    	name of item 1 of it, 
    	(
    		if 
    			number of elements of it = 0 
    		then  
    			";" 
    		else 
    			(concatenation ";" of substrings separated by " | " of it) of elements of it
    	) 
    	of set of values of (results ( elements of item 0 of it, item 1 of it)) 
    )
)
of 
(
	set of bes properties whose (name of it = "Installed Applications - Windows"), 
	bes computers
)

Hope that helps