SCOM APM query

SELECT * FROM [OperationsManager].[apm].[V_APPLICATIONSOURCEMACHINE]

where MACHINENAME like '%Jimmy-Agent%'

SELECT * FROM [OperationsManager].[apm].[V_EVENT]

where MACHINENAME like '%Jimmy-Agent%'

SELECT * FROM [OperationsManager].[apm].[V_EXCEPTIONEVENT]

where MACHINENAME like '%Jimmy-Agent%'

SELECT * FROM [OperationsManager].[apm].[V_PCCONFIG]

where MACHINE like '%Jimmy-Agent%'

SELECT * FROM [OperationsManager].[apm].[V_PM_EVENT]

where MACHINENAME like '%Jimmy-Agent%'

SELECT * FROM [OperationsManager].[apm].[VEVENTSYNC]

where MACHINENAME like '%Jimmy-Agent%'

SELECT *  FROM [OperationsManager].[apm].[VPERFHOURLYSYNC]

where MACHINENAME like '%Jimmy-Agent%'

SELECT * FROM [OperationsManagerDW].[apm].[V_APPLICATIONSOURCEMACHINE]

where MACHINENAME like '%Jimmy-Agent%'

SELECT *  FROM [OperationsManagerDW].[apm].[V_PM_EVENT]

where MACHINENAME like '%Jimmy-Agent%'

SELECT * FROM [OperationsManagerDW].[apm].[V_EVENTWINDOW]

where MACHINE like '%Jimmy-Agent%'