select k.path, name, version, authority, team_identifier, identifier from kernel_extensions k join signature s ON k.path=s.path WHERE team_identifier != '';