topic Re: Show total number of objects in database in API / CLI Discussion

Show total number of objects in database

J_Saun — Thu, 11 Apr 2019 14:15:58 GMT

Is there a way from either the command line or in the gui to show the total number of objects in the objects_5_0.C file? Specifically for R65 and R77.

Thx

Re: Show total number of objects in database

JozkoMrkvicka — Thu, 11 Apr 2019 20:55:49 GMT

Hi,

For SMS via CLI:

cat $FWDIR/conf/objects_5_0.C | grep -c ":table ("

For MDS via CLI:

mdsenv <DOMAIN_NAME> cat $FWDIR/conf/objects_5_0.C | grep -c ":table ("

If needed, you can search for a specific table, like network_objects (for all network objects) or services (for all services).

echo -n "There are ";cat $FWDIR/conf/objects_5_0.C | grep -c ":table (network_objects)" | tr -d "\n"; echo " network objects."

Output:

Re: Show total number of objects in database

J_Saun — Fri, 12 Apr 2019 11:44:16 GMT

Thanks Jozko. That worked perfectly and was exactly what I needed.

Re: Show total number of objects in database

JozkoMrkvicka — Sat, 13 Apr 2019 12:17:33 GMT

Glad that I helped 🙂

Another way is to use a command 'cpmiquerybin' which is capable to do more stuff like finding all network ranges, all TCP ports, all time objects and so on.