[racktables-users] Re: Noob assistance IP calculation assistance

  • From: James S <vahokie94@xxxxxxxxxxx>
  • To: <racktables-users@xxxxxxxxxxxxx>
  • Date: Tue, 6 Mar 2012 15:23:58 -0500

I did a little more research and was able to create some pretty basic SQL 
queries that I ran individually in PhpMyAdmin, I then exported them. Is there 
an easier way?
Here are two of the queries:
SELECT name, INET_NTOA(ip)FROM IPv4NetworkLIMIT 0 , 30;
SELECT name,reserved, INET_NTOA(ip)FROM IPv4AddressLIMIT 0 , 30;
Should I be manually running them there or is there a better way to store the 
SQL query so I can run it periodically?

The Stockdale paradox

> From: infrastation@xxxxxxxxx
> To: racktables-users@xxxxxxxxxxxxx
> Subject: [racktables-users] Re: Noob assistance IP calculation assistance
> Date: Mon, 5 Mar 2012 15:01:46 +0400
> 
> 01.03.2012, 23:47, "James S" <vahokie94@xxxxxxxxxxx>:
> > I am new to Rack Tables. I am using it to track VMs in a small test 
> > environment.
> > I would like to print reports of IP space usage etc. I saw that in late 
> > 2011 (Nov) someone posted about how to take the values from the database 
> > and use the INET_NTOA/INET_ATON functions to convert the value to a 
> > 'normal' IP value. 
> > http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton
> > Would someone be able to share an SQL query that provides a report of IP 
> > addresses in use, or point to a FAQ that shows me how to do it?
> > Thanks,
> > James
> 
> Hello, James.
> 
> The right answer varies depending on the data you are looking to extract and 
> process. Do you have any design sample?
> 
> -- 
>  Denis Ovsienko
> 
                                          

Other related posts: