Topic
19 replies Latest Post - ‏2013-02-14T18:27:46Z by cstoneba
cstoneba
cstoneba
182 Posts
ACCEPTED ANSWER

Pinned topic Compliance Report

‏2012-11-05T16:14:58Z |
I'm trying to create a webreport that displays the number of computers that are applicable for a baseline. my problem is the report shows the number of relevant components of component groups of baselines, not the number of applicable computers.

(it as string & "," & multiplicity of it as string) of unique values of values of results (bes property whose (name of it contains "blah"),it of applicable computers of source fixlets of components of component groups of bes fixlets whose (baseline flag of it and name of it as lowercase starts with "bs_name"))
Updated on 2013-02-14T18:27:46Z at 2013-02-14T18:27:46Z by cstoneba
  • cstoneba
    cstoneba
    182 Posts
    ACCEPTED ANSWER

    Re: Compliance Report

    ‏2012-11-13T14:09:49Z  in response to cstoneba
    anyone?
  • SystemAdmin
    SystemAdmin
    890 Posts
    ACCEPTED ANSWER

    Re: Compliance Report

    ‏2012-11-14T18:41:33Z  in response to cstoneba
    I'm not entirely sure of exactly what you are trying get here, but this will show you the name and ID of applicable computers of a baseline:

    
    ( name of it, id of it ) of applicable computers of bes fixlets whose (baseline flag of it and name of it as lowercase starts with 
    "base")
    
    • cstoneba
      cstoneba
      182 Posts
      ACCEPTED ANSWER

      Re: Compliance Report

      ‏2012-11-14T19:16:25Z  in response to SystemAdmin
      i want a breakdown by OS of the unique number of servers that are applicable for baselines.
      • cstoneba
        cstoneba
        182 Posts
        ACCEPTED ANSWER

        Re: Compliance Report

        ‏2012-11-26T20:05:11Z  in response to cstoneba
        anyone know how to do that?
        • cstoneba
          cstoneba
          182 Posts
          ACCEPTED ANSWER

          Re: Compliance Report

          ‏2012-12-13T16:57:37Z  in response to cstoneba
          anyone?
          • cstoneba
            cstoneba
            182 Posts
            ACCEPTED ANSWER

            Re: Compliance Report

            ‏2013-01-11T19:25:09Z  in response to cstoneba
            can anyone help me with this report? the report runs, but it is giving off too many results, so I'm pretty sure there is something not written right.

            (it as string & "," & multiplicity of it as string) of unique values of values of results (bes property whose (name of it contains "City"), computers of results whose (relevant flag of it = true) of (source fixlets whose (fixlet flag of it) of components of component groups of bes fixlets whose (baseline flag of it AND name of it as lowercase starts with "baseline_names")))
            • Lee Wei
              Lee Wei
              598 Posts
              ACCEPTED ANSWER

              Re: Compliance Report

              ‏2013-01-11T22:41:29Z  in response to cstoneba
              Can you show an example of what you would like to see in the output?
              Also what kind of input into the report. Is the baseline name hardcoded?
              Do you want to see the applicable computers base on the baseline itself, or the components of the baseline?
              • cstoneba
                cstoneba
                182 Posts
                ACCEPTED ANSWER

                Re: Compliance Report

                ‏2013-01-11T23:41:11Z  in response to Lee Wei
                I want to see the number of unique values of applicable computers of the baselines for each result of the property "City". Yes, the baseline names are hard coded, the code I have provides output, but the number of results for each city is far too high.
                • Lee Wei
                  Lee Wei
                  598 Posts
                  ACCEPTED ANSWER

                  Re: Compliance Report

                  ‏2013-01-11T23:56:25Z  in response to cstoneba
                  Can you show us an example output?
                  • cstoneba
                    cstoneba
                    182 Posts
                    ACCEPTED ANSWER

                    Re: Compliance Report

                    ‏2013-01-12T00:04:00Z  in response to Lee Wei
                    City. # of applicable computers
                    Chicago. 10
                    NYC. 15
                    Miami. 20
                • Lee Wei
                  Lee Wei
                  598 Posts
                  ACCEPTED ANSWER

                  Re: Compliance Report

                  ‏2013-01-12T00:09:16Z  in response to cstoneba
                  Here is an example statement for you. Hopefully you can use it.

                  
                  (it & 
                  ". " & multiplicity of it as string) of unique values of values of results from (bes property whose (name of it contains 
                  "City")) of computers of results of bes fixlets whose (baseline flag of it and name of it as lowercase starts with 
                  "baseline_names")
                  
                  • cstoneba
                    cstoneba
                    182 Posts
                    ACCEPTED ANSWER

                    Re: Compliance Report

                    ‏2013-01-12T00:52:52Z  in response to Lee Wei
                    I get results, but too many computer results for each property result. For example, one result "Miami" shows "12" from your report, but I only have 2 computers with a result of "Miami" in my console. This is the same type of results I was getting with my original code above.
                    • Lee Wei
                      Lee Wei
                      598 Posts
                      ACCEPTED ANSWER

                      Re: Compliance Report

                      ‏2013-01-12T02:41:07Z  in response to cstoneba
                      I missed a filter to pick up only relevant baselines.
                      But that will generate the same results from a statement that you already had earlier.

                      
                      (it & 
                      ". " & multiplicity of it as string) of unique values of values of results from (bes property whose (name of it contains 
                      "City")) of computers of results whose (relevant flag of it = 
                      
                      true) of bes fixlets whose (baseline flag of it and name of it as lowercase starts with 
                      "baseline_names")
                      


                      You should probably double check that
                      number of bes fixlets whose (baseline flag of it and name of it as lowercase starts with "baseline_names")
                      is returning only 1 baseline.
                      • cstoneba
                        cstoneba
                        182 Posts
                        ACCEPTED ANSWER

                        Re: Compliance Report

                        ‏2013-01-12T13:32:38Z  in response to Lee Wei
                        with my original code, i get a value of "16" for the results for "Miami", "12" with your code. The value should be "2", as that is the number of computers with ha value of "Miami".

                        something's still not quite right. Again, I'm looking for the number of applicable computers, not number of applicable fixlets.
                        • cstoneba
                          cstoneba
                          182 Posts
                          ACCEPTED ANSWER

                          Re: Compliance Report

                          ‏2013-01-15T16:35:07Z  in response to cstoneba
                          Hi Lee, any suggestions?
                          • Lee Wei
                            Lee Wei
                            598 Posts
                            ACCEPTED ANSWER

                            Re: Compliance Report

                            ‏2013-01-15T16:39:16Z  in response to cstoneba
                            Sorry that I don't know why you are not getting the correct results.
                            • cstoneba
                              cstoneba
                              182 Posts
                              ACCEPTED ANSWER

                              Re: Compliance Report

                              ‏2013-01-15T16:42:28Z  in response to Lee Wei
                              how do you do it in the Compliance by Computer Group report? I think i want something very similar for output, but instead of a list of servers, i want the servers broken down by a managed property.
                              • cstoneba
                                cstoneba
                                182 Posts
                                ACCEPTED ANSWER

                                Re: Compliance Report

                                ‏2013-01-15T21:15:17Z  in response to cstoneba
                                I'm almost there, tried going a different route of "bes computers" instead of "bes fixlets". I get results, however I can't seem to identify bes computers that have a relevant fixlet of the source fixlets of components of component groups of bes fixlets whose "blah"..., like i could when using "of bes fixlets".

                                (it, multiplicity of it as string) of unique values of values of results (bes property whose (name of it = "OS"), bes computers whose (exists relevant fixlet whose (baseline flag of it AND name of it as lowercase starts with "baseline_name")of it))