Account Details

Account Details

Query

SELECT accountdefinition.org_name, 
  accountdefinition.support_email, 
  accountdefinition.sendername, 
  accountdefinition.login_uri, 
  aaacontactinfo.emailid, 
  aaacontactinfo.landline, 
  aaacontactinfo.mobile, 
  aaacontactinfo.fax, 
  aaacontactinfo.web_url, 
  aaacontactinfo.res_phone, 
  aaapostaladdress.door_no, 
  aaapostaladdress.street, 
  aaapostaladdress.location, 
  aaapostaladdress.landmark, 
  aaapostaladdress.city, 
  aaapostaladdress.postalcode, 
  aaapostaladdress.state, 
  aaapostaladdress.country FROM accountdefinition, 
  sdorgcontactinfo, 
  aaacontactinfo, 
  sdorgpostaladdr, 
  aaapostaladdress WHERE  accountdefinition.org_id = sdorgcontactinfo.org_id AND
  accountdefinition.org_id = sdorgpostaladdr.org_id AND
  sdorgcontactinfo.contactinfo_id = aaacontactinfo.contactinfo_id AND
  sdorgpostaladdr.postaladdr_id = aaapostaladdress.postaladdr_id;


Krishna Bharat

ServiceDesk Plus - MSP Support team
              New to ADManager Plus?

                New to ADSelfService Plus?