Is there a way to generate an inventory change report within NPM or NCM?
I have a user who is looking for something that will only list those devices that have been added or removed from the inventory.
Thanks
This is the SQL behind that report; and I have tested in 2 environments today with success showing both Node Added and Node Removed events.
select netobjecttype ,netobjectid ,eventtime as 'EVENT TIME' ,case when convert(varchar(10), eventtype) = 8 then 'Node Removed' when convert(varchar(10), eventtype) = 9 then 'Node Added' end as 'EVENT TYPE' ,n.caption as 'DEVICE' ,MESSAGEfrom eventsjoin nodes n on n.nodeid = netobjectid--THIS LINE LIMITS REPORTED EVENTS TO 8(NODE REMOVED) AND 9(NODE ADDED)where eventtype in ('8','9')--THIS LINE LIMITS REPORTED EVENTS TO THE LAST 7 DAYSand eventtime > (getdate()-7)order by eventtime ASC
Here's one that will cover the last 7 days for NPM.
You can change the time period, but it is dependent on the event log retention settings.
Nodes Added and Removed_Last 7 Days
Thanks.
This will be quite helpful.
Hmm. This is working fine for nodes added but nodes removed don't show in the report.
Also where can I get a list of valid EVENT TYPES? I have looked through the Admin Guide and here on Thwack without finding anything.
Suggestions?
SELECT EventType, Name FROM EventTypes
ID NAME1 Node Down2 Node Warning5 Node Up8 Node Removed9 Node Added10 Interface Down11 Interface Up12 Interface Shutdown13 Interface Unknown14 Node Rebooted15 Critical System Error16 Interface Added17 Interface Removed18 Interface Remapped19 Interface Changed20 Monitoring Started21 Monitoring Stopped22 Interface Enabled23 Interface Disappeared24 Interface Reappeared25 Fail Over26 Fail Back30 Application Stopped31 Application Restart40 UnManage Node41 Manage Node50 Group Down51 Group Warning52 Group Up53 Group Members Changed56 Group Created57 Group Removed58 Group Critical59 Group External60 Group Shutdown61 Group Testing62 Group Unknown63 Group Unmanaged64 Group Unreachable65 Group Unplugged66 Group Disabled99 Polling Method Changed100 Node Changed140 UnManage Interface141 Manage Interface150 NPM BL Service Started151 NPM BL Service Stopped152 VRF Added153 VRF Removed200 Volume Remapped201 Volume Changed202 Volume Added203 Volume Removed210 Volume Disappeared211 Volume Reappeared300 NetFlow Receiver Service Started301 NetFlow Receiver Service Stopped302 Unmanaged NetFlow Node303 Unmonitored NetFlow Interface Automatically Added304 NetFlow Event305 ObsoleteDontUseIt1306 Unmanaged NetFlow Interface307 Unmonitored NetFlow Interface308 Invalid Template309 No Template Received310 ObsoleteDontUseIt2311 Unsupported Incoming Flow312 Not Enabled NetFlow Data Export313 ICMP NetFlow Node314 Not Primary NPM Node IP Address315 Notification Reset320 NetFlow Licensing323 Informational340 Netflow service time difference warning341 Netflow service time difference error342 NetFlow Critical400 VoIP and Network Quality Manager Service Started401 VoIP and Network Quality Manager Service Stopped402 VoIP and Network Quality Manager Critical403 VoIP and Network Quality Manager Licensing404 IP SLA Error405 VoIP CallManager Error500 SAM Service Started501 SAM Service Stopped502 SAM Application Created503 SAM Application Deleted504 SAM Application Up505 SAM Application Down506 SAM Monitor Up507 SAM Monitor Down508 SAM Licensing509 SAM Critical510 SAM Warning511 SAM Application Unmanaged512 SAM Application Managed513 SAM Application Unreachable514 Hardware Unknown515 Hardware Undefined516 Hardware Unmanaged517 Hardware Managed518 Hardware Unreachable519 Hardware Up520 Hardware Warning521 Hardware Critical522 Hardware Down523 Hardware Type Unknown524 Hardware Type Up525 Hardware Type Warning526 Hardware Type Critical527 Hardware Type Down528 Hardware Sensor Unknown529 Hardware Sensor Up530 Hardware Sensor Warning531 Hardware Sensor Critical532 Hardware Sensor Down533 SAM Baseline Thresholds Applied534 SAM Baseline Thresholds Error600 NPM Module Engine Started601 NPM Module Engine Stopped602 NPM Licensing603 Rogue Detected604 Thin AP Disappeared605 Multicast traffic down700 VIM Service Started701 VIM Service Stopped900 IPAM Information901 IPAM Critical902 IPAM Warning905 IPAM Custom Role Added906 IPAM Custom Role Removed907 IPAM Custom Role Changed910 IPAM Supernet Added911 IPAM Supernet Removed912 IPAM Supernet Changed915 IPAM IPv6 Site Added916 IPAM IPv6 Site Removed917 IPAM IPv6 Site Changed920 IPAM Subnet Added921 IPAM Subnet Removed922 IPAM Subnet Changed925 IPAM DNS Server Added926 IPAM DNS Server Removed927 IPAM DNS Server Changed930 IPAM Group Added931 IPAM Group Removed932 IPAM Group Changed933 IPAM DNS Zone Transfer Information934 IPAM DNS Zone Transfer Failure935 IPAM DNS Zone Transfer Canceled936 IPAM ASA Credential Added937 IPAM ASA Credential Removed938 IPAM ASA Credential Changed940 IPAM IP Node Added941 IPAM IP Node Removed942 IPAM IP Node Changed943 IPAM DNS Zone Added944 IPAM DNS Zone Removed945 IPAM DNS Zone Changed946 IPAM DNS Record Added947 IPAM DNS Record Removed948 IPAM DNS Record Changed950 IPAM SNMP Credential Added951 IPAM SNMP Credential Removed952 IPAM SNMP Credential Changed955 IPAM Custom Field Added956 IPAM Custom Field Removed957 IPAM Custom Field Changed960 IPAM Subnet Scan Information961 IPAM Subnet Scan Failure962 IPAM Subnet Scan Canceled963 IPAM Subnet Scan MacMismatch964 IPAM Subnet Scan Timeout965 IPAM DHCP Reservation Added966 IPAM DHCP Reservation Removed967 IPAM DHCP Reservation Changed968 IPAM DNS Server Scan Failure970 IPAM DHCP Server Scan Failure971 IPAM DHCP Scope Scan Failure972 IPAM DHCP Exclusion Range Added973 IPAM DHCP Exclusion Range Removed974 IPAM DHCP Exclusion Range Changed975 IPAM Neighbor Scan Failure976 IPAM Neighbor Scan Information977 IPAM DHCP Options Added978 IPAM DHCP Options Removed979 IPAM DHCP Options Changed980 IPAM Windows Credential Added981 IPAM Windows Credential Removed982 IPAM Windows Credential Changed985 IPAM CISCO Credential Added986 IPAM CISCO Credential Removed987 IPAM CISCO Credential Changed990 IPAM DHCP Server Added991 IPAM DHCP Server Removed992 IPAM DHCP Server Changed995 IPAM IPv6 Global Prefix Added996 IPAM IPv6 Global Prefix Removed997 IPAM IPv6 Global Prefix Changed1000 Informational1001 Warning1002 Critical1500 CoreBL Service Started1501 CoreBL Service Stopped1502 CoreBL Licensing5000 Alert Triggered5001 Alert Reset6100 Transaction Down6101 Transaction Critical6102 Transaction Warning6103 Transaction Up6104 Transaction Enabled6105 Transaction Unmanaged6106 Transaction Unknown6107 Transaction Created6108 Transaction Removed6109 Location Added6110 Location Removed6111 Location Unavailable6112 Location Available6113 Service Started6114 Service Stopped6115 Licensing6200 UDT Service Started6201 UDT Service Stopped6202 UDT Licensing6203 UDT Data Migration Started6204 UDT Data Migration Completed
ID NAME
1 Node Down
2 Node Warning
5 Node Up
8 Node Removed
9 Node Added
10 Interface Down
11 Interface Up
12 Interface Shutdown
13 Interface Unknown
14 Node Rebooted
15 Critical System Error
16 Interface Added
17 Interface Removed
18 Interface Remapped
19 Interface Changed
20 Monitoring Started
21 Monitoring Stopped
22 Interface Enabled
23 Interface Disappeared
24 Interface Reappeared
25 Fail Over
26 Fail Back
30 Application Stopped
31 Application Restart
40 UnManage Node
41 Manage Node
50 Group Down
51 Group Warning
52 Group Up
53 Group Members Changed
56 Group Created
57 Group Removed
58 Group Critical
59 Group External
60 Group Shutdown
61 Group Testing
62 Group Unknown
63 Group Unmanaged
64 Group Unreachable
65 Group Unplugged
66 Group Disabled
99 Polling Method Changed
100 Node Changed
140 UnManage Interface
141 Manage Interface
150 NPM BL Service Started
151 NPM BL Service Stopped
152 VRF Added
153 VRF Removed
200 Volume Remapped
201 Volume Changed
202 Volume Added
203 Volume Removed
210 Volume Disappeared
211 Volume Reappeared
300 NetFlow Receiver Service Started
301 NetFlow Receiver Service Stopped
302 Unmanaged NetFlow Node
303 Unmonitored NetFlow Interface Automatically Added
304 NetFlow Event
305 ObsoleteDontUseIt1
306 Unmanaged NetFlow Interface
307 Unmonitored NetFlow Interface
308 Invalid Template
309 No Template Received
310 ObsoleteDontUseIt2
311 Unsupported Incoming Flow
312 Not Enabled NetFlow Data Export
313 ICMP NetFlow Node
314 Not Primary NPM Node IP Address
315 Notification Reset
320 NetFlow Licensing
323 Informational
340 Netflow service time difference warning
341 Netflow service time difference error
342 NetFlow Critical
400 VoIP and Network Quality Manager Service Started
401 VoIP and Network Quality Manager Service Stopped
402 VoIP and Network Quality Manager Critical
403 VoIP and Network Quality Manager Licensing
404 IP SLA Error
405 VoIP CallManager Error
500 SAM Service Started
501 SAM Service Stopped
502 SAM Application Created
503 SAM Application Deleted
504 SAM Application Up
505 SAM Application Down
506 SAM Monitor Up
507 SAM Monitor Down
508 SAM Licensing
509 SAM Critical
510 SAM Warning
511 SAM Application Unmanaged
512 SAM Application Managed
513 SAM Application Unreachable
514 Hardware Unknown
515 Hardware Undefined
516 Hardware Unmanaged
517 Hardware Managed
518 Hardware Unreachable
519 Hardware Up
520 Hardware Warning
521 Hardware Critical
522 Hardware Down
523 Hardware Type Unknown
524 Hardware Type Up
525 Hardware Type Warning
526 Hardware Type Critical
527 Hardware Type Down
528 Hardware Sensor Unknown
529 Hardware Sensor Up
530 Hardware Sensor Warning
531 Hardware Sensor Critical
532 Hardware Sensor Down
533 SAM Baseline Thresholds Applied
534 SAM Baseline Thresholds Error
600 NPM Module Engine Started
601 NPM Module Engine Stopped
602 NPM Licensing
603 Rogue Detected
604 Thin AP Disappeared
605 Multicast traffic down
700 VIM Service Started
701 VIM Service Stopped
900 IPAM Information
901 IPAM Critical
902 IPAM Warning
905 IPAM Custom Role Added
906 IPAM Custom Role Removed
907 IPAM Custom Role Changed
910 IPAM Supernet Added
911 IPAM Supernet Removed
912 IPAM Supernet Changed
915 IPAM IPv6 Site Added
916 IPAM IPv6 Site Removed
917 IPAM IPv6 Site Changed
920 IPAM Subnet Added
921 IPAM Subnet Removed
922 IPAM Subnet Changed
925 IPAM DNS Server Added
926 IPAM DNS Server Removed
927 IPAM DNS Server Changed
930 IPAM Group Added
931 IPAM Group Removed
932 IPAM Group Changed
933 IPAM DNS Zone Transfer Information
934 IPAM DNS Zone Transfer Failure
935 IPAM DNS Zone Transfer Canceled
936 IPAM ASA Credential Added
937 IPAM ASA Credential Removed
938 IPAM ASA Credential Changed
940 IPAM IP Node Added
941 IPAM IP Node Removed
942 IPAM IP Node Changed
943 IPAM DNS Zone Added
944 IPAM DNS Zone Removed
945 IPAM DNS Zone Changed
946 IPAM DNS Record Added
947 IPAM DNS Record Removed
948 IPAM DNS Record Changed
950 IPAM SNMP Credential Added
951 IPAM SNMP Credential Removed
952 IPAM SNMP Credential Changed
955 IPAM Custom Field Added
956 IPAM Custom Field Removed
957 IPAM Custom Field Changed
960 IPAM Subnet Scan Information
961 IPAM Subnet Scan Failure
962 IPAM Subnet Scan Canceled
963 IPAM Subnet Scan MacMismatch
964 IPAM Subnet Scan Timeout
965 IPAM DHCP Reservation Added
966 IPAM DHCP Reservation Removed
967 IPAM DHCP Reservation Changed
968 IPAM DNS Server Scan Failure
970 IPAM DHCP Server Scan Failure
971 IPAM DHCP Scope Scan Failure
972 IPAM DHCP Exclusion Range Added
973 IPAM DHCP Exclusion Range Removed
974 IPAM DHCP Exclusion Range Changed
975 IPAM Neighbor Scan Failure
976 IPAM Neighbor Scan Information
977 IPAM DHCP Options Added
978 IPAM DHCP Options Removed
979 IPAM DHCP Options Changed
980 IPAM Windows Credential Added
981 IPAM Windows Credential Removed
982 IPAM Windows Credential Changed
985 IPAM CISCO Credential Added
986 IPAM CISCO Credential Removed
987 IPAM CISCO Credential Changed
990 IPAM DHCP Server Added
991 IPAM DHCP Server Removed
992 IPAM DHCP Server Changed
995 IPAM IPv6 Global Prefix Added
996 IPAM IPv6 Global Prefix Removed
997 IPAM IPv6 Global Prefix Changed
1000 Informational
1001 Warning
1002 Critical
1500 CoreBL Service Started
1501 CoreBL Service Stopped
1502 CoreBL Licensing
5000 Alert Triggered
5001 Alert Reset
6100 Transaction Down
6101 Transaction Critical
6102 Transaction Warning
6103 Transaction Up
6104 Transaction Enabled
6105 Transaction Unmanaged
6106 Transaction Unknown
6107 Transaction Created
6108 Transaction Removed
6109 Location Added
6110 Location Removed
6111 Location Unavailable
6112 Location Available
6113 Service Started
6114 Service Stopped
6115 Licensing
6200 UDT Service Started
6201 UDT Service Stopped
6202 UDT Licensing
6203 UDT Data Migration Started
6204 UDT Data Migration Completed
