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

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"))
  • cstoneba
    cstoneba
    182 Posts

    Re: Compliance Report

    ‏2012-11-13T14:09:49Z  
    anyone?
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Compliance Report

    ‏2012-11-14T18:41:33Z  
    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

    Re: Compliance Report

    ‏2012-11-14T19:16:25Z  
    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:

    <pre class="jive-pre"> ( 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") </pre>
    i want a breakdown by OS of the unique number of servers that are applicable for baselines.
  • cstoneba
    cstoneba
    182 Posts

    Re: Compliance Report

    ‏2012-11-26T20:05:11Z  
    • cstoneba
    • ‏2012-11-14T19:16:25Z
    i want a breakdown by OS of the unique number of servers that are applicable for baselines.
    anyone know how to do that?
  • cstoneba
    cstoneba
    182 Posts

    Re: Compliance Report

    ‏2012-12-13T16:57:37Z  
    • cstoneba
    • ‏2012-11-26T20:05:11Z
    anyone know how to do that?
    anyone?
  • cstoneba
    cstoneba
    182 Posts

    Re: Compliance Report

    ‏2013-01-11T19:25:09Z  
    • cstoneba
    • ‏2012-12-13T16:57:37Z
    anyone?
    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
    599 Posts

    Re: Compliance Report

    ‏2013-01-11T22:41:29Z  
    • cstoneba
    • ‏2013-01-11T19:25:09Z
    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")))
    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

    Re: Compliance Report

    ‏2013-01-11T23:41:11Z  
    • Lee Wei
    • ‏2013-01-11T22:41:29Z
    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?
    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
    599 Posts

    Re: Compliance Report

    ‏2013-01-11T23:56:25Z  
    • cstoneba
    • ‏2013-01-11T23:41:11Z
    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.
    Can you show us an example output?
  • cstoneba
    cstoneba
    182 Posts

    Re: Compliance Report

    ‏2013-01-12T00:04:00Z  
    • Lee Wei
    • ‏2013-01-11T23:56:25Z
    Can you show us an example output?
    City. # of applicable computers
    Chicago. 10
    NYC. 15
    Miami. 20
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Compliance Report

    ‏2013-01-12T00:09:16Z  
    • cstoneba
    • ‏2013-01-11T23:41:11Z
    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.
    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

    Re: Compliance Report

    ‏2013-01-12T00:52:52Z  
    • Lee Wei
    • ‏2013-01-12T00:09:16Z
    Here is an example statement for you. Hopefully you can use it.

    <pre class="jive-pre"> (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") </pre>
    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
    599 Posts

    Re: Compliance Report

    ‏2013-01-12T02:41:07Z  
    • cstoneba
    • ‏2013-01-12T00:52:52Z
    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.
    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

    Re: Compliance Report

    ‏2013-01-12T13:32:38Z  
    • Lee Wei
    • ‏2013-01-12T02:41:07Z
    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.

    <pre class="jive-pre"> (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") </pre>

    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.
    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

    Re: Compliance Report

    ‏2013-01-15T16:35:07Z  
    • cstoneba
    • ‏2013-01-12T13:32:38Z
    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.
    Hi Lee, any suggestions?
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Compliance Report

    ‏2013-01-15T16:39:16Z  
    • cstoneba
    • ‏2013-01-15T16:35:07Z
    Hi Lee, any suggestions?
    Sorry that I don't know why you are not getting the correct results.
  • cstoneba
    cstoneba
    182 Posts

    Re: Compliance Report

    ‏2013-01-15T16:42:28Z  
    • Lee Wei
    • ‏2013-01-15T16:39:16Z
    Sorry that I don't know why you are not getting the correct results.
    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

    Re: Compliance Report

    ‏2013-01-15T21:15:17Z  
    • cstoneba
    • ‏2013-01-15T16:42:28Z
    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.
    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))
  • cstoneba
    cstoneba
    182 Posts

    Re: Compliance Report

    ‏2013-02-14T18:27:46Z  
    • cstoneba
    • ‏2013-01-15T21:15:17Z
    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))
    can anyone help me out here?