Topic
  • 4 replies
  • Latest Post - ‏2014-04-09T17:57:24Z by jgstew
RandallB
RandallB
3 Posts

Pinned topic Intersect bes properties and bes fixlets in session relevance

‏2014-04-08T19:55:07Z |

I'm trying to build a custom report based on fixlet id, applicable count. My issue is filtering the bes properties for separate breakdowns based on certain property. Just need a little syntax help I think. 

I need to intersect bes fixlets and bes properties...

 

Here is what I have so far but am getting "This expression could not be parsed". Any help would be much appreciated.

 

(((

                (if (exists Applicable Computer Count of it)

                                then (Applicable Computer Count of it as string))

                                else ("<none>")))

of

                bes fixlets

                                whose (

                                                (name of site of it = "DEV") AND

                                                ((ID of it = 549992)))

of bes properties

                whose (

                                name of it = "PATCH_GROUP" whose (name of it as lowercase contains "CMS")))

 

Updated on 2014-04-08T19:55:57Z at 2014-04-08T19:55:57Z by RandallB
  • jgstew
    jgstew
    33 Posts

    Re: Intersect bes properties and bes fixlets in session relevance

    ‏2014-04-09T13:46:22Z  

     

    I believe your issue is you are doing ( bes fixlets of bes properties ) which does not work.

     

    What is it you are trying to do?  Are you looking for the list or number of computers with certain properties that are relevant to a certain fixlet?

     

  • jgstew
    jgstew
    33 Posts

    Re: Intersect bes properties and bes fixlets in session relevance

    ‏2014-04-09T13:53:33Z  
    • jgstew
    • ‏2014-04-09T13:46:22Z

     

    I believe your issue is you are doing ( bes fixlets of bes properties ) which does not work.

     

    What is it you are trying to do?  Are you looking for the list or number of computers with certain properties that are relevant to a certain fixlet?

     

     

    TRY:

    applicable computer counts of bes fixlets whose(exists applicable computer count of it AND ("DEV" = name of site of it) AND (549992 = id of it))

    OR:

    number of bes computers whose(("CMS" = value of result from (bes property "PATCH_GROUP") of it) AND (exists relevant fixlets whose((549992 = id of it) AND ("DEV" = name of site of it)) of it))

     

  • RandallB
    RandallB
    3 Posts

    Re: Intersect bes properties and bes fixlets in session relevance

    ‏2014-04-09T17:09:13Z  
    • jgstew
    • ‏2014-04-09T13:53:33Z

     

    TRY:

    applicable computer counts of bes fixlets whose(exists applicable computer count of it AND ("DEV" = name of site of it) AND (549992 = id of it))

    OR:

    number of bes computers whose(("CMS" = value of result from (bes property "PATCH_GROUP") of it) AND (exists relevant fixlets whose((549992 = id of it) AND ("DEV" = name of site of it)) of it))

     

    The second one looks to be what I am looking for but instead of ("CMS" = value of result from (bes property "PATCH_GROUP")

     

    can you show me what it would be to use (name of bes property "PATCH_GROUP" contains CMS)? That is contains CMS instead of "CMS" = value of

    Thanks!

    Updated on 2014-04-09T17:13:40Z at 2014-04-09T17:13:40Z by RandallB
  • jgstew
    jgstew
    33 Posts

    Re: Intersect bes properties and bes fixlets in session relevance

    ‏2014-04-09T17:57:24Z  
    • RandallB
    • ‏2014-04-09T17:09:13Z

    The second one looks to be what I am looking for but instead of ("CMS" = value of result from (bes property "PATCH_GROUP")

     

    can you show me what it would be to use (name of bes property "PATCH_GROUP" contains CMS)? That is contains CMS instead of "CMS" = value of

    Thanks!

     

    These are almost the same, with some slight variation:

     

    If PATCH_GROUP is "CMS??????"

    number of bes computers whose(((value of result from (bes property "PATCH_GROUP") of it) starts with "CMS") AND (exists relevant fixlets whose((549992 = id of it) AND ("DEV" = name of site of it)) of it))

     

    If PATCH_GROUP is "???????CMS"

    number of bes computers whose(((value of result from (bes property "PATCH_GROUP") of it) ends with "CMS") AND (exists relevant fixlets whose((549992 = id of it) AND ("DEV" = name of site of it)) of it))

     

    If PATCH_GROUP is "???????CMS?????"

    number of bes computers whose(((value of result from (bes property "PATCH_GROUP") of it) contains "CMS") AND (exists relevant fixlets whose((549992 = id of it) AND ("DEV" = name of site of it)) of it))

     

    If PATCH_GROUP is "???????cMs?????"

    number of bes computers whose(((value of result from (bes property "PATCH_GROUP") of it) as uppercase contains "CMS") AND (exists relevant fixlets whose((549992 = id of it) AND ("DEV" = name of site of it)) of it))

     

    Updated on 2014-04-09T18:00:04Z at 2014-04-09T18:00:04Z by jgstew