question

sag asked May 12, '20

1) I want query to Identify and report on any logins within Production databases that include "test" , "QA" , "UAT".

I want query to Identify and report on any logins within Production databases that include "test" , "QA" , "UAT".

sql server

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green commented · May 12, 2020 at 07:14 PM

Not much to go on there I'm afraid.

Do you want a list of users inside the PROD database which contain the phrase TEST, QA, UAT?

SELECT name FROM sys.database_principals where name like '%test%' or name like '%QA%' or name like '%UAT%'

0 ·