Hi Andrew,

Are you talking about the global search at the top of the page?

At present the search is only searching for the device’s serial number, which is stored in the device table. Sometimes this is also in the inventory table under the chassis entry.

It’d be pretty easy to extend the search to inventory, but it might make things messy or slow, and there’s no single inventory entry for that search to link to.

Is the inventory page’s search not useful for this purpose? (it won’t find serials which are only on devices and don’t have an inventory entry)

Adam.

From: observium <observium-bounces@observium.org> On Behalf Of Andrew Lemin via observium
Sent: 10 July 2019 15:52
To: Laszlo Nemeth via observium <observium@observium.org>
Cc: Andrew Lemin <AndrewL@4d-dc.com>; Michael Yiapatos <michael@4d-dc.com>
Subject: [Observium] Serial Number searches not working properly

Hi list,

Hope everyone is well 😊

We have been using the serial number search feature a lot recently as part of an audit / support contract renewals. And we have found that when a stack of switches exists, only the first serial number for the first stack member is searchable!

When going to the device and selecting the ‘Inventory’ tab, we can see the serial numbers for all stack members. But the search query is not finding these ☹

After discovering this exclusion, we have tested some more and found that the issue also exists for line cards.

I.e. only the chassis serial number is searchable, the line card serial numbers in the chassis are not returning the node. Again, the serial numbers for the line cards are being correctly displayed in the Inventory.

So at a guess, it seems like the SQL query needs enhancing to include the referential child rows or tables for devices internal components (guessing stack slave members are treated like line cards).

Thanks for your thoughts,

Cheers Andy.