There’s nothing built-in to the product to support this, you have to do it through sql.
You could use this query, and then copy the output into a text file:
select concat(scope_net,',',scope_mask) from discovery_scope where scope_includes=1;
it’ll only grab the included scopes, not the excluded ones.
Alex
Rob - I just found your blog and am excited to see there is another NetVoyant SQL tinkerer out there. I am interested to know if you could help me develop a sql query that would export the network profixes and their associated device names. This would be similiar to parsing the Networks group within the NetVoyant Master Console and seeing the devices related to each prefix. I am having problems finding what other tables reference the network_id field in the networks table. Hopefully you would find this mutually beneficial. --Ryan Mahoney, Sacramento (RJMahoneyatgmaildotcom)
ReplyDelete