Hello. I am new to BigFix, and trying to get list of users in Presentation Debugger. I can get one user name against one Windows host like below:
(ip address of it, name of it, values of results(it, bes property "User Name")) of bes computers whose ( ip address of it = "10.11.12.13")
But how can you get list of users with multiple IP addresses? I have been doing like below but IP range get bigger and I need a better solution. I know how SQL works, but I cannot find a way to solve this.
(ip address of it, name of it, values of results(it, bes property "User Name")) of bes computers whose ( ip address of it = "10.11.12.13"), (ip address of it, name of it, values of results(it, bes property "User Name")) of bes computers whose ( ip address of it = "10.11.12.14"), (ip address of it, name of it, values of results(it, bes property "User Name")) of bes computers whose ( ip address of it = "10.11.12.15"),
(ip address of it, name of it, values of results(it, bes property "User Name")) of bes computers whose ( ip address of it = "10.11.12.13" OR ip address of it = "10.11.12.14" OR ip address of it = "10.11.12.15" )
Can I ask one more question? The result is one line with a lot of commas, Is there any way to break lines per each IP address? I tried to add “%0d%0a” and “\r\n”, but those do not work.
If you’re running the debugger in the “HTML output view” it will all appear on one line (as it would if this were an HTML document). In that case, you can concatenate the results together with htlm(" "), or instead run the presentation debugger in Text Output Mode.
Thank very much, Jason! I should have tried “String” instead of “HTML”. And it even gives me bonus which is “none” in greater and less than sings when no users were found for the IP. Thank you again!