rickrude11
IS-IT--Management
Hi experts.
I have a table that collects netflow traffic from multiple devices and it is MASSIVE. To be able to report on that in a timely manor I would like to split it up into separate tables based on the IP address of the sending device.
The reason for this is because all the reports will be run based soley on each sender, not as a whole (make sense?)
Is this possible using a trigger? The senders IP address is in a field called 'senderip', so I would like to create a table dynamically called `senderip_flows` for each sender's IP address, and add each row.
Maybe there is a better way
Thanks for any input.
rick
I have a table that collects netflow traffic from multiple devices and it is MASSIVE. To be able to report on that in a timely manor I would like to split it up into separate tables based on the IP address of the sending device.
The reason for this is because all the reports will be run based soley on each sender, not as a whole (make sense?)
Is this possible using a trigger? The senders IP address is in a field called 'senderip', so I would like to create a table dynamically called `senderip_flows` for each sender's IP address, and add each row.
Maybe there is a better way
Thanks for any input.
rick