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


          • 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", ...
          • Summary of assets under each Site

            DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 SELECT regiondefinition.regionname as "Region",aaov.NAME AS "Site", (select count(*) from resources left JOIN ComponentDefinition product ON ...