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?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  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", ...

                    • How to assign a department to site and requester

                      1. How to assign department to new sites - > When a new site is created, it would have a 'General' department which would be available by default. In order to add additional departments, go to Admin - > Account details - > Departments - > select the ...

                    • 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",  ...

                    • Query to show Request and associated task details (PGSQL & MSSQL)

                      Tested in build PGSQL (14300) and MSSQL (14306) PGSQL & MSSQL: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", pd.PRIORITYNAME AS "Priority", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", ...

                      Related Products