Hello All. I have a computer group named “XYZ” consists of 900 computers. Now i have to create a custom report where i have to fetch computer name, issued action, action id, issuer of action and action state where computer group name should be"XYZ", ACTION name starts with “2016p” . I write the below query
(names of members of it)of bes computer groups whose (name of it contains “XYZ”)
But i am unable to merge other things with it. Please help me on it. It is very important.
Because you are currently returning members of the computer group, you can see what other properties are returnable for a computer object with session relevance such as the following:
properties whose (it as string contains "<bes computer>")
Filtering further on the term ‘action’ helps narrow down the inspectors of interest:
properties whose (it as string contains "<bes computer>" AND it as string contains "action")
Using the above, we find the following inspector:
reported action set of <bes computer>: bes action set
And given this inspector, we might prepare something like the following statement:
(names of members of it, (id of it, name of it, name of issuer of it, state of it) of elements of reported action sets of members of it) of bes computer groups whose (name of it contains “XYZ”)
Hello Aram sorry to use flag in a wrong way. The query given by you is giving the
result.
@SubhrajitPyne, this is due to a bug in the Session Relevance Tester.
It does not know how to handle a result with a tuple.
Fix #1 - In the Configuration tab, uncheck “Use Version 8 SOAP API”.
Fix #2 - Change your statement to look like this:
(items 0 of it,
items 0 of items 1 of it,
items 1 of items 1 of it,
items 2 of items 1 of it,
items 3 of items 1 of it
) of (names of members of it, (id of it, name of it, name of issuer of it, state of it) of elements of reported action sets of members of it) of bes computer groups whose (name of it contains "XYZ")
Thank you so much leewei. It is working really fine.
Lee if i want to add another filter in the action name like whose (names of it contains “2016p”) how can i do that here?
@SubhrajitPyne, the key is that the whose() filter clause is added right behind the object that you want to filter on.
So what you say “names of it”, the IT refers to the Actions, which in the case of the statement are the “elements”.
So this is what the statement would look like:
(items 0 of it,
items 0 of items 1 of it,
items 1 of items 1 of it,
items 2 of items 1 of it,
items 3 of items 1 of it
) of (names of members of it, (id of it, name of it, name of issuer of it, state of it) of elements whose (name of it contains "2016p") of reported action sets of members of it) of bes computer groups whose (name of it contains "XYZ")
Thank you so much Leewei. Let me test it.
It is working . Thank you so much Lee