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 aaaorgcontactinfo 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 ADSelfService Plus?
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 know SLAs configured and its details (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) PGSQL: select slad.slaname "SLA NAME", sdo.name "SITE", ad.org_name "ACCOUNT", slad.duebydays || ' Days,' || slad.duebyhours || ' Hours,' || slad.duebyminutes || ' Mins' "Resolved Within", ...