We are creating some custom Analyses properties under the custom site like Primary IP, Application Name, Tier, Environment and we would require this custom analyses properties between Operating System and Last report time columns in the Schedulable compliance by computer report.
Below is relevance of the Custom Analyses property (Application Name) for your reference
if (name of operating system as lowercase starts with "win") then (if (exists key "HKEY_LOCAL_MACHINE\SOFTWARE\ABC" whose (value "ApplicationName" of it != "" ) of native registry) then (value "ApplicationName" of key "HKEY_LOCAL_MACHINE\SOFTWARE\ABC" of native registry as string) else "Not Tagged") else if (not exists (operating system) whose (it as string as lowercase contains "Win" as lowercase) and exists file "/root/abc/ApplicationName") then (lines of files "/root/abc/ApplicationName" as string) else "Not Tagged"
Schedulable compliance by computer report
Compliance by Computer
ID
Computer ID
Computer
Operating System
IP Address
Last Report Time
Applicable Fixlets
Installed Fixlets
Outstanding Fixlets
Compliance
No data found for Compliance by Computer
<?relevance trs of htmls (unique values of (it as string) of (td of (id of computer of it as string & id of fixlet of it as string) & td of (id of computer of it as string) & td of (if exists name of computer of it then name of computer of it else "") & td of (if exists operating system of computer of it then operating system of computer of it else "") & td of (if exists ip addresses of computer of it then concatenations (html " ") of (ip addresses of computer of it as string) else html "") & td of (if exists last report time of computer of it then (((year of it as string & "/" & month of it as two digits & "/" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of last report time of computer of it) else ("")) & td of (if (exists first became relevant of it) then ("1") else ("0")) & td of (if (exists Last Became NonRelevant of it and not relevant flag of it) then "1" else "0") & td of (if (exists Last Became Relevant of it and Relevant Flag of it) then "1" else "0")) of results of bes fixlets) ?>
Using the full analysis results may break the table formatting, instead of adding the entire analysis, it’s better to reference individual RP. You can simply extend your existing query by adding each RP as a separate column with its results.
<?relevance trs of htmls (unique values of (it as string) of (td of (id of computer of it as string & id of fixlet of it as string) & td of (id of computer of it as string) & td of (if exists name of computer of it then name of computer of it else "") & td of (if exists operating system of computer of it then operating system of computer of it else "") & td of (if exists values of results (bes property "Application Name", computer of it) then values of results (bes property "Application Name", computer of it) else "") & td of (if exists values of results (bes property "Primary IP", computer of it) then values of results (bes property "Primary IP", computer of it) else "") & td of (if exists values of results (bes property "Environment", computer of it) then values of results (bes property "Environment", computer of it) else "") & td of (if exists ip addresses of computer of it then concatenations (html " ") of (ip addresses of computer of it as string) else html "") & td of (if exists last report time of computer of it then (((year of it as string & "/" & month of it as two digits & "/" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of last report time of computer of it) else ("")) & td of (if (exists first became relevant of it) then ("1") else ("0")) & td of (if (exists Last Became NonRelevant of it and not relevant flag of it) then "1" else "0") & td of (if (exists Last Became Relevant of it and Relevant Flag of it) then "1" else "0")) of results of bes fixlets) ?>
Thank you for your response however this relevance is not working for the custom property, it is working if you use BES default property like ID, OS etc.
I have created below mentioned relevance for the custom property and it is working as well so can we merge both of relevance’s ??
<?relevance concatenation of trs of ( td of (item 0 of it as string) & td of (item 1 of it as string) & td of (item 2 of it as string) & td of (item 3 of it as string) & td of (item 4 of it as string) & td of (item 5 of it as string) & td of (item 6 of it as string) & td of (item 7 of it as string) & td of (item 8 of it as string))of (id of it, ids of it, names of it, (value of result from (BES Property "IP Address (Single)") of it), (value of result from (BES Property "OS (Short Name)") of it), (values of property results whose (name of property of it = "Application Name") of it), (values of property results whose (name of property of it = "Tier") of it), (values of property results whose (name of property of it = "Environment") of it), last report time of it ) of bes computers?>