Report on software users

How can I run a report to list the users who have a particular unmanaged item of software on their computers?

More generally where can I find an ERD of the database so that I can develop my own queries?

Thanks
John