Difference between revisions of "Msdquerydb provider-1 command line query tool"

Latest revision as of 15:56, 12 April 2013

mdsquerydb

Provider-1 Command-Line Database Query Tool
Usage: mdsquerydb key_name [-f output_file_name]

Currently running in MDS environment.

Keys for MDS environment:
-------------------------
GlobalNetworkObjects    # Get name and type of all global network objects
NetworkObjects          # Get all customers' internal Check Point installed network objects
Customers               # Get names of all PV-1 Customers
Administrators          # Get names of all PV-1 Administrators
MDSs                    # Get names and IPs of all MDSs
CMAs                    # Get names of all CMAs
GuiClients              # Get names and IPs of all gui clients

Keys for CMA environment:
-------------------------
NetworkObjects          # Get name and type of all network objects
Gateways                # Get names and IPs of all gateways

get list of firewalls (check point objects no counting CMAs)

mdsquerydb NetworkObjects|grep -v cma|awk -F _ '{print $1}'> firewalls.txt