Show total number of objects in database

[J_Saun]

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

[JozkoMrkvicka · Accepted solution]

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:

[J_Saun]

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

[JozkoMrkvicka]

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.