• Sign in to Neowin Faster!

    Create an account on Neowin to contribute and support the site.

  • 0
Sign in to follow this  

Ideas for firewall port opening request form

Question

nabz0r    146

As the title says, I am looking for ideas on how to create a form. The solution we have today doesn't really work as people don't listen and they often don't send ut everything. What I mean is that they fill out either name of the system or IP address when they request port opening and it's very annoying for us to do their job and fill out the form for them and then do the opening.

 

Now what I want is a form that is mandatory fill out source ip/name, destination ip/name port and protocol before they're allowed to move to a new line. Is this even possible in excel or do I need to look for 3rd party solutions?5aa684a053c8d_Skarmavbild2018-03-12kl_14_39_16.thumb.png.e65d91006fccdf53280a9020b41af76a.png

 

 

Share this post


Link to post
Share on other sites

11 answers to this question

Recommended Posts

  • 0
+Zag L.    707

Can't you just write some simple VBA code behind that sheet to enforce your rules?

  • Like 1

Share this post


Link to post
Share on other sites
  • 0
nabz0r    146
5 minutes ago, Zag L. said:

Can't you just write some simple VBA code behind that sheet to enforce your rules?

I haven't heard of VBA before so I am not familiar with it. Is it possible to do that?

Share this post


Link to post
Share on other sites
  • 0
+Zag L.    707

Google VBA and Excel. There are a boat load of good tutorials and guides to help you do what you are looking to do.  Here is just one of a million examples

  • Like 1

Share this post


Link to post
Share on other sites
  • 0
nabz0r    146
2 minutes ago, Zag L. said:

Google VBA and Excel. There are a boat load of good tutorials and guides to help you do what you are looking to do.  Here is just one of a million examples

Thanks! I'll take a look at it and try to figure how to write code a specific for my needs.

Share this post


Link to post
Share on other sites
  • 0
xendrome    5,475

Could use Wordpress and Contact Form 7 plugin. Then you would have a custom form you can make that would generate an e-mail to the I.T. group. If you can host it internally.

Share this post


Link to post
Share on other sites
  • 0
nabz0r    146
7 minutes ago, xendrome said:

Could use Wordpress and Contact Form 7 plugin. Then you would have a custom form you can make that would generate an e-mail to the I.T. group. If you can host it internally.

This sounds good, but I'll try to do it with excel as it doesn't require hosting, etc. A simple sheet that has to be filled before they close it.

Share this post


Link to post
Share on other sites
  • 0
billyballbag    33

Do you have Office 365?  You can easily create a form using Sharepoint and/or PowerApps

Share this post


Link to post
Share on other sites
  • 0
nabz0r    146
2 minutes ago, billyballbag said:

Do you have Office 365?  You can easily create a form using Sharepoint and/or PowerApps

Yes, we're using Office 365. Is it easy to create and use?

Share this post


Link to post
Share on other sites
  • 0
billyballbag    33

Creating a form in Sharepoint is very straight forward :)

Share this post


Link to post
Share on other sites
  • 0
satukoro    1,350

I'm surprised you get enough port opening requests to warrant a form, surely there's a better approach to allowing specific traffic?

Share this post


Link to post
Share on other sites
  • 0
nabz0r    146

It seems that we're going to use SharePoint so thank you guys for the suggestions. :)

 

@satukoro, why are you surprised?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.