Device names cut off in "Caption" database column

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?

Find more posts tagged with

Accepted answers

mrxinu

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 != ''

All comments

mrxinu

update nodes set caption = sysname where sysname is not null and sysname != ''

slinky103

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.

mrxinu

Glad to help - the 8.x version predates me, but I'm certain 9.x has the problem everywhere.