seetsq FAQ's Page
|
What is Seetsq?
Seetsq provides a simple command line script capable of performing all types
of query information on given query items. The script is light weight,
and provides the user with different output options. This script should be
considered the CLI of the Grunt UI tool.
|
|
Seetsq Requirements?
Seetsq requires 3 things on a server to work:
- Perl
- curl command
- Access to port 443 on grunt.sac.fedex.com
The perl script runs a wget command to submit, and retrieve the results from the Grunt server. If the script cannot connect to grunt.sac.fedex.com:443, then the script will not work. Perl assembles the arguments, and submits them via a json call using the unix/linux curl command.
|
|
How to Get Seetsq
seetsq is available in the Atlas repo as an RPM packages, similair to mkacct, darth, tesla, and other SSA tools. If you don't have the repo yet, you can do the following:
Add the entry below to a new file in /etc/yum.repos.d directory:
[ssa_tools-distro]
name=SSA Tools Repo
baseurl=http://[SERVER NAME]/yum/application/ssatools/RHEL[OS VERSION]
enabled=1
gpgcheck=0
The [OS VERSION] should be replaced with the linux version of redhat you are running[5|6].
The [SERVER NAME] should be replaced with one of the following servers, depending
on the area your mkacct server resides in:
| Network Area |
Yum Repo Server |
| WTC Prod BO |
repo-wtc-bo.sac.fedex.com |
| EDCW Prod BO |
repo-edc-bo.sac.fedex.com |
| WTC Prod CF |
repo-wtc-cf.sac.fedex.com |
| EDCW Prod CF |
repo-edc-cf.sac.fedex.com |
| WTC UTE BO |
repo-wtc-bo.idev.fedex.com |
| EDCW UTE BO |
repo-edc-bo.idev.fedex.com |
| WTC UTE CF |
repo-wtc-cf.idev.fedex.com |
| EDCW UTE CF |
repo-edc-cf.idev.fedex.com |
| WTC DCCF (Dotcom L4) |
repo-wtc-dccf.idev.fedex.com |
| EDCW DCCF (Dotcom L4) |
repo-edc-dccf.idev.fedex.com |
After installing the repo, you should be able to perform:
yum install seetsq
This package installs one script into /usr/bin called seetsq.
|
|
How to Use?
Seetsq takes a parent argument for the type of work needed. This list can be gotten by performing:
seetsq -H
This returns the list of all parent items available in seetsq. To drop down into further options, you can run:
seetsq [PARENT} -h
Which will return all options available for that parrent command. The parent option MUST come before the arguments used for that parent option. Any options that come prior to the parent will be applied to the seetsq script directly, and not to the parent request. The options to the parent request item range from full output dumps, to specific items, to performing certain functions.
|
|
Show Examples
If you need LDAP information for unix account information, hashes being set, or list of team information/contact, you can run:
[root@whopper bin]# ./seetsq ldap 418997
Name: Frank Thompson Status: Active
Title: Engineering Specialist Advisor Hashes Set: YES
E-Mail: fwthompson@fedex.com
FedEx ID#: 418997
Department: Distributed Systems
Manager: Andrea Ards (838044)
Phone: +1 (719) 484-2287
Mobile: 719-502-6508
Pager:
Address: 350 Spectrum Loop
Colorado Springs, CO 80921
[root@whopper bin]# ./seetsq ldap 418997 -g
Team Roster for Andrea Ards TITLE: Manager IT
LDAP ID Employee Name Email Address Phone
--------------------------------------------------------------------------------------------------------------
36919 Clayton Roderick cjroderick@fedex.com +1 (901) 921-6904
51989 Martinez Gregory mgregory@fedex.com +1 (901) 263-2816
68768 Tywoner Jelks tjelks@fedex.com +1 (901) 263-6287
79536 Neville Hess nlhess@fedex.com +1 (901) 263-2809
151282 Hervin Wright hervin.wright@fedex.com +1 (719) 484-2039
206722 Sonya Bell sonya.bell@fedex.com +1 (901) 263-9326
301424 Jeffrey Griffith jagriffith@fedex.com +1 (901) 263-2727
316815 William Kyle wjkyle@fedex.com +1 (901) 263-2756
355449 Anthony Cole arcole@fedex.com +1 (719) 484-2506
375010 Kevin Rhodes krrhodes@fedex.com +1 (901) 263-2810
384345 Chong Ng cyng@fedex.com +1 (719) 484-2885
393091 Scott Duesterhaus msduesterhaus@fedex.com +1 (901) 263-4669
418997 Frank Thompson fwthompson@fedex.com +1 (719) 484-2287
491624 Leeann Russell lrussell@fedex.com +1 (901) 263-2742
838044 Andrea Ards andrea.ards@fedex.com +1 (901) 263-8588
[root@whopper bin]#
If you need to know information about DNS names that are incomplete, or what they point too:
[root@whopper bin]# ./seetsq dns tesla
Record Name Type Value TTL DARTH
============================ ===== ================================= ===== ============================
teslainfo.rmtc.fedex.com CNAME tslada01.rmtc.fedex.com 3600 RMTC DNS (https://dns.rmtc.fedex.com/)
165.150.88.22 PTR tesla2.rmtcdev.fedex.com 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
tesla.rmtc.fedex.com CNAME tslada01.rmtc.fedex.com 3600 RMTC DNS (https://dns.rmtc.fedex.com/)
teslasssd.ute.fedex.com A 10.250.6.59 3600 UTE DNS (https://dns.ute.fedex.com/)
tesla8.ute.fedex.com A 10.250.6.60 3600 UTE DNS (https://dns.ute.fedex.com/)
165.150.88.46 PTR tesla3.rmtcdev.fedex.com 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
tesla-193.lab.pa.fedex.com A 10.255.193.13 3600 PA Lab DNS (https://dns.pa.fedex.com/)
tesla6.rmtcdev.fedex.com A 165.150.88.49 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
calendar.rmtcdev.fedex.com CNAME tesla1.rmtcdev.fedex.com 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
165.150.88.21 PTR tesla1.rmtcdev.fedex.com 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
tesla3.rmtcdev.fedex.com A 165.150.88.46 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
tslada01.rmtc.fedex.com RP tesladb tesladb.rmtc.fedex.com 3600 RMTC DNS (https://dns.rmtc.fedex.com/)
tslada01.rmtc.fedex.com TXT cname:teslainfo.rmtc.fedex.com 3600 RMTC DNS (https://dns.rmtc.fedex.com/)
tslada01.rmtc.fedex.com RP teslainfo teslainfo.rmtc.fedex.com 3600 RMTC DNS (https://dns.rmtc.fedex.com/)
tslada01.rmtc.fedex.com TXT cname:tesla.rmtc.fedex.com 3600 RMTC DNS (https://dns.rmtc.fedex.com/)
tslada01.rmtc.fedex.com TXT cname:tesladb.rmtc.fedex.com 3600 RMTC DNS (https://dns.rmtc.fedex.com/)
tslada01.rmtc.fedex.com RP tesla tesla.rmtc.fedex.com 3600 RMTC DNS (https://dns.rmtc.fedex.com/)
vm196237.lab.pa.fedex.com RP tesla tesla.lab.pa.fedex.com 3600 PA Lab DNS (https://dns.pa.fedex.com/)
vm196237.lab.pa.fedex.com TXT cname:tesla.lab.pa.fedex.com 3600 PA Lab DNS (https://dns.pa.fedex.com/)
drh00172.ute.fedex.com RP tesla tesla.ute.fedex.com 3600 UTE DNS (https://dns.ute.fedex.com/)
drh00172.ute.fedex.com TXT cname:tesla.ute.fedex.com 3600 UTE DNS (https://dns.ute.fedex.com/)
tesla9.rmtcdev.fedex.com TXT 3134fac8760da3884baa2e7056864a762b 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
tesla9.rmtcdev.fedex.com A 165.150.88.50 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
tesla-194.lab.pa.fedex.com A 10.255.194.13 3600 PA Lab DNS (https://dns.pa.fedex.com/)
tesla5.rmtcdev.fedex.com A 165.150.88.48 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
165.150.88.47 PTR tesla4.rmtcdev.fedex.com 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
tesladb.rmtc.fedex.com CNAME tslada01.rmtc.fedex.com 3600 RMTC DNS (https://dns.rmtc.fedex.com/)
tesla.ute.fedex.com CNAME drh00172.ute.fedex.com 3600 UTE DNS (https://dns.ute.fedex.com/)
tesla4.rmtcdev.fedex.com A 165.150.88.47 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
tesla.lab.pa.fedex.com CNAME vm196237.lab.pa.fedex.com 3600 PA Lab DNS (https://dns.pa.fedex.com/)
countdown.rmtcdev.fedex.com CNAME tesla1.rmtcdev.fedex.com 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
tesla_prod.rmtc.fedex.com CNAME drh00069.rmtc.fedex.com 3600 RMTC DNS (https://dns.rmtc.fedex.com/)
10.250.6.59 PTR teslasssd.ute.fedex.com 3600 UTE DNS (https://dns.ute.fedex.com/)
tesla2.rmtcdev.fedex.com A 165.150.88.22 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
cvs.ute.fedex.com CNAME tesla1.rmtcdev.fedex.com 3600 UTE DNS (https://dns.ute.fedex.com/)
tesla1.rmtcdev.fedex.com A 165.150.88.21 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
nicet.ute.fedex.com CNAME tesla1.rmtc.fedex.com 3600 UTE DNS (https://dns.ute.fedex.com/)
10.255.194.13 PTR tesla-194.lab.pa.fedex.com 300 PA Lab DNS (https://dns.pa.fedex.com/)
165.150.88.48 PTR tesla5.rmtcdev.fedex.com 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
165.150.88.49 PTR tesla6.rmtcdev.fedex.com 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
tools.rmtcdev.fedex.com CNAME tesla1.rmtcdev.fedex.com 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
10.250.6.60 PTR tesla8.ute.fedex.com 3600 UTE DNS (https://dns.ute.fedex.com/)
tesla1.lab.pa.fedex.com CNAME vm197198.lab.pa.fedex.com 3600 PA Lab DNS (https://dns.pa.fedex.com/)
mkacct.ute.fedex.com CNAME tesla1.rmtcdev.fedex.com 3600 UTE DNS (https://dns.ute.fedex.com/)
165.150.88.50 PTR tesla9.rmtcdev.fedex.com 3600 rmtcdev DNS (https://dns.rmtcdev.fedex.com/)
Record Count: 45
[root@whopper bin]#
Server Informatio/EAI Number relationships, can run:
[root@whopper bin]# ./seetsq server c0002698.test.cloud.fedex.com
----------------------------------------------------------------------------------
ACCOUNT TOOL INFORMATION
----------------------------------------------------------------------------------
Account Tool: mkacct Status: Active
Account Tool Desc: Mkacct Prototype System Support Area: Infrastructure Support
Account Master Server: drh00491.ute.fedex.com PDSM Support Group: PDSM_SA_INF_SUPPORT
Cluster Name: cluster1 Root Password: CAPAM -> pam.ute.fedex.com Server -> drh00400.ute.fedex.com
----------------------------------------------------------------------------------
OVO INFORMATION
----------------------------------------------------------------------------------
OVO Master Server: qhp00101.inf.fedex.com Node Monitoring Status: No -o option passed, not checked
----------------------------------------------------------------------------------
VE INFORMATION
----------------------------------------------------------------------------------
VCenter Server: vcmembo2.ve.fedex.com CPU Count: 1
VCenter Folder: /Cloud/unit Memory Size: 2
----------------------------------------------------------------------------------
PDSM INFORMATION
----------------------------------------------------------------------------------
Class Name: Linux Server Platform OS: Linux Red Hat
Vendor Name: VMware, Inc. Virtualized Computer OS Version: 7.7
Location: WTC-10-DC-WTC-10 IP Address: 10.255.140.82
SA PDSM Group: FXS_SA_HCL Server Status: Installed
Environment: Development Security Zone: wtc_bo
EAI Name EAI Number EAI IT Lead EAI Owner PDSM Group Status
==================================================================================================================================
EIS-AppDeployment-Repositories 7415 Kelly Whigham Franklin Beattie Mainstream
----------------------------------------------------------------------------------
NOTES
----------------------------------------------------------------------------------
Server Note -> Date: 05/01/2020 11:09:44 Author: 418997
UTE Jump Server
Cluster Note -> Date: 08/11/2020 06:29:58 Author: 418997
Cluster has been disolved, so please don't attach to another server.
[root@whopper bin]#
If you want specific key values, you can use the -k option to show available keys, and then request them with the -c option. If you have a list of servers in a file, 1 per line, you can add the -f option for the file:
[root@whopper bin]# ./seetsq server -f /tmp/frank -c "OVO_MASTER_SERVER,VE_CENTER_SERVER"
Server Name OVO_MASTER_SERVER VE_CENTER_SERVER
c0002698.test.cloud.fedex.com qhp00101.inf.fedex.com vcmembo2.ve.fedex.com
drh00172.ute.fedex.com No OVO Admin Server found. Not Found
Server Login commands can be run as such:
-bash-4.1$ seetsq server urh70263 -l 418997 -r "date"
Executing: ssh urh70263.ute.fedex.com -l ft418997 date
ft418997@urh70263.ute.fedex.com's password:
Thu Sep 24 18:44:31 GMT 2020
-bash-4.1$
If you need to pass options to the ssh, or commands, or both, can pass in arguments to the seetsq command( use seetsq server ?h ) for list of options:
-bash-4.1$ seetsq server urh70263 -l 418997 -p " -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no" -s -r "ls /opt/fedex"
Warning: Permanently added 'urh70263.ute.fedex.com,10.250.55.65' (RSA) to the list of known hosts.
ft418997@urh70263.ute.fedex.com's password:
ce
eieio
hermes
lost+found
redisadmin
splunk
-bash-4.1$
Lookup LDAP phone number matches, can run something like:
-bash-4.1$ ./seetsq ldap -phone 2201
LDAP Name LDAP ID Work Number Mobile Number Status
========================================================================================================================
David Pramuk 753393 +1 (814) 207-2201 +1 (814) 2072201 Active
Kyle Schneiderlochner 2369417 +1 (412) 8592201 Active
Martin Hebert 405784 +1 (450) 766-1549 x2201 +1 (514) 9680373 Active
Calvin Shaw 103475 +1 (770) 992-7641 +1 (404) 4312201 Active
Barry Davidson 5107789 +1 (289) 398-2201 Active
Shannen Gagnon 3937940 +1 (450) 7661549 x2201 Active
Maruchi Torres 90664 +1 (787) 300-2200 x2201 +1 (787) 6494945 Active
BRIAN SCHENK 5222653 +1 (901) 224-5450 +1 (858) 3952201 Active
Chris Bradley 2376 305-876-2201 Inactive
Jackie Austin 1455756 870-715-6470 870-754-2201 Active
Himanshu Bhushan Gaur 5085741 +91 01246732201 Active
Jennifer Fletcher 3949684 +1 (289) 3982201 Active
Henry Wiseman 399849 404-684-2201 Inactive
Jeff Anson 131967 +1 (289) 398-2201 +1 (289) 6967071 Active
Kai Uwe Wenzel 611355 +4922039052201 +4915142217992 Active
Charles Almquist 760897 +1 (970) 3281430 +1 (303) 6382201 Active
Gary Gribble 5073776 289/398-2201 Inactive
Christle Sheats 2662395 901-468-2201 Active
Manoj Mehndiratta 3745155 +91 615212201 +91 (89010) 04485 Active
Madonna Marsters 1398322 541-607-3160 541-206-2201 Active
Roland Doiron 132332 +1 (866) 964-5500 x6122201 Active
MARGARITA ROMAN (OSV) 745049 +1 7873002201 Active
Jian-Ping Jiang 5304417 +86 13482642201 +86 13482642201 Active
Paula Hebert 266064 719-484-2201 719-659-9693 Inactive
-bash-4.1$
|
|
Best Use Practice
Easiest way to not have to get too involved in seetsq is to set up aliases in your .bashrc file. Here are some sample items you can put into your .bashrc file to make seetsq easier to use:
| .bashrc entry |
Output/Info |
| alias ldap='seetsq ldap' | Look up information for an LDAP ID or Name |
| alias ldapgroup='seetsq ldap -g' | Look up management/team information for a given ldap id/name |
| alias login='seetsq server -l 418997' | Basic login to a linux server |
| alias xlogin='seetsq server -l 418997 -p "-o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no" -s' | Login with specific settings on how to login. |
| alias server='seetsq server' | Find all information known in grunt about the server |
| alias acctserver='seetsq server -c ACCOUNT_TOOL_SERVER' | Find the account management server that is managing the given server. |
| alias eai='seetsq eai' | Find all information from Platinum Exchange about a given EAI number |
| alias eaiserver='seetsq server -c PDSM_EAI_ID' | Find all EAI numbers the given server supports. |
| alias findphone='seetsq ldap -phone' | Lookup a 4 digit phone number(or more) to find matching LDAP ID/Name. |
|
|
