In the process of arranging a support call with ManageEngine for this issue, but thought I'd throw it out into the community and see if anyone else can let me know if I have misconfigured something or they are experiencing a similar situation...

(This occurred after moving from build 8206-9003)

Issue: 

Reports existing (created previously in build 8206) and created using the Custom Reports wizard (in build 9003) stopped returning Change Records they should based on the filters.  Turns out that any Change with a Site specified will not return in any Report that we have tested so far.

When I took a look at one of the newly created reports in the Query Editor, I found that the logic contained " SITEID IS NULL", which was  not specified in the filters set for the report

 

i.e.

Custom (build 9003) Changes report, for all Changes created last month, pulls 13 rows (Note!! The WHERE statement highlighted area):

SELECT chdt.CHANGEID "Change ID"

       ,chdt.TITLE "Title",sdo.NAME "Site"

       ,chdt.CREATEDTIME "Created Time"

       ,chdt.SCHEDULEDSTARTTIME "Scheduled Start Time"

       ,ownaaa.FIRST_NAME "Change Owner"

FROM ChangeDetails chdt

       LEFT JOIN SDUser ownsd ON chdt.TECHNICIANID=ownsd.USERID

       LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID

       LEFT JOIN SiteDefinition siteDef ON chdt.SITEID=siteDef.SITEID

       LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID

WHERE  ((((chdt.CREATEDTIME >= 1396324800000) AND ((chdt.CREATEDTIME != 0) AND (chdt.CREATEDTIME IS NOT NULL))) AND ((chdt.CREATEDTIME <= 1398916799000) AND (((chdt.CREATEDTIME != 0) AND (chdt.CREATEDTIME IS NOTNULL)) AND (chdt.CREATEDTIME != -1)))) AND (chdt.SITEID IS NULL))

                                

                The report was generated without a filter on the 'Site' attribute:

                               

Note!! This should have pulled 29 rows (corrected query below)

SELECT chdt.CHANGEID "Change ID"

       ,chdt.TITLE "Title",sdo.NAME "Site"

       ,chdt.CREATEDTIME "Created Time"

       ,chdt.SCHEDULEDSTARTTIME "Scheduled Start Time"

       ,ownaaa.FIRST_NAME "Change Owner"

FROM ChangeDetails chdt

       LEFT JOIN SDUser ownsd ON chdt.TECHNICIANID=ownsd.USERID

       LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID

       LEFT JOIN SiteDefinition siteDef ON chdt.SITEID=siteDef.SITEID

       LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID

WHERE  ((chdt.CREATEDTIME >= 1396324800000) AND (chdt.CREATEDTIME <= 1398916799000))