Is there a better to assign a connection profile to 1000+ Nodes than going to the settings>All settings>NCM settings>Connection profiles>Assign to Nodes.?
You could go into All Settings, Manage Nodes. Then select all the nodes you wish to change. Then click on Edit Properties. Scroll down to Connect Profile. Select it and fill out the details.
Then click on Submit.
i tried this for 100, The connection profile did not get applied to all.
Have you had a look at the Orion SDK? https://github.com/solarwinds/OrionSDK/wiki/NCM-Connection-Profiles
Just make sure they all have this turned on.