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.
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.
Hmm. Looking at this, it seems we do allow searching of inventory serial numbers. Iâm not sure how to test the scenario you describe in this case. All the serials from the inventory table that I searched for appeared ok. 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.
Can confirm. I have a stack of Cisco Catalyst switches and I can search for the serial of all chassis in the stack both via global search box and the Hardware Inventory page. /Markus
Den ons 10 juli 2019 18:26Adam Armstrong via observium < observium@observium.org> skrev:
Hmm. Looking at this, it seems we do allow searching of inventory serial numbers.
Iâm not sure how to test the scenario you describe in this case. All the serials from the inventory table that I searched for appeared ok.
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. _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Did we not add inventory searching for you?
I forgot who caused what!
Adam.
â£Sent from BlueMail â
On 10 Jul 2019, 18:38, at 18:38, Markus Klock via observium observium@observium.org wrote:
Can confirm. I have a stack of Cisco Catalyst switches and I can search for the serial of all chassis in the stack both via global search box and the Hardware Inventory page. /Markus
Den ons 10 juli 2019 18:26Adam Armstrong via observium < observium@observium.org> skrev:
Hmm. Looking at this, it seems we do allow searching of inventory
serial
numbers.
Iâm not sure how to test the scenario you describe in this case. All
the
serials from the inventory table that I searched for appeared ok.
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. _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Adam Armstrong -
Andrew Lemin -
Markus Klock