import software information from excel to softwaer table

[tmiya]

Hello expert.

I would like to register software information managed in Excel with ServiceNow and normalize it.

I know ServiceNow has a [cmdb_sam_sw_install] table that manages software information in SAM, usually is populated by Discovery.

For some software, I want to manually register from Excel and normalize information in this table instead of using discovery.

However, when I check the ACL of the table, create is marked as nobody, so I think it is not possible.

How to do it? 

Should I change the ACL temporarily?

It is assumed that the record information managed in Excel is reliable.

[Keshav07 · Accepted solution]

Hi @tmiya ,

You can make use of Transform Maps to create the records in the Software Installation table.

Start by loading the data and creating an import set table, Create a transform map and associate the import set table and map the fields.

If you find this helpful, mark it as helpful.

Thank you.

[tmiya]

Thank you Keshav07.

I try importset.

After trying, if issue is solved, mark your answer solved.

Please wait.