Computers missing from webreports

We have a process that retrieves a list of all registered computers within BigFix every 5 minutes via a call to the “…/API/query” endpoint. We are seeing that some servers are listed on one retreived list, but then are missing on the next one 5 minutes later. The computer is never deleted from the BigFix console though.

Has anyone ever seen something like this before, or where would I even start troubleshooting? The retrieved list is in the xml format and is correctly structured, so I don’t think that the report is terminating before providing all results.

thanks

@cstoneba, what is the Session Relevance used to retrieve the computer list?

call to …/api/query:

(name of it, id of it, database names of it, Last Report Time of it, ip addresses of it, locked flag of it) of bes computers whose (exists name of it)

1 Like

@leewei - anything you can think of that would cause the computer to be missed from one query to the next? It seems to be only clients that recently registered for the first time.
thanks

This can be a long discussion…

First of all, I would expect this statement to return exactly the number of computers you have in your environment.

(
	name of it | "Name missing", 
	id of it as string | "ID missing", 
	database name of it | "Database Name missing", 
	Last Report Time of it as string | "Last Report Time missing", 
	concatenation ";" of (it as string) of ip addresses of it, 
	locked flag of it | False
) of bes computers

Or to make it easy to see the total.

number of (
	name of it | "Name missing", 
	id of it as string | "ID missing", 
	database name of it | "Database Name missing", 
	Last Report Time of it as string | "Last Report Time missing", 
	concatenation ";" of (it as string) of ip addresses of it, 
	locked flag of it | False
) of bes computers

A lot depends on what you want the output to look like.
What happens if some value is missing (e.g. the Name), do you want to see it?
What happens if a property returns multiple values, do you want to see one row or multiple rows?
The way you have it, if a computer has multiple IP addresses, then multiple rows are returned.

So my example statement is intended to output as many rows as you have computers.
Note that if a property is missing a value, it is substituted with a Text, and if multiple IP Addresses are available for a computer, they are concatenated together.

Give that a try and figure out if workable.

I would have expected that if properties didn’t exist at the bes client level that I were asking for (like Computer ID for example), then the report query would stop and not continue to dump out results and give an error of "singular expression refers to non-existent object), but that’s not what we’re seeing.

But Yes, this is a good idea to help troubleshoot. Thanks

So we made those changes and it didn’t help. I opened a PMR and IBM can’t reproduce it on their end. Any other ideas?

Here’s the delta of us seeing new clients in the computer list export, then not in the computer list export.

:::::::::2017-03-30 14:00:39:::::::::
NEW SERVERS:
server1 - 8755910 - iem_env_1
server2 - 9910323 - iem_env_1
server3 - 10123068 - iem_env_1
server4 - 12243291 - iem_env_1
server5 - 12340850 - iem_env_1
server6 - 13142546 - iem_env_1
server7 - 13870743 - iem_env_1
REMOVED SERVERS:

:::::::::2017-03-30 14:05:39:::::::::
NEW SERVERS:
REMOVED SERVERS:

:::::::::2017-03-30 14:10:39:::::::::
NEW SERVERS:
REMOVED SERVERS:
server1 - 8755910 - iem_env_1
server2 - 9910323 - iem_env_1
server4 - 12243291 - iem_env_1
server5 - 12340850 - iem_env_1
server6 - 13142546 - iem_env_1
server7 - 13870743 - iem_env_1

:::::::::2017-03-30 14:15:40:::::::::
NEW SERVERS:
server8 - 4335890 - iem_env_3
REMOVED SERVERS:

:::::::::2017-03-30 14:20:39:::::::::
NEW SERVERS:
server9 - 15011830 - iem_env_2
REMOVED SERVERS:

:::::::::2017-03-30 14:30:38:::::::::
NEW SERVERS:
server7 - 2595409 - iem_env_1
server1 - 8755910 - iem_env_1
server2 - 9910323 - iem_env_1
server4 - 12243291 - iem_env_1
server5 - 12340850 - iem_env_1
server6 - 13142546 - iem_env_1
REMOVED SERVERS:

:::::::::2017-03-30 14:35:39:::::::::
NEW SERVERS:
REMOVED SERVERS:
server7 - 2595409 - iem_env_1
server1 - 8755910 - iem_env_1
server2 - 9910323 - iem_env_1
server4 - 12243291 - iem_env_1
server5 - 12340850 - iem_env_1
server6 - 13142546 - iem_env_1

:::::::::2017-03-30 14:55:39:::::::::
NEW SERVERS:
server7 - 2595409 - iem_env_1
server1 - 8755910 - iem_env_1
server2 - 9910323 - iem_env_1
server4 - 12243291 - iem_env_1
server5 - 12340850 - iem_env_1
server6 - 13142546 - iem_env_1
REMOVED SERVERS: