reporting SysAdmins | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

reporting SysAdmins

Im looking for a script that will return all the SysAdmins of numerous SQL servers. Id like the output to include server name and all the Sysadmins for each server. Ideally piping output to .pdf. Anyone with suggestions? my output looks like this (its ugly!): ================================================= sysadmin
MSADww_nt_dba 0x010500000000000515000000ADCD10C1047E4D9549A099426F4B0000
sysadmin
PAWDIST01SQLAgentCmdExec 0x010500000000000515000000FD77B1564B2CBC1A43170A32EF030000
sysadmin
sa 0x01 (5 rows affected)
1>
C:TEMP>type pawdist01-sqlagent.txt
1> 2> 3> ServerRole
MemberName MemberSID
———————————–
—————————————————————-
———————————————————
—————————————————————-
—————————————————————-
——————————
sysadmin
MSADatmexec 0x010500000000000515000000ADCD10C1047E4D9549A099427C890000
sysadmin
MSADobk 0x010500000000000515000000ADCD10C1047E4D9549A09942FC620000
sysadmin
MSADww_nt_dba 0x010500000000000515000000ADCD10C1047E4D9549A099426F4B0000
sysadmin
PAWDIST01SQLAgentCmdExec 0x010500000000000515000000FD77B1564B2CBC1A43170A32EF030000
sysadmin
sa 0x01
=============================================== Thanks in advance for any help Dan
May use SELECT name
FROM sysusers
WHERE name = USER_NAME(1)
GO
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>