-
Re: Device names cut off in "Caption" database column
Steven KlassenJan 6, 2010 8:57 AM (in response to slinky103)
There's a known issue in the discovery engine that's causing this. I ran a ticket with SolarWinds and they said it would be prohibitively difficult to resolve so I suppose it'll get sorted out during the next major revision, but no promises yet.
You're right about the field types; it's actually getting truncated from the time they're discovered to the time they wind up in the database. As a workaround, I got all the customer's inventory imported and then ran a query that copied the sysname field to the caption.
update nodes set caption = sysname where sysname is not null and sysname != ''
-
Re: Device names cut off in "Caption" database column
slinky103 Jan 6, 2010 9:50 AM (in response to Steven Klassen)Thank you for the feedback. I figured it was some sort of bug. The weird thing is that I have a SW deployment that has been upgraded throughout time since the early 8.x releases and it doesn't have the problems. We recently installed a fresh 9.5 for balancing our polls between data centers. The fresh install is the only one with the problem.
Thanks for the query! I will run it and see how it goes.
-
Re: Device names cut off in "Caption" database column
Steven KlassenJan 6, 2010 10:06 AM (in response to slinky103)
Glad to help - the 8.x version predates me, but I'm certain 9.x has the problem everywhere.
-
-