Site details

Site details

This report is used to get the complete list of Site detail configured in the application. 

SELECT sd.name "SiteName",
       sd.Description "Description",
       regionDef.REGIONNAME "Region",
       timezonedefinition.displayname "Timezone",
       apa.DOOR_NO"Door Number",
       apa.STREET"Street",
       apa.LOCATION"Location",
       apa.LANDMARK"Land Mark",
       apa.CITY"City",
       apa.POSTALCODE"Postal Code",
       aci.Emailid "Email id",
       aci.landline"Phone number" FROM sitedefinition vd
LEFT JOIN sdorganization sd ON vd.siteid=sd.org_id
LEFT JOIN sdorgcontactinfo aoci ON sd.org_id=aoci.org_id
LEFT JOIN aaacontactinfo aci ON aoci.contactinfo_id=aci.contactinfo_id
LEFT JOIN sdorgpostaladdr spa ON spa.org_id=sd.org_id
LEFT JOIN aaapostaladdress apa ON apa.POSTALADDR_ID=spa.POSTALADDR_ID
LEFT JOIN RegionDefinition regionDef ON vd.REGIONID=regionDef.REGIONID
LEFT JOIN timezonedefinition ON vd.timezoneid=timezonedefinition.timezoneid


      New to ADManager Plus?

        New to ADSelfService Plus?

          Resources

              • Related Articles

              • Requester details

                This report is used to find the Requester complete details.  SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...
              • Software details

                SELECT systeminfo.workstationname             "Workstation",         Max(aaauser.first_name)                "User",         ( softwarelist.softwarename )          "Software_Name",         Max(softwaretype.softwaretype)         "Software_Type",  ...
              • Change details

                SELECT    chdt.changeid "Change ID",            chdt.title "Title",            Longtodate(chdt.createdtime) "Created Time",            Longtodate(chdt.scheduledstarttime) "Scheduled Start Time",  ...
              • Contract Details

                SELECT mcdt.Contractid "Contract ID", mcdt.CONTRACTNAME "Contract Name", mcdt.comments "Description", contractcategory.Categoryname "Contract Type", LONGTODATE(mcdt.CREATEDDATE) "Created Time", LONGTODATE(mcdt.FROMDATE) "From Date", ...
              • Purchase Request details

                SELECT pr.Requestid "Requestid", pr.Subject "Subject", pr.Description "Description", longtodate(pr.Requesteddate) "Requesteddate", longtodate(pr.Daterequired) "Daterequired", longtodate(pr.createddate) "createddate", pr.Shipping_details ...