Topic
  • 5 replies
  • Latest Post - ‏2014-09-17T15:10:00Z by RobertKurt
cstoneba
cstoneba
182 Posts

Pinned topic member of bes computer group?

‏2013-12-12T17:12:43Z |

HI,  I'm trying to do a simple report in WR that displays if bes computers are a member of a specific BES computer group.  I can't seem to get it to work though.

 

(name of it, member of bes computer group whose (id of it = 1234)) of bes computers whose (name of it = "a;ldfkj')

Anyone know what I'm doing wrong?

thanks

  • MattPeterson
    MattPeterson
    3 Posts

    Re: member of bes computer group?

    ‏2014-01-06T22:41:08Z  

    I wasn't able find a way to associate a computer to a group, but I could the other way around, the statement below works, but there probably is a better way to do this....

    exist substring "computername" of (substrings separated by " " of (concatenation " " of (names of members of bes computer group whose (id of it = 1234))))

  • Lee Wei
    Lee Wei
    599 Posts

    Re: member of bes computer group?

    ‏2014-01-07T02:09:02Z  

    I wasn't able find a way to associate a computer to a group, but I could the other way around, the statement below works, but there probably is a better way to do this....

    exist substring "computername" of (substrings separated by " " of (concatenation " " of (names of members of bes computer group whose (id of it = 1234))))

    This is what I had used before to get the Computer Groups where a Computer is a member of.

    (name of item 1 of it) of (
        bes computers whose (name of it = "Clifden") ,
        bes computer groups)
    whose (size of ((member set of item 1 of it) - (set of item 0 of it)) < size of member set of item 1 of it)
     

    So if you want to know if the computer CLIFDEN is part of the HUFF group, you can try:

    exists (name of item 1 of it) of (
        bes computers whose (name of it = "Clifden") ,
        bes computer groups whose (name of it = "Huff") )
    whose (size of ((member set of item 1 of it) - (set of item 0 of it)) < size of member set of item 1 of it)
     

    Lee Wei

     

  • nagaraj.s
    nagaraj.s
    12 Posts

    Re: member of bes computer group?

    ‏2014-02-20T13:09:53Z  
    • Lee Wei
    • ‏2014-01-07T02:09:02Z

    This is what I had used before to get the Computer Groups where a Computer is a member of.

    (name of item 1 of it) of (
        bes computers whose (name of it = "Clifden") ,
        bes computer groups)
    whose (size of ((member set of item 1 of it) - (set of item 0 of it)) < size of member set of item 1 of it)
     

    So if you want to know if the computer CLIFDEN is part of the HUFF group, you can try:

    exists (name of item 1 of it) of (
        bes computers whose (name of it = "Clifden") ,
        bes computer groups whose (name of it = "Huff") )
    whose (size of ((member set of item 1 of it) - (set of item 0 of it)) < size of member set of item 1 of it)
     

    Lee Wei

     

    hi lee

     

    can I take report in multiple DNS OR IP in MULTIPLE COLUME

  • jgstew
    jgstew
    33 Posts

    Re: member of bes computer group?

    ‏2014-02-20T16:44:02Z  
    • nagaraj.s
    • ‏2014-02-20T13:09:53Z

    hi lee

     

    can I take report in multiple DNS OR IP in MULTIPLE COLUME

    You should post this to a new thread.

  • RobertKurt
    RobertKurt
    12 Posts

    Re: member of bes computer group?

    ‏2014-09-17T15:10:00Z  
    • Lee Wei
    • ‏2014-01-07T02:09:02Z

    This is what I had used before to get the Computer Groups where a Computer is a member of.

    (name of item 1 of it) of (
        bes computers whose (name of it = "Clifden") ,
        bes computer groups)
    whose (size of ((member set of item 1 of it) - (set of item 0 of it)) < size of member set of item 1 of it)
     

    So if you want to know if the computer CLIFDEN is part of the HUFF group, you can try:

    exists (name of item 1 of it) of (
        bes computers whose (name of it = "Clifden") ,
        bes computer groups whose (name of it = "Huff") )
    whose (size of ((member set of item 1 of it) - (set of item 0 of it)) < size of member set of item 1 of it)
     

    Lee Wei

     

    So, what would the code look like if I wanted to list:

    name of bes computer, name of bes computer group for all, or for bes computer group being a certain value?