Sample data and fictitious database
Sample temperature data
Every new GoToManage Web account comes with some default sample data so you can search and graph trends over time on your first day, before your Web account has been up long enough to gather historical data of your own. The creation of each new company database on your GoToManage account also includes some pre-generated historical data for the same purpose. The sample is not updated, since your Crawler collects your own data after that. You can see this sample data in your GoToManage Navigator.
To start collecting your own historical data, set these on your Crawler:
- SNMP Credentials — Can log in to switches or routers on your system.
- Rescan Hosts — Rescans certain devices more frequently than usual.
- SNMP Interface Statistics — Collects periodic interface statistics from specific devices.
You can run the examples on this page against your own data in the GoToManage search field, or against fictitious data in the Query Sandbox.
Sample database
A fictitious database is used for examples in the GoToManage documentation. Many of the examples of PQL queries and statements in the documentation are based on the fictitious database described in this section.
As you can see, the data types defined for each device differ somewhat in this example. This is not a problem in GoToManage's tree-structured database. Information is collected incrementally by the Crawler, and the database expands to account for this. GoToManage adds new data types as the data is discovered. You don't need to know or define data types ahead of time. This gives the tree far more flexibility than a table-based database.
You can experiment with this sample database by executing the following
INSERT statement in your
Query Sandbox:
INSERT INTO / values {
network => {
device => {
system => {
name => '5627',
computed_vendor => 'LANIER',
computed_model => '5627',
computed_class => 'printer',
computed_score => '115'
},
os => {
version => 'LANIER 5627 5.20'
},
interface => {
name => 'eth0',
mac_address => '01:01:02:03:04:05',
in_octets => '1995335536',
out_octets => '248342455',
oper_status => '1'
}
},
device => {
system => {
name => 'ESMITH',
computed_vendor => 'Intel',
computed_class => 'server',
computed_score => '10'
},
os => {
version => 'Linux'
},
interface => {
name => 'eth0',
mac_address => '02:A1:A2:A3:A4:A4',
in_octets => '1229592351',
out_octets => '1472928781',
oper_status => '1'
},
interface => {
name => 'eth1',
mac_address => '03:A1:A2:A3:A4:A5',
in_octets => '0',
out_octets => '0',
oper_status => '0'
}
},
device => {
system => {
name => 'AJONES',
computed_vendor => 'Intel',
computed_class => 'server',
computed_score => '10'
},
os => {
version => 'Linux'
},
interface => {
name => 'eth0',
mac_address => '04:A1:A2:A3:A4:A8',
in_octets => '1223098455',
out_octets => '1523093749',
oper_status => '1'
},
interface => {
name => 'eth1',
mac_address => '05:A1:A2:A3:A4:A9',
in_octets => '0',
out_octets => '0',
oper_status => '0'
}
},
device => {
system => {
computed_model => 'Ethernet Switch',
computed_class => 'switch',
computed_score => '25'
},
os => {
version => 'Ethernet Switch'
},
interface => {
name => 'eth0',
mac_address => '06:13:72:F3:0A:F5',
in_octets => '0',
out_octets => '0',
oper_status => '2'
},
interface => {
name => 'eth1',
mac_address => '07:13:72:F3:0A:F6',
in_octets => '0',
out_octets => '0',
oper_status => '2'
}
},
device => {
system => {
name => 'KRYPTON',
computed_model => 'Windows Workstation',
computed_class => 'workstation',
computed_score => '125'
},
os => {
version => 'Darwin Kernel Version 9.2.2'
},
interface => {
name => 'eth0',
mac_address => '08:16:CB:FF:FE:66',
in_octets => '0',
out_octets => '346',
oper_status => '1'
},
interface => {
name => 'eth1',
mac_address => '09:16:CB:FF:FE:67',
in_octets => '0',
out_octets => '0',
oper_status => '2'
},
interface => {
name => 'eth2',
mac_address => '10:16:CB:FF:FE:68',
in_octets => '0',
out_octets => '0',
oper_status => '2'
},
interface => {
name => 'eth3',
mac_address => '11:16:CB:FF:FE:69',
in_octets => '1598233842',
out_octets => '2360815490',
oper_status => '1'
}
},
device => {
system => {
name => 'NISSINGETTY',
computed_vendor => 'Juniper Networks',
computed_model => 'Netscreen Router',
computed_class => 'router',
computed_score => '60'
},
os => {
version => 'NetScreen-5GT 5.1.043a'
},
interface => {
name => 'eth0',
mac_address => '12:10:D8:99:2B:C2',
in_octets => '1385354750',
out_octets => '1451321493',
oper_status => '1'
},
interface => {
name => 'eth1',
mac_address => '13:10:D8:99:2B:C1',
in_octets => '3312952833',
out_octets => '3239791359',
oper_status => '1'
}
}
}
}
Results of the sample database
You can use this sample database in your Sandbox to try out some of
the examples in this documentation.
The results of the above INSERT statement are as follows:
row:
*:
network:
device:
interface:
mac_address: 01:01:02:03:04:05
name: eth0
in_octets: 1995335536
out_octets: 248342455
oper_status: 1
system:
name: 5627
computed_vendor: LANIER
computed_model: 5627
computed_class: printer
computed_score: 115
os:
version: LANIER 5627 5.20
device:
interface:
mac_address: 02:A1:A2:A3:A4:A4
name: eth0
in_octets: 1229592351
out_octets: 1472928781
oper_status: 1
interface:
mac_address: 03:A1:A2:A3:A4:A5
name: eth1
in_octets: 0
out_octets: 0
oper_status: 0
system:
name: ESMITH
computed_vendor: Intel
computed_class: server
computed_score: 10
os:
version: Linux
device:
interface:
mac_address: 04:A1:A2:A3:A4:A8
name: eth0
in_octets: 1223098455
out_octets: 1523093749
oper_status: 1
interface:
mac_address: 05:A1:A2:A3:A4:A9
name: eth1
in_octets: 0
out_octets: 0
oper_status: 0
system:
name: AJONES
computed_vendor: Intel
computed_class: server
computed_score: 10
os:
version: Linux
device:
interface:
mac_address: 06:13:72:F3:0A:F5
name: eth0
in_octets: 0
out_octets: 0
oper_status: 2
interface:
mac_address: 07:13:72:F3:0A:F6
name: eth1
in_octets: 0
out_octets: 0
oper_status: 2
system:
computed_model: Ethernet Switch
computed_class: switch
computed_score: 25
os:
version: Ethernet Switch
device:
interface:
mac_address: 08:16:CB:FF:FE:66
name: eth0
in_octets: 0
out_octets: 346
oper_status: 1
interface:
mac_address: 09:16:CB:FF:FE:67
name: eth1
in_octets: 0
out_octets: 0
oper_status: 2
interface:
mac_address: 10:16:CB:FF:FE:68
name: eth2
in_octets: 0
out_octets: 0
oper_status: 2
interface:
mac_address: 11:16:CB:FF:FE:69
name: eth3
in_octets: 1598233842
out_octets: 2360815490
oper_status: 1
system:
name: PROTON
computed_model: Windows Workstation
computed_class: workstation
computed_score: 125
os:
version: Darwin Kernel Version 9.2.2
device:
interface:
mac_address: 12:10:D8:99:2B:C2
name: eth0
in_octets: 1385354750
out_octets: 1451321493
oper_status: 1
interface:
mac_address: 13:10:D8:99:2B:C1
name: eth1
in_octets: 3312952833
out_octets: 3239791359
oper_status: 1
system:
name: NISSINGETTY
computed_vendor: Juniper Networks
computed_model: Netscreen Router
computed_class: router
computed_score: 60
os:
version: NetScreen-5GT 5.1.043a
See also examples run against this sample database.
