Excel connector

there is way to do a query about baseline in there?

You can, yes. They’d be under the ‘BES Fixlets’ object.

Of course, if you would like further guidance, we’ll need more context on what you are trying to achieve :slight_smile:

image

if i want to get all my baselines or what baseline is “myfixlet”
or what baseline is computer aplicable.

@Aram

i cant see those options there:slight_smile:

So, treat a Baseline as you would a Fixlet in this case, and during the last step of the wizard, add a Filter where Baseline Flag = True:

1 Like

@Aram

image

ok and if i want to see the baseline and the fixlets in this baseline i did this and its got nothing

The Wizard for the Excel Connector does not currently provide a mechanism to select a baseline’s component Fixlets for return, but does allow for the other 2 use cases you described above (return all baselines, be able to report on applicable computer counts or names for baselines):

That said, the Excel Connector does allow you to specify your own Session Relevance query. There are many examples on the Forum depending on what you are trying to achieve, but here’s a sample that returns all components of all baselines:

(id of it, display name of site of it, name of it, names of components of component groups of it) of bes baselines

1 Like

ok thank you very much:):):slight_smile: