Create a list of Active Vault users to a CSV or text file

[kryan762]

I need to create on a regular basis a list of active vault users .

What are my options ?

[lbauer]

Run this query against the Vault database:

use sgvault
go
select * from tblusers where Active=1
go

If you're using Query Analyzer, you can save the results by selecting File->Save As in Query Analyzer. The results will be saved in a .csv file.

[kryan762]

On similar topic can I create a list of users by group membership ?

[lbauer]

Try this:

SELECT u.login, g.name FROM
sgvault.dbo.tblusers u
INNER JOIN sgvault.dbo.tblgroupmembers gm ON (gm.userid = u.userid)
INNER JOIN sgvault.dbo.tblgroups g ON g.groupid = gm.groupid
ORDER BY u.login, g.name