I have a relevance statement that we use to return the CIDR(s) of out machines. When I put this into the connector for evaluation I receive an error.
concatenation " | " of (((cidr string of it) of ip interfaces whose ((loopback of it = false) AND (cidr string of it != “0.0.0.0/0”) AND (cidr string of it != “169.254.0.0/16”)) of network) as string)
Error: The operator “network” is not defined.
QnA returns the correct value. The Session Relevance Tester does not.
Am I missing any inspector (or other) updates I may need?
One question though. If I choose active directory security group in BES computers is it possbile that any secutity group found would be in separate cell? Now all security groups are in one cell.
Same goes for application.
PS:
I cant seem so find a way to collect computers which are members of specific security group. Is this even possible?
Awesome tool! I think we have found the answers to problems we were having with Web Reports, namely outstanding fixlets only showing 1000 lines.
I do have one question though. Is there a way to combine imported saved queries into one query? For example, we have multiple customers being patched by Bigfix. Each of these customers their own CID and operator so that we can log into the console separately as each customer. (Over 2,500 computers between them all). So in using the Excel connector is there a way to see outstanding fixlets for just one customer at a time? I don’t see any way to combine or add the CID option in on the outstanding fixlet query.
I would like to find a way to retrieve the value of the Analysis results… im using -> Query wizard ->Results of BES Fixlets , but this does not seem to provide that value; have i missed something ?
I’m trying to extract data using the Excel connector 3.3
There are two properties in BES Computers -> Client administrators and Free space on system drive.
I’m not able to fetch the actual values from web reports.
Client administrators is fetching results like: __op_102, __op_106.,
Free space gets converted automatically to GB’s.
Is this a default behavior or product issue?
Please help me in fixing it.
The Client Administrators property does not necessarily provide ‘friendly’ usernames (particularly with new users). This is not a behavior of the Excel Connector, but rather of BigFix itself. That said, you can map the values returned by the ‘Client Administrators’ property to a friendly user name with the following session relevance:
(name of it, masthead operator name of it) of bes users
The Excel Connector does tweak the output of the Free Space on System Drive property (very cool feature!) by assigning it a custom cell format. If you would prefer that the units are consistent, you can modify the cell format for this column to ‘Number’, which would then return the results in megabytes.
We have recently changed the certificate on our web reports from SHA-1 to SHA-2 and since then the connection from the BigFix Excel connector to web reports is being refused.
Is it just not compatible with SHA-2 or do i need to do something else to get this to work?