Which table gives me a list of subscribers to services

[mojahidm]

Hi Team,

I was hoping someone might be able to advise me on how to get a list of subscribers to a particular service?

There's the ServiceSubcriptions table

but it has no relationship that I can see.

The 'Subscriber ID' looks like the foreign key, but I've not been able to find which table it links to so that I can pull through the subscribers details (such as the organisations and contacts)

Many Thanks,

Mojahid

[Victor]

@mojahidm - there was a query around retrieving a list of service subscribers here: 

This forum thread contains an SQL query which I think will give you the list that you need. The query should be easily be put in a report but if you need help with this let us know.