We need to document our SMG! Is there a way?

2 months ago

Yes, there is a way. Fortunately this tool is already included in our SMG environment and can be used immediately. It is phpPgAdmin.

Is it simple to use? Yes and no - it depends what you want to see. This tip will show a simple approach. However it depends on you how far you want to go.

Before starting my explanation I have to warn you! Do not try to change any values! NEVER! We do not know the relationship of tables and values in the background. So changing values, columns or tables can lead into a disaster - your SMG will be out of support! Once again - do not change any values!

Now let me start what I want to show. Here is an example screenshot from my SMG:

There you see some policies on the left side and some filters on the right side. To keep it simple I want to have a list of policies.

Because of my warnings before we know how to work with phpPGAdmin now - we will access read-only and never change a value.

Log in to your SMG virtual appliance administration - usually port 9443. There you find our utility we will use in the next few minutes: phpPgAdmin.

Please select phpPgAdmin!

Touch PostgreSQL and you will be asked for a valid database user. If you did not change any values and you are using default settings then your user and password is postgres. If you have changed user and/or password then I hope you know it.Innocent

If you are successfully logged in, then you see some databases - we are only interested in database SecureGateway.

If you have selected SecureGateway then a long list of tables will be displayed. If you touch "Tables" then an enhanced information screen will appear on the right side. I.e. there is a column called "Estimated row count" which is a record counter.

But we want to get a list of policies - that is our goal!

So select table "policies" and click on "Browse" because we are not really interested in data structure but in contents.

If you check this table then you see some interesting information. I.e. you get the information which policies are enabled and disabled (=scannerenabled); searchorder will explain which policy will be handled first, second and so on.

Fine - so we have a result and it was so easy!

Nevertheless we want to use this information outside of SMG. I.e. we want to create a spreadsheet which contains all these settings. For a spreadsheet we need a csv file.

Well, so select "Export" (right corner).
Now go for "Data only" and "Format CSV". (Do you see these dangerous buttons "Drop"? Do not touch!) 

In my case I have selected "Show" - just to get a feeling. Here is my output:

I have a result which can be used for my documentation. And it was so easy! I used a utility which was already included in SMG - Blush.

Right - that was really easy. But maybe I showed you the easiest part Thinking. I did not work on relations or combinations - this can be really hard if you do not know anything about this database.

This tip was just a first step to get a feeling ...

Before closing this tip I have to repeat - do not change any values!


How To-Best Practice
Support Tip
Comment List
Related Discussions