Incomplete hardware inventory collected when machines have multiple IPs

%3CLINGO-SUB%20id%3D%22lingo-sub-1177183%22%20slang%3D%22en-US%22%3EIncomplete%20hardware%20inventory%20collected%20when%20machines%20have%20multiple%20IPs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177183%22%20slang%3D%22en-US%22%3E%3CP%3Ehardware%20inventory%20not%20able%20to%20collect%20the%20details%20for%20%22Network_Data%22%20from%20the%20clients%20when%20the%20machine%20has%20multiple%20IP%20addresses%20%2C%20The%20field%20IPAddress00%20field%20is%20defined%20as%20varchar(255)%2C%20the%20field%20length%20prevents%20us%20from%20collecting%20all%20the%20IP%20details%20when%20the%20combined%20length%20of%20IP%20addresses%20in%20that%20machine%20exceeds%20255.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20externally%26nbsp%3Bmodifying%20the%20schema%20of%20SCCM%20DB%20is%20not%20supported%2C%20how%20could%20we%20achieve%20this%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1177183%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHardware%20Inventory%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

hardware inventory not able to collect the details for "Network_Data" from the clients when the machine has multiple IP addresses , The field IPAddress00 field is defined as varchar(255), the field length prevents us from collecting all the IP details when the combined length of IP addresses in that machine exceeds 255.

 

As externally modifying the schema of SCCM DB is not supported, how could we achieve this?

Thanks.

0 Replies