How to store 100k ids in a field in a table?

[Baishnabi]

I have a scenario where there is a query with certain names of instances stored in a string field. Now i have to extract the corresponding ids for these instance names in the query from cmdb table and store it to process it at a later point. There could be upto 100k names in that instance list. Whats the most ideal way to handle this? Should i extract the ids and store it in a separate string field in the same table? Or create a new table to map a set of ids? Please advise.

example query : u_nameINinsxyz,insxyz2,insxyz3... (upto 100k)

expected instance ids list : 

"f918b7341be7fcd07504751f034bcbbb,f918b7341be7fcd07504751f034bcbbb..." (upto 100k)

Am skeptical if its good practice to store such long strings.

[TamoghnaB]

Thanks @Baishnabi . For licensing - if your organization falls under "Enterprise level Licensing"  then you might already be covered.  Otherwise, please check the your product owner / ServiceNow account manager about the exact licensing implications.

Please mark reply as Helpful/Correct, if applicable. Thanks!

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Thank you!

[Baishnabi]

Got it, thanks

[JackieZhang]

try to store it at one attachment

[Baishnabi]

Hi Jackie - by attachment, you mean a separate file? please help explain a bit on how to do this.

[Ankur Bawiskar]

@Baishnabi 

I believe custom table is the only way forward.

But remember there is license cost involved with it.

If my response helped please mark it correct and close the thread so that it benefits future readers.