This query will help you
SELECT *
FROM sys.triggers
OR
SELECT
TAB.name as Table_Name
, TRIG.name as Trigger_Name
, TRIG.is_disabled
FROM [sys].[triggers] as TRIG
inner join sys.tables as TAB
on TRIG.parent_id = TAB.object_id
for finding Disabled trigers in all databases in a server
you can use sp_MSforeachdb for this purpose like
DECLARE @command varchar(1000)
SELECT @command = 'USE ? SELECT (SELECT DB_NAME()),* FROM sys.triggers WHERE is_disabled = 1'
EXEC sp_MSforeachdb @command