How to display User Mapping for offline databases?
You can use sys.databases joined with sys.server_principals

SELECT sd.NAME AS databaseName
    ,sp.NAME AS database_owner
FROM sys.databases sd
INNER JOIN sys.server_principals sp ON sd.owner_sid = sp.SID
WHERE sd.state_desc = 'OFFLINE' --&gt; since you want for offline databases !




You can even use at your own risk --> sp_msloginmappings ( &lt;-- Undocumented and unsupported :-) )