Server Names in SIM 4.2 - Lower Case - Upper Case

[Jim Cochran]

Where does SIM pull the server name from? I have some in lower case and some in upper case. I tried to manually add the server and change the case, but that didn't work.

Thanks,

Jim

[David Claypool]

DNS. Use NSLOOKUP too see what your DNS is returning.

[Jim Cochran]

It can't be...everything in our DNS servers are the same case.

Thanks,

Jim

[Aravindh Rajaram]

If you are very interested in having in one particular case, here is a way...

If you want all systems in UPPER case then execute the query

"update name set name=upper(name)"

If you want all systems in lower case then execute the query

"update name set name=lower(name)"

This is not a permanent solution though! Every time a new device is added, may be you need to re-run the command. Also, running identification on the systems will switch it back to its original state.

[Jim Cochran]

That might work for me. Really nitpicky, but that's just the way I am!

Thanks,

Jim

[Aravindh Rajaram]

Jim,

Silly me! In the queries i gave in my previous post, the table name was wrong :(

Here are the correct queries...

1) update devices set name=upper(name)

2) update devices set name=lower(name)

Sorry for the confusion!

[Michael Hopwood_1]

This is what I've found...

The name is pulled from DNS when you first discover it. It doesn't use the case you typed in the "System name:" field.

If you're using Microsoft DNS, and Windows computers, the name in DNS is drawn from the name of the computer.

Therefore, in a Windows environment, to change case you have to...

1) Rename your computer with the preferred case.
2) Re-register the computer with DNS.
3) Delete and re-add the computer in SIM.

Sounds like a lot of work.

[Jim Cochran]

Perhaps I'll just have to live with it. Drives me crazy though.

Thanks!

Jim

[Hochmuth_1]

If you manualy change the name and change only from lower case to upper case, the changes won't be saved.

If you want to do so manualy, you have to change to a different name, save and than switch back with upper or lower cases as you want.

!!! realize, that the same name with upper or lower changes is also different to the SIM, so you have to edit your event-tasks, cause he isn't able to find the "old" system any more !!

[Jim Cochran]

You're right, that worked! When I tried to just edit the name before, it would eventually refresh to the previous name that had a different "case".

Thanks,

Jim