How do I get all the fixlets,task and baseline from bes site for a user

How do I get all the fixlets, task and baseline from all bes site.

((id of it, names of it, categories of it, sources of it, source ids of it, type of it, modification time of it, names of issuers of it, relevances of it) of fixlets of it) of all bes sites - This fails

I can get for a specific site and not for the whole bes sites.

Regards
Janu

Hi @Janu03

If you just want the fixlets, leave the “of all bes sites” out.

Just use names of bes fixlets and you’ll have the name of all the fixlets.

Thanks Steini44, I require other fields as well, can you let me know the query?

(names of it, categories of it, sources of it, source ids of it, type of it, modification time of it, names of issuers of it, relevances of it) of bes fixlets - this is not working…

(names of it, categories of it, sources of it, source ids of it, types of it, modification times of it, names of issuers of it, relevances of it) of bes fixlets

You were close, just make sure you have plurals of everything since the values are not unique :slight_smile:

Thank u… that’s works

I can’t confirm this right now, but I suspect that if any of the fields are empty/blank, this would skip the result for that fixlet. And since only Actions have issuers, this may return only the Actions.

If that’s the case, you’d have to error trap for each field -

(if exists names of it then names of it else "", if exists categories of it then categories of it else "", if exists sources of it then sources of it else "") of bes fixlets

1 Like

I used the below query - Seems the count is not correct

If I directly login to BigFix Console and saw the Fixlets and Tasks Group, I see near about 300 items. However when I query it using bigfix console, I’m getting less numbers.

Is there is any active flag for Fixlet or Task? - I would like to see the numbers should match in both scenario (either from Console or using the relevance query)

(names of it, categories of it, sources of it, source ids of it, types of it, modification times of it, names of issuers of it, relevances of it) of bes fixlets

…in this query, are you seeing any Fixlets/Tasks, or are you only seeing the Actions that were taken from those tasks?

I ask because, as far as the schema’s concerned, an Action is a Fixlet too (and so are Baselines and Analyses).

…but only the Actions would have a “issuers of it” property. So your query, which checks for “names of issuers of it”, should only show Actions.

1 Like

Happy New Year

It provides me all the below types from Custom Site which is not required. I need only Tasks, Fixlets and Baselines which are active under Custom Site

Fixlet
Baseline
Task
Analysis
ComputerGroup

When you mean “active”, do you mean that there is an open Action sourcing these fixlets/tasks/baselines, or do you mean that there are Relevant Computers for the fixlet/task/baseline? Because only the Actions will have an issuer.

So you could do this to see all the Fixlets, Tasks, and Baselines (not actions); because they’re not Actions they don’t have an issuer. You filter the “bes fixlet” for only the types of Fixlet that you want -

((if exists names of it then names of it else "no name"), (if exists categories of it then categories of it else "no category"), (if exists sources of it then sources of it else "no sources")) of bes fixlets whose (fixlet flag of it or task flag of it or baseline flag of it)

If you’re looking for Actions taken from Fixlets in a certain site, you could retrieve “taken actions of bes fixlets” like
((if exists names of it then names of it else "no name")) of taken actions of bes fixlets

(but an Action does not have a Category or a Source; and this won’t catch actions triggered through the “Take Custom Action” dialog (no source fixlet) or actions whose source fixlet has been deleted)

If you want to do a hybrid, you can retrieve the Taken Action and then pull properties from the source fixlet of it -
((if exists names of it then names of it else "no name"), (if exists source fixlet whose (exists category of it) of it then category of source fixlet of it else "no category"), name of issuer of it) of taken actions of bes fixlets

If you want all Open Actions (regardless of whether it had / still has a source fixlet), you can use
((if exists names of it then names of it else "no name"), (if exists source fixlet whose (exists category of it) of it then category of source fixlet of it else "no category"), name of issuer of it, state of it) of bes actions whose (state of it = "Open")

I hope this helps illustrates how to filter Fixlet/Task/Baseline, and the links between Fixlet and Action.