custom report

hi i was wondering if someone could help, i need to compile a report that shows me all software that is prohibated, i need to show all software and the workstation that it is attached, i need to write a custom query so if anyone can help

thanks

ryan