Hi,
I have using IBM Bigfix v9.1.1117.0. in my web reports name called “software installed report”, when I am accessing this report i get an error like “Singular expression refers to nonexistent object.”
so I cannot generate reports based on this features, any one know this error.
please find the below error screen shot:
Thanks,
Nagaraj.
Was there a specific application name you tried to search for?
Hi,
No specific application, if I search any application i will shown same error.
Thanks,
Nagaraj.
Hi,
sorry, No specific application, if I search any application it will shown same error.
Thanks,
Nagaraj.
@Nagaraj, where did you get the custom report from? It might be something that I had created a while back. If you post the source code here, I can help debug the error.
Hi Leewei,
please find below source code,
<style type="text/css">
a {
text-decoration: none;
}
a:hover {
color: #FF8000;
font-weight: bold;
text-decoration: none;
}
table {
margin: 0;
color: #222;
font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
}
th {
font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
color: navy;
font-weight: bold;
background-color: #F2F2F2;
border: 1px solid #cccccc;
margin: 0;
padding: 4px 10px 4px 5px;
text-align: left;
}
td {
color: #222;
font: 8pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
border-bottom: 1px solid #cccccc;
margin: 0;
padding: 6px 20px 1px 0;
}
td.userinput {
color: #222;
font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
font-weight: bold;
border-bottom: 0px;
margin: 0;
padding: 6px 20px 1px 0;
}
td.errormsg {
color: red;
font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
font-weight: bold;
border-bottom: 0px;
margin: 0;
padding:6px 20px 1px 0;
}
td.msg {
color: #747170;
font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
font-weight: bold;
border-bottom: 0px;
margin: 0;
padding: 6px 20px 1px 0;
}
/*h3 {
font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
background-color: #747170;
padding: 4px 4px 4px 4px;
color: white; width: 100%;
}*/
table.sortable tr.wr_evenRow {
background-color: #ffffff;
}
table.sortable tr.wr_oddRow {
background-color: #dddddd;
}
/* Sortable tables */
table.sortable a.sortheader {
color: black;
text-decoration: underline;
}
table.sortable span.sortarrow, img {
color: black;
text-decoration: none;
border-width: 0px;
}
</style>
<script type="text/javascript">
function searchComputer() {
var divRes = document.getElementById('resultsDiv');
divRes.innerHTML = 'Searching...';
divRes.style.display = 'block';
computerName.value = computerName.value.toLowerCase();
var relevance = '(html "<table id=%22resultsTable%22 class=%22sortable%22><th>Application</th><th>Version</th><th>Computer</th>" & it & html "</table>") of concatenation of trs of ((if (exists first "|" of item 0 of it) then (td of preceding text of first " |" of item 0 of it) else (td of item 0 of it)) & (if (exists first "|" of item 0 of it) then (td of following text of first "| " of item 0 of it) else (td of "-")) & td of item 1 of it) of (values whose (it as lowercase contains "' + computerName.value + '") of it, name of computer of it) of results of bes properties whose (name of it contains "Installed Applications - Windows" and name of source analysis of it = "Application Information (Windows)")'
var res_count = '(html "<table><tr><td class=msg>" & it as string & html " applications found</td></tr></table>") of number of (values whose (it as lowercase contains "' + computerName.value + '") of it) of results of bes properties whose (name of it contains "Installed Applications - Windows" and name of source analysis of it = "Application Information (Windows)")';
strResponse2 = EvaluateRelevance(res_count);
if (strResponse2.match(' 0 applications found') == '0 applications found') {
strResponse = '';
} else {
strResponse = EvaluateRelevance(relevance);
}
document.getElementById('resultsDiv').innerHTML = strResponse2 + strResponse;
sortables_init();
}
</script>
<table>
<tr>
<td class="userinput">
Enter application name:
<input type="text" id="computerName" value="" style="width: 230px" />
<input type="button" value ="Generate Report" onclick="searchComputer()" />
</td>
</tr>
</table>
<hr/>
<div id = "resultsDiv">
<table>
<?relevance if (not exists activations whose(active flag of it = true) of bes fixlet whose(name of it = "Application Information (Windows)"))
then((html "<tr><td class=%22errormsg%22>Error: The Analysis " & link of it & html " is not enabled.</td></tr>")
of bes fixlet whose(name of it = "Application Information (Windows)"))
else(html " ") ?>
</table>
</div>
Thanks,
Nagaraj.
Do you have an analysis called Application Information (Windows) in your system and is it activated ?
Hi gearoid,
I have “installed application” analysis in my server also it was working fine,
but I get an error the above scenario. can you please help me the same?
Thanks,
Nagaraj.
I don’t know if that’s the same analysis I was referring to.
In the relevance it refers to an analysis
if (not exists activations whose(active flag of it = true) of bes fixlet whose(name of it = "Application Information (Windows)"
And the error you’re getting indicates that something in the relevance does not exist in your system.
A way to troubleshoot is to get the various bits of relevance and try to run them one by one.
Try this in the Webreports QNA windows
WebReportsQNA: http://webreportsurl:port/cgi-bin/webreports/webreports.exe?page=QNA
Hi, Nagaraj
I want to ask if I want to add other column like username on the page.
How to add it to these HTML? Could you help with it?
Thanks.
User name property in custom reports ?
by default it will give computer name only i hope.
I am not sure in html sources code where we can add it, may be Leewei can help you.