Query a list of objects in each database
You can use the following code to list all views against all databases.
It will populate everything inside of #Result. After that, you can use your list to do joins and check whatever status you want.
IF OBJECT_ID('tempdb..#Result') IS NOT NULL  DROP TABLE #Result;
CREATE TABLE #Result
([Database] VARCHAR(100), [schema_name] VARCHAR(100), [view_name] VARCHAR(100))

DECLARE @DB SYSNAME,@cmd NVARCHAR(4000)

SET NOCOUNT ON
SET @cmd = ''

SELECT TOP 1 @DB = D.name
FROM master..sysdatabases AS D
WHERE dbid &gt; 4
    and DATABASEPROPERTYEX(D.name, 'status') = 'ONLINE'
ORDER BY D.name;

WHILE @@ROWCOUNT = 1
BEGIN
      SET @cmd = 'USE ' + @DB + ';
            INSERT INTO #Result
            SELECT  DISTINCT ''' + @DB + ''' AS CustomerNumber ,sh.name, o.name AS ObjectName
            FROM sys.objects o 
            INNER JOIN sys.schemas sh on o.schema_id=sh.schema_id
            WHERE o.type = ''V''

    ';
      EXEC (@cmd)

      SELECT TOP 1 @DB = NAME
      FROM master..sysdatabases AS D
        WHERE dbid &gt; 4
        AND DATABASEPROPERTYEX(D.name, 'status') = 'ONLINE'
            AND D.NAME &gt; @DB
      ORDER BY D.name
END

SELECT * FROM #Result R