Update multiple scanning targets/schedules

[Smithers]

We have over 100 scanning targets and would like to update all the targets with new SNMP creds. Rather than doing this one by one which would take forever is there a way to run a SQL command to update all of them at once. We also would like to update our scanning schedules on these targets as well from daily to once a week. 

[rom]

Make an all-encompassing IP Range (example 10.0.1.1-10.0.254.254) and assign credentials to it.  I usually don't enable it as I make a really large range (it will warn you and turn it red).  If you make smaller encompassing ranges, you can enable the schedule if you want.

[Smithers]

We have already done this, but due to the nature of our environment, we have, I believe, close to 100 different subnets. The other issue is that we do not need all of these subnets to be scanned by lansweeper, so we have to set up these ranges as you suggested, except we have to do it for about 80 subnets. 

[StillGoing]

I was going to suggest that as well. I did this recently, creating one giant IP scanning range that includes all our subnets, and assigning all my SNMP credential sets to it. Yes, Lansweeper displays it in red and issued a warning about it, but it is disabled so I don't really care. And it works! I no longer have to figure out which credentials to assign to our 700+ scan ranges individually.

I know it isn't what you specifically requested, but it does make the whole process work without having to figure out how to bulk assign credentials.

[Smithers]

That's a great idea; unfortunately, this will not work in our environment since we do want to exclude some subnets, and this would create a situation where we must manually go and track down a whole host of assets that do not need to be included. 

[StillGoing]

Just to confirm, are you using IP Range scans for your targets? It does make a difference, as different scan types are stored in different tables. I have successfully update IP Range scans at the database level, mostly to make mass schedule changes or re-assign a group of ranges to a different scanner.

Changing credentials is a different ballgame, since you are working with correlation between multiple tables. It would be helpful to figure out, though; I find assigning credentials to multiple targets is very tedious.

[Smithers]

Yes, we are using IP Range scans currently. 

[saikumark]

Support Team, 

We have a similar use case.  Can you please provide a solution to update details (schedule, credentials, etc) for many targets at one shot, which will save lot of manual effort?