To query the LSM database:
# sh /home/LinMin/actions/LSM_DbQuery.sh
Query LinMin Database
View Entries Options:
ae) All Entries
lc) LSM Configuration Defaults
ld) LSM DHCP
lm) LSM Menu
ln) LSM Networking
lp) LSM Payload and Stages
lr) LSM DHCP Requests and Responses
mr) Machines Registered
mp) Machine Payload and Stages
se) Service Scripts
sn) Snapshots
ua) User Login Access
up) User Payload and Stages
---> key response, or "v" for view options, "q" to quit
Select view option:
Select the database elements you wish to inspect and drill down until you find the information you seek.
For example, to review LSM DHCP requests and responses, select the corresponding 2-letter option:
---> key response, or "v" for view options, "q" to quit
Select view option: lr
................................................................................
...LSM DHCP Request and Response Entries -- START
1) 00-12-23-49-5d-5d
2) 00-25-25-d3-5e-16
3) 00-50-12-34-4b-aa
4) 00-50-12-4e-d9-ff
5) 00-50-12-7c-32-cc
6) 00-50-12-8a-c9-dd
7) 00-50-12-b1-20-ee
...LSM DHCP Request and Response Entries -- END
................................................................................
---> key response, or "v" for view options, "q" to quit
Select by number from above: 3
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
...Log Entries: 00-50-12-34-4b-aa
................................................................................
- logType='NewAdd'
- logWhen='20190425-234012~2'
- responseDhcpMacDash='||>~>|00-50-12-34-4b-aa|'
- asOf='||>~>|20190425-234012~2|'
- dbTable='||>~>|responseDhcp|'
- responseDhcpMacColon='||>~>|00:50:12:34:4b:aa|'
- responseDhcpPxeFirst='||>~>|2019-04-25 23:40:07|'
- responseDhcpPxePrior='||>~>|2019-04-25 23:40:07|'
- responseDhcpPxeLast='||>~>|2019-04-25 23:40:07|'
- responseDhcpPxeIpLast='||>~>||'
- responseDhcpPxeCount='||>~>|0|'
- responseDhcpFirst='||>~>||'
- responseDhcpPrior='||>~>||'
- responseDhcpLast='||>~>||'
- responseDhcpIpLast='||>~>||'
- responseDhcpCount='||>~>|0|'
................................................................................
...Current Entry: 00-50-12-34-4b-aa
- responseDhcpMacDash='00-50-12-34-4b-aa'
- asOf='20190425-234339~3'
- dbTable='responseDhcp'
- responseDhcpMacColon='00:50:12:34:4b:aa'
- responseDhcpPxeFirst='2019-04-25 23:40:07'
- responseDhcpPxePrior='2019-04-25 23:42:35'
- responseDhcpPxeLast='2019-04-25 23:42:37'
- responseDhcpPxeIpLast='192.168.49.128'
- responseDhcpPxeCount='5'
- responseDhcpFirst='2019-04-25 23:41:01'
- responseDhcpPrior='2019-04-25 23:41:27'
- responseDhcpLast='2019-04-25 23:43:39'
- responseDhcpIpLast='192.168.49.129'
- responseDhcpCount='5'
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
---> key response, or "v" for view options, "q" to quit
# ^^^^^ Review above selected entry: 00-50-12-34-4b-aa :3): q
