3 Replies Latest reply on Jan 6, 2010 10:06 AM by Steven Klassen

Device names cut off in "Caption" database column

slinky103 Jan 5, 2010 10:51 AM

The "caption" column in the nodes table for NPM is cutting off the device names. The DNS and SysName columns are correct, but the "Caption" column seems like there is a character limit. When I looked at the table in the SQL Server Management Studio all three columns are set to a 255 character limit. Any ideas?

Re: Device names cut off in "Caption" database column

Steven Klassen Jan 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 != ''
Like (0)

Actions
- 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.
  
  Like (0)
  
  Actions
  - Re: Device names cut off in "Caption" database column
    
    Steven Klassen Jan 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.
    
    Like (0)
    
    Actions

Go to original post