for symantec antivirus, but sadly when i create a schedule mail on web reports with this relevance expression it is just checking the relevance in only console system (count is 1), how can i compare this with entire network and generate mail when this becomes true , i need to compare the version of software too ,
does bigfix have any custom report , where i can feed the number of licenses i have and big fix lets me know whether i have exceed my quota or how many free licenses i have at my disposal
Thanks Ben now the script is working fine, but i needed little bit more customization, i have created some groups on bigfix, can i further filter it down and generate alerts based on groups and also send the details of the system where the additional license is installed
also wanted to know, when the feature of license tracking reports and alerts will be available from Bigfix
number of elements of intersection of ( member set of bes computer groups whose (name of it = “”); set of bes computers whose (exist values whose (it as lowercase contains “”) of results (bes property “installed applications - windows”,it)))
You would need to generate a report of the computers with their applications installed and use this trigger to send out the reports.
the solution is working perfectly fine. now our concern is we are not able to identify where the additional license is installed as the report being generated is exhaustive and is very difficult to find out the system
is there a way, where we can identify the system where the additional license is installed and send the details of the system along with the mail,
There isn’t a great way to do differenced email reports… but here is something you could try:
Make a custom report like this:
Computers with installed:
<?Relevance ordered list of unique values of names of elements of intersection of elements of intersection of ( member set of bes computer groups whose (name of it = ""); set of bes computers whose (exist values whose (it as lowercase contains "") of results (bes property "installed applications - windows",it)))?>
And then you can set your alert to send you the numbered list of all the computer names (and potentially other properties) every time you go over the count.
thanks for the reply Ben, just wanted little bit customization on this format can , what is the script to generate a report with following headings
Primary properties
“Application name” “Group name” "number of installation of the application for this particular group " “My count (hard coded value which i will enter)” then secondary property "computer names for this particular group "
if this can be achieved my head ache will be over, kindly help me out Ben
by the way, where i can learn about relevance script for generating reports and site properties
<?Relevance trs of (td of "" & td of "" & td of (number of elements of it as string) & td of "" & td of (concatenation ";" of names of elements of it))of elements of intersection of elements of intersection of ( member set of bes computer groups whose (name of it = ""); set of bes computers whose (exist values whose (it as lowercase contains "") of results (bes property "installed applications - windows",it)))?>
<?Relevance trs of (td of "" & td of "" & td of (number of elements of it as string) & td of "" & td of (concatenation ";" of names of elements of it))of elements of intersection of elements of intersection of ( member set of bes computer groups whose (name of it = ""); set of bes computers whose (exist values whose (it as lowercase contains "") of results (bes property "installed applications - windows",it)))?>
<?Relevance trs of (td of "" & td of "" & td of (number of elements of it as string) & td of "" & td of (concatenation ";" of names of elements of it))of elements of intersection of elements of intersection of ( member set of bes computer groups whose (name of it = ""); set of bes computers whose (exist values whose (it as lowercase contains "") of results (bes property "installed applications - windows",it)))?>
Replace all values between “” with whatever you want… I didn’t test this and hopefully I didn’t make a syntax mistake.
More info about session relevance can be found at:
i got the report i wanted. there was slight syntax issue (there was intersection of intersetion), which i sorted it out and i also wanted computer names list wise, finally this code worked for me
Application Name
Group Name
Number of apps
My Count
Computer Names
<?Relevance (td of "App name" & td of " Group Name" & td of (number of elements of it as string) & td of "10" & td of (ordered list of names of elements of it))of intersection of ( member set of bes computer groups whose (name of it = "Group Name"); set of bes computers whose (exist values whose (it contains "App name") of results (bes property "installed applications - windows",it)))?>