Retrieving Analysis Info

Content Authoring
1

I have an analysis that, among other things, retrieves the timezone of a target server, as seen in the attached file.
image

I am then using the API to attampt to grab these two figures, using the following relevance:
Executing timezone query: (computer name of it, values of results whose (name of it contains “DCWIN_TZ_”) of it, name of results whose (name of it contains “DCWIN_TZ_”) of it) of properties of bes analysis whose (id of it = 33933)
ServerPatching.Services.BigFixService: Information: Executing timezone query: (computer name of it, values of results whose (name of it contains “DCWIN_TZ_”) of it, name of results whose (name of it contains “DCWIN_TZ_”) of it) of properties of bes analysis whose (id of it = 33933)

It is not working though. I think my relevance is jacked.

Can anybody help out here, or maybe even suggest a better method of getting the timezone of a targer server? If so, I’d love a way to incorprate grabbing timezone info into this relevance… currently I am running two queries but if I can grab it all at once, that would be twice as fast :wink:

            (
            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"",
            value of client setting whose (name of it is ""wev_patchGroup"") of it | ""N/A""
            ) of bes computers";
2

I have almost enough to help you to nirvana.

could you please give me the results of this session relevance query?

(name of it, id of it) of bes properties whose (name of it contains "DCWIN_TZ_")

Once you have that ID, you can then do THIS

(
            id of it,
            name of it,
            ip addresses of it,
            last report time of it,

            value of result(bes property whose (id of it = (x,33933,z)), it) as string|""-1"",

            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"",
            value of client setting whose (name of it is ""wev_patchGroup"") of it | ""N/A""
            ) of bes computers";
1 Like
3

Hahahaha Nice one, John! :slight_smile:

4

I took your idea and applied it… works perfect!

1 Like