UFN_USAGEREPORT_GETREPORTVALUES

            CREATE function dbo.UFN_USAGEREPORT_GETREPORTVALUES
            (
                @ASOFDATE datetime
            )
            returns table
            as
            return
                (
                    select
                        (select top 1 INSTALLATIONNAME from dbo.INSTALLATIONINFO) as ORGANIZATIONNAME,
                        dbo.UFN_DATE_GETEARLIESTTIME(@ASOFDATE) as STARTDATE,
                        dbo.UFN_DATE_GETEARLIESTTIME(getdate()) as ENDDATE,
                        (select count(ID) from dbo.appuser) as APPUSERCOUNT,
                        ((select count(ID) from dbo.appuser where ISSYSADMIN = 0) - (select count(APPUSERID) from dbo.V_USAGEREPORT_USERSWITHEDITRIGHTS)) as READONLYUSERCOUNT,
                        (select count(ID) from dbo.constituent where isinactive = 1) as INACTIVECONSTITUENTCOUNT,
                        (select count(ID) from dbo.constituent where isinactive = 0) as ACTIVECONSTITUENTCOUNT,
                        (select count(ID) from dbo.constituent where (dateadded >= dbo.UFN_DATE_GETEARLIESTTIME(@ASOFDATE) or @ASOFDATE is null)) as CONSTITUENTSADDEDSINCECOUNT,
                        (
                            select count(distinct REVENUE.ID) 
                            from dbo.REVENUE inner join dbo.REVENUESPLIT on REVENUE.ID = REVENUESPLIT.REVENUEID 
                            where (REVENUE.DATEADDED >=dbo.UFN_DATE_GETEARLIESTTIME(@ASOFDATE) or @ASOFDATE is null)
                                and (REVENUE.TRANSACTIONTYPECODE in (1,4) or (REVENUE.TRANSACTIONTYPECODE = 0 and REVENUESPLIT.APPLICATIONCODE not in (2,6)))
                        ) as REVENUEADDEDSINCECOUNT,
                        (
                            select count(distinct REVENUE.ID) 
                            from dbo.REVENUE inner join dbo.REVENUESPLIT on REVENUE.ID = REVENUESPLIT.REVENUEID
                            where REVENUE.TRANSACTIONTYPECODE in (1,4) or (REVENUE.TRANSACTIONTYPECODE = 0 and REVENUESPLIT.APPLICATIONCODE not in (2,6))
                        ) as REVENUECOUNT,
                        (select count(ID) from dbo.EVENT where (dateadded >=dbo.UFN_DATE_GETEARLIESTTIME(@ASOFDATE) or @ASOFDATE is null)) as EVENTSADDEDSINCECOUNT,
                        (select count(ID) from dbo.REGISTRANT where (dateadded >=dbo.UFN_DATE_GETEARLIESTTIME(@ASOFDATE) or @ASOFDATE is null)) as REGISTRANTSADDEDSINCECOUNT,
                        (select count(ID) from dbo.VOLUNTEER) as VOLUNTEERCOUNT,
                        (select count(ID) from dbo.JOB where (dateadded >= dbo.UFN_DATE_GETEARLIESTTIME(@ASOFDATE) or @ASOFDATE is null)) as JOBSADDEDSINCECOUNT,
                        (select count(ID) from dbo.SYSTEMROLE) as SYSTEMROLECOUNT,
                        (select count(ID) from dbo.SITE) as SITECOUNT
                        /*,
                        (select TYPE, AUTHOR, NAME, DESCRIPTION from dbo.V_USAGEREPORT_CUSTOMCATALOGCOMPONENTS order by TYPE, AUTHOR for xml raw('CUSTOMCOMPONENT'),type,elements,BINARY BASE64) as CUSTOMCOMPONENTS
                        */
                );