Get an inventory of SSH Keys used by Azure DevOps Server users.

GetSSHKeyInventory.sql

use [Tfs_Configuration]

SELECT 
	id.DisplayName as 'KeyOwner',
	access_key.DisplayName as 'KeyName',
	meta.ValidFrom as 'CreatedAt',
	meta.ValidTo as 'ExpiresAt'
FROM dbo.tbl_DelegatedAuthorizationAccessKey as access_key
  left join dbo.tbl_Identity id on id.Id = access_key.IdentityId
  left join dbo.tbl_DelegatedAuthorizationAccess meta on meta.AccessId = access_key.AccessId
WHERE
    meta.IsValid = 1;