Report for users with out servers

[PayableOnDeath]

Hi

 

is there a report or and sql query I can run which will list users that are on the system but no longer have a server setup?

 

Thanks

 

David

[w00der]

I wrote an Access Query to do all this type of stuff the SQL code for this one inpartiular is:

 

SELECT tc_users.USER_ID, tc_users.LAST_NAME, tc_users.TYPE, tc_users.EMAIL1, tc_users.PARENT_ACCOUNT, tc_users.BILLING_STATUS

FROM tc_users LEFT JOIN tc_services ON tc_users.USER_ID = tc_services.USER_ID

WHERE (((tc_services.USER_ID) Is Null));