my first post ... please be gentle.
I have been working on a script to get info out of mysql. Its a support ticket system database OTRS. I can write the subject of open tickets to a text file with a unique user id.
I also have a text file with the unique user id, username and email adres. I gues it is possible to combine these files so i can mail the open support tickets to the responsible support engineer. I just cant figure out how to do so.
Example of the open support tickets text file:
id ticket subject
1 10000302 Server SYS volume out of disk space
1 10000646 User synchronisation aborted
1 10000684 GWGuardian fallback / defect powersupply
2 10000693 Set up a ftp server
5 10000719 Firewall port
5 10000750 Defect SAN controller
The user file looks like this:
id user email
1 Some User
Some.user@local.nl
2 Other User
Other.user@local.nl
3 xxx xxx
xxx.xxx@local.nl
etc
I would like to send a list once a week with open support tickets to each engieer. Can anybody point me in the right direction or have a example for this?
many thanks in advance