Case Sensitiveness for Server/Hostname

Reporting
1

I’m running a relevance query which will get the server details like Servername,OS,last Reported time from Bigfix Console.

In BigFix Console, The server can be of Short name or with FQDN naming standard (For Ex: Server1 or Server1.domain.com)

Instance 1 : if the bigfix console has hostname as Server1.domain.com

From my tool, If the user provide input like

Server1
SERVER1

The output fails stating the server is not found in bigfix console.

Instance 2 : if the bigfix console has hostname as Server1

From my tool, If the user provide input like

Server1
SERVER1

The output returns 2 rows with server1 is available in bigfix console and SERVER1 is not available in bigfix console.

Is it possible to query against bigfix to getrid of this issue.

Say if the user gives shortname and if Bigfix has same server in FQDN format, the relevance query will get the server list.

2

Hello,

Can you share your query?

Seems like you just want to do something like:

Computer name as lowercase contains "user entry" as lowercase
3

I use the below query for getting the server details.

It will work for the instance where the computer name is shortname (NOT FQDN) in tool and as well bigfix console.

This query doesn’t get me the results if the server name is tagged with FQDN in bigfix console and user provides the short name.

My requirement is: If the user inputs with or without FQDN, The results will be populated from bigfix console.

((name of it) & “|” & (concatenation “” of values of results from ( bes properties whose (name of it = “OS”)) of it) & “|” & (concatenation “|” of values of results from ( bes properties whose (name of it = “Last Report Time”)) of it)) of bes computers whose ((preceding text of first “.” of (name of it as string & “.”)) is contained by set of ( “Server1”;“Server2”))

4

any reason you use the bes properties to get operating system and last report time ?
Those are available directly as properties of the bes computer object.
(name of it, last report time of it, operating system of it) of bes computers

1 Like
5

That clause works perfectly on my system. Are you casting for case - because it is case sensitive so you need to cast everything to the same case as @strawgate shows above.

1 Like
6

Hi Gearoid/Strawgate

I didn’t case the computer name to lower or upper case.

(name of it, last report time of it, operating system of it ) of bes computers whose ((preceding text of first “.” of (name of it as string & “.”)) is contained by set of ( “Server1”;“server2”))

This query fails if the user give the server name as short name, but in the bigfix console, it is given as FQDN.

7

this works for me:

(name of it, last report time of it, operating system of it ) of bes computers whose (preceding text of first "." of (name of it as lowercase & ".") is contained by set of ( "server1";"server2"))
2 Likes
8

This resolves the issue.Thank you so much