[freeside-users] Query of invoice line items for service broadband

[Gilbert Rebeiro]

Hi,

I am looking for a way to query postgres for all invoiced line items 
that contain a specific string.
I am being audited.

These are all svc_broadband services

I can see the string on a sample invoice but I don't know the proper 
query to get the historical line items.

as an example
this is custnum 305
invoice num 16559
The line item shows
2675     Cable Hi-Speed  (2009/02/01 - 2009/03/01)    $19.12
     - Videotron Cable: SN: 101740526 - VLJMBYYY - customer name
     - customer address



So I need a query that shows all invoice numbers and invoice dates that 
were issued with VLJMBYYY in the description.

Is this possible?

Thanks in advance.
Love freeside!!

Gilbert.