Comtech EF Data NetVue Release 1.1 User Guide - Manual (Page 223)

Advanced Configuration (System Display) Revision 3
NetVue User Guide MN-NETVUE
10–86
• Value: -11
The Parameter value was cleared.
• Value: -12
The Parameter again received a value following -11.
• Value: -13
The Parameter value is the first value received for the Parameter in question since the Element was
started.
• Value: -14
The Parameter value is the first value received for the Parameter in question since the Element was
started. However, that value is an exception value.
• Value: -15
A new row has been added to the dynamic table in question.
• Value: -16
A row has been deleted from the dynamic table in question.
• Value: -17
Monitoring has been activated.
• Value: -18
Monitoring has been deactivated.
10.9.2.3 Examples of database queries
10.9.2.3.1 Microsoft SQL Server
If the central database is a Microsoft SQL Server database, every NetVue that is instructed to offload
(some of) its data copies that data to its local, publicly shared C:/Skyline DataMiner/System
Cache/Offload folder.
Next, on the central database, run a query to insert the offloaded data into the central database. The
query could be similar to this example:
BULK INSERT ALARM
FROM '\\NetVue-1\Offload\alarm\file.dat'
WITH (FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n')
NOTE: On Microsoft SQL Server, only members of the sysadmin and bulkadmin fixed
server roles have permission to execute BULK INSERT statements.