I currently use this relevance in my .net app to query the API. I am pulling various settings from each server:
string relevanceQuery = @"
(
id of it,
name of it,
ip addresses of it,
last report time of it,
value of client setting whose (name of it is ""wev_patchDayOffset"") of it | ""-1"",
value of client setting whose (name of it is ""wev_patchHour"") of it | ""-1"",
value of client setting whose (name of it is ""wev_patchMinute"") of it | ""-1"",
value of client setting whose (name of it is ""wev_rebootDayOffset"") of it | ""-1"",
value of client setting whose (name of it is ""wev_rebootHour"") of it | ""-1"",
value of client setting whose (name of it is ""wev_rebootMinute"") of it | ""-1"",
value of client setting whose (name of it is ""wev_groupClassID"") of it | ""-1""
) of bes computers";
I tried to modify this so it only pulls the data from server that are in the group named “KRO - All Windows Servers” but it still is pulling from all servers. Here is what I have:
string relevanceQuery = @"
(
id of it,
name of it,
ip addresses of it,
last report time of it,
value of client setting whose (name of it is ""wev_patchDayOffset"") of it | ""-1"",
value of client setting whose (name of it is ""wev_patchHour"") of it | ""-1"",
value of client setting whose (name of it is ""wev_patchMinute"") of it | ""-1"",
value of client setting whose (name of it is ""wev_rebootDayOffset"") of it | ""-1"",
value of client setting whose (name of it is ""wev_rebootHour"") of it | ""-1"",
value of client setting whose (name of it is ""wev_rebootMinute"") of it | ""-1"",
value of client setting whose (name of it is ""wev_groupClassID"") of it | ""-1""
) of members of bes computer group whose (name of it as lowercase = ""KRO - All Windows Servers"" as lowercase)";
The KRO - All Windows Servers group only has about 4200 members, but in mass all of my servers the total is 5598. Each of these two relevance strings pulls the data from all 5598 servers.
What am I missing?