(imported topic written by AakashK)
Hi,
When I am running the following relevance I am getting the output
number of operating systems of bes computers
10
But I want to get the output for specific OS. I am running the below relevance & getting the ouput
number of operating systems of bes computers whose (name of it as string as lowercase contains “win”)
0
(number of it) whose (operating system of it as lowercase contains “win”) of bes computers
0
or if we can get output for subscribe site like no of servers subscribe to patches for windows.
Thanks
Aakash
(imported comment written by kapax00)
Aakash,
you may probably want to try the following relevance to show how may systems you have for any operating system:
(multiplicity of it, it) of unique values of operating systems of bes computers
That will aggregate the number of operating systems (with their versions in this case, different win version will be considered different OS… ) and show teh counts.
About your 0, the whose clause work a little differen from your use:
you should use
number of operating systems whose (it as string as lowercase contains “Win”) of bes computers
or to show the split between Windows versions:
(multiplicity of it, it) of unique values of operating systems whose (it as string contains “Win”) of bes computers
hope this helps
Andrea
(imported comment written by AakashK)
Thanks Andrea
number of operating systems whose (it as string as lowercase contains “Win”) of bes computers still showed me result 0.
number of bes computers whose (operating system of it contains “Win”) worked for me.
(imported comment written by gearoid)
8 computers: 2 x windows, 3 x RHEL, 1 x Fedora, 2 x SuSE.
Q: number of bes computers
A:8
Q: number of operating systems of bes computers
A:8
Q: number of bes computers whose (operating system of it contains “Win”)
A: 2
Q: number of bes computers whose (operating system of it contains “Linux”)
A: 6
Q: nubmer of bes computers whose (operating system of it contains “SuSE”)
A: 2
There shouldn’t be any need to cast operating systems to lowercase.
(imported comment written by AakashK)
Thanks gearoid
This has helped me with my query