SQL Server Admin Role Alert Script

• SQLShark

  SSCrazy

  Points: 2214

  More actions

  July 16, 2024 at 5:03 pm

  #4436761

  Comments posted to this topic are about the item SQL Server Admin Role Alert Script

• ruedifuchs

  Valued Member

  Points: 53

  More actions

  July 26, 2024 at 9:55 am

  #4440013

  further restrict in the WHERE clause to report only groups from your domain, and exclude system generated NT user accounts:

  and (

  isNTName = 1 and (

  (isNTUser = 1 and name like '<yourDomain>\%' )

  OR isNTGroup = 1

  )

  OR isNTName = 0

  )

• ruedifuchs

  Valued Member

  Points: 53

  More actions

  July 26, 2024 at 9:57 am

  #4440014

  further restrict in the WHERE clause to report only groups from your domain, and exclude system generated NT user accounts:

  and (

  isNTName = 1 and (

  (isNTUser = 1 and name like '<yourDomain>\%' )

  OR isNTGroup = 1

  )

  OR isNTName = 0

  )