Add Asset Info to Nodes that are not Polled with Credentials

noisy-conjuror

I want to be able to add asset information to nodes that are either unmanaged (not polled) or polled via ICMP. 

Reason: I have a boatload of hardware that I need to report the warranty status on that I do not have credentials for (systems span 2 divisions, 4 states, and 20 sites).

Adding info manually would suffice, but programmatic import would be better (upload csv, powershell, sql script).

Background: The 2 divisions had different ways of running their IT departments, so there wasn’t a lot of consistency setting up these systems.  Polling has been a challenge.  I thought that if I could just get the systems in via ICMP polling, I could manually enter the warranty info into the [AssetInventory_ServerInformation] table.  But nodes aren’t added there for un-credentialed polling.  SNMP polling does populate that table after rediscover, but the Nutanix MIB doesn’t seem to include the hardware serial number.  So I still need to enter in [HardwareSerialNumber], [Manufacturer], [Model], & [WarrantyDate] manually into the table for each system (I back up the db frequently).

USE [SolarWindsOrion]
GO
UPDATE [dbo].[AssetInventory_ServerInformation]
SET [HardwareSerialNumber] = 'xxxxxxxxxx',
    [Manufacturer] = 'Nutanix Inc.',
    [Model]        = 'NX-1175S-G6',
    [WarrantyDate] = '2022-12-31 23:59:59.000'
WHERE [NodeID] LIKE '11111';

aLTeReGo

Could you not achieve this using Custom Properties? With Custom Properties you can define exactly what information you want about the node, enter that information by hand, make that information required if you like as part of adding the node, or even programmatically populate these values as part of a script.