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

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
    ACCEPTED ANSWER

    Re: Intersect bes properties and bes fixlets in session relevance

    ‏2014-04-09T13:46:22Z  in response to RandallB

     

    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
      ACCEPTED ANSWER

      Re: Intersect bes properties and bes fixlets in session relevance

      ‏2014-04-09T13:53:33Z  in response to jgstew

       

      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
        ACCEPTED ANSWER

        Re: Intersect bes properties and bes fixlets in session relevance

        ‏2014-04-09T17:09:13Z  in response to jgstew

        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
          ACCEPTED ANSWER

          Re: Intersect bes properties and bes fixlets in session relevance

          ‏2014-04-09T17:57:24Z  in response to RandallB

           

          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
    • This reply was deleted by RandallB 2014-04-09T17:06:35Z.