NV Devices

Mysql nms2 -P 3308 -s -e ""select dev_name from  devices "" >> device_inventory.txt

Quick NetVoyant Device Query

This query will the total of devices for each device class in NetVoyant.

mysql nms2
select count(*), class_name from devices d join device_classes dc on d.class_id=dc.class_id 

group by class_name;

To show this as only enabled devices, add an additional filter for the poll_enable field.

mysql nms2
select count(*), class_name from devices d join device_classes dc on d.class_id=dc.class_id 

where d.poll_enable=1 group by class_name;

NetVoyant Device list

mysql -h 10.80.3.8 -D nms2 -u nmsuper -predpoint -N -e "select smgr_host, dev_alias, model_name, ifindex, ifdescr, pollinst_desc, concat(d.sys_name,'_',i.ifindex) from service_managers s, devices d, device_models m, interfaces i, pollinst p where s.smgr_id=d.dev_owner AND p.device_id=d.device_id AND d.model_id=m.model_id AND p.pollinst_id=i.interface_id AND p.pollinst_enabled=1 and d.class_id in (1,7)" > NVInterfaces.txt

Method to export NV device list data?

Mysql.exe nms2 -e "select dev_name from devices where poll_enable = 1" > path\export_file.txt

RA Fix #2

1)You can try the following on the RA console.

mysql -P3308 reporter

delete from database_servers_scheduler where resultcode not like '%SUCCEEDED%';

2)Then recycle the ReporterAnalyzer Manager service on the RA console and the "DSA Loader Service" on the DSA and see if those tables start updating or not.

Then wait about 15-30 minutes to see if any new data shows up.

3)If not, just delete the interface from the "Administration->Physical & Virtual", this will delete the agent record from the database and should clean up the DSA.

4)Then delete the full router from "Administration->Enable Interfaces"

5)RDP to the Harvester and run the following....

mysql -P3308 harvester

truncate table routers;

truncate table interfaces;

6)Recycle the "Harvester" and "Reaper" Services on the Harvester.

7)Wait for the router to show up again in "Enable Interfaces" and enable the interfaces.

8)Wait at least 15-30 minutes before expecting any data

9)If no data, run an NFA Parser report and verify that specific interface has more than 50 KB of traffic over a 15 minute period.

RA Router fix issue

If you look at the report for this interface for less than two hours do you see any data?

Are other devices using the same DSA having the same issue?

You could use the query below to find out what other interfaces are using that DSA.  Use the router Address in the first query to find out what DSA its using, then use the DSA address in the second query to see what other devices are using that DSA.

mysql -P3308 reporter

select DataServerAddress, RouterAddress from agents_all_view where RouterAddress='x.x.x.x';

select * from agents_all_view where DataServerAddress="x.x.x.x";

Can you also upload a SupportCIG file if possible so I can see what is going on in the logs?

ftp://ftp.ca.com/pub/netqos/supporttools/releasedtools/SupportCIG.exe

You may also want to check the DSA credentials on the Administration->DSA page to make sure they are a valid login for the RA console and the account is not locked out or anything like that.

Copy/Paste

http://www.evernote.com/shard/s4/sh/9ce13685-da6f-40f3-b48a-5130deed047a/f9fd89c5f795d9863769e476e5b4f2ce