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 M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • 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 AS "Request Id", pr.SUBJECT AS "PR Subject", pr.DESCRIPTION AS "Description", LONGTODATE(pr.REQUESTEDDATE) AS "Requested Date", LONGTODATE(pr.DATEREQUIRED) AS "Date Required", LONGTODATE(pr.CREATEDDATE) AS "Created Date", ...

                        Related Products